Oracle PL/SQL Developer
Riya MalhotraMIDPosted 11d ago
Oracle PL/SQLSQL queriesProceduresFunctionsPackagesTriggersViewsMaterialized ViewsDB LinksSequencesCursorsTransactionsDynamic SQLException HandlingUNIXShell ScriptingSQL*LoaderData LoadingCRON Job AutomationExplain PlanQuery OptimizationStored Procedure OptimizationData MappingData ConversionData TransformationLegacy System IntegrationDebuggingTroubleshootingOracle Object FixesHTMLJavaScriptCSSSDLCTestingRequirements AnalysisDesignDevelopmentImplementationUnit Testing
About the Role
We are looking for an experienced Oracle PL/SQL Developer to join our team. This role focuses on database development, performance optimization, and production support.
Key Responsibilities
• Design, develop, test, and implement complex Oracle database programs
• Optimize SQL queries and PL/SQL objects for performance
• Develop UNIX scripts for automated data loading and processing
• Support third-party integrations and legacy application migrations
• Collaborate with QA teams on test planning, execution, and defect resolution
Requirements
• 6+ years of experience with Oracle PL/SQL
• Strong understanding of database concepts including DB Links, Sequences, Cursors, Transactions, Dynamic SQL, and Exception Handling
• Experience with UNIX/Shell Scripting, SQL*Loader, Data Loading, and CRON Job Automation
• Performance Tuning skills including Explain Plan, Query Optimization, and Stored Procedure Optimization
• Data Integration experience with Data Mapping, Conversion, Transformation, and Legacy System Integration
• Production Support experience with Debugging, Troubleshooting, and Oracle Object Fixes
• Knowledge of Web Technologies including HTML, JavaScript, and CSS
• Experience with SDLC and Testing including Requirements Analysis, Design, Development, Implementation, and Unit Testing