PL/SQL Developer
Ayyala Hemasree laxmiRemoteMIDPosted 11d ago
Oracle PL/SQLUNIXSQL queriesFunctionsProceduresPackagesTriggersViewsCursorsDynamic SQLTransactionsException HandlingProduction SupportDebuggingTroubleshootingData MappingData ConversionData TransformationData IntegrationQuery Performance OptimizationUNIX Shell ScriptingSQL*LoaderCron JobsHTMLJavaScriptCSSUnit TestingSDLC
About the Role
We are looking for an experienced PL/SQL Developer to join our team. This role requires strong hands-on experience in Oracle database development, UNIX, production support, and data integration.
Key Responsibilities
• Develop and maintain Oracle PL/SQL applications
• Provide production support and troubleshoot issues
• Optimize query performance using Explain Plan
• Perform data mapping, conversion, transformation, and integration
• Write SQL queries, functions, procedures, packages, triggers, views, and cursors
• Handle dynamic SQL, transactions, and exception handling
• Debug and troubleshoot production issues
• Develop UNIX Shell scripts, SQL*Loader, and Cron Jobs
• Perform unit testing and follow SDLC practices
Requirements
• 6+ years of experience in PL/SQL development
• Strong expertise in Oracle PL/SQL and UNIX
• Experience with SQL queries, functions, procedures, packages, triggers, views, and cursors
• Knowledge of dynamic SQL, transactions, and exception handling
• Experience with production support, debugging, and troubleshooting
• Skills in data mapping, conversion, transformation, and integration
• Ability to optimize query performance using Explain Plan
• UNIX Shell Scripting, SQL*Loader, and Cron Jobs experience
• Basic knowledge of HTML, JavaScript, and CSS
• Unit Testing and SDLC experience