Oracle Developer
Summary
Design, develop, and maintain PL/SQL code including procedures, functions, triggers, and packages; write and optimize complex SQL queries; perform performance tuning and work on data processing, ETL, and data migration use cases for an on-prem Oracle environment.
Role Descriptions:
Experience: 6+ Years
Role Overview: Must have
Advanced PL/SQL topics:
1. Collections
2. Bulk collect
3. FORALL
4. Pragma
5. Performance tuning using indexes
We are looking for an experienced on prem Oracle Developer with strong hands-on expertise in Oracle SQL and PL/SQL development. The ideal candidate should have a solid development background and be capable of writing complex queries, performing query optimization, and working on data processing use cases.
Key Responsibilities
• Design, develop, and maintain PL/SQL code including procedures, functions, triggers, and packages
• Write and optimize complex SQL queries (joins, subqueries, analytical queries)
• Perform performance tuning and query optimization to improve efficiency and scalability
• Work on data processing, ETL, and data migration use cases
• Analyze business requirements and translate them into technical solutions and database design
• Collaborate with application teams and stakeholders for data integration and enhancements
• Troubleshoot and resolve database-related issues and bottlenecks
• Ensure data integrity, security, and best practices
Required Skills (Must-Have)
• Strong hands-on experience in Oracle SQL & PL/SQL
• Expertise in writing complex queries, stored procedures, functions, and triggers
• Good understanding of performance tuning and query optimization
• Experience with ETL / data migration / data processing use cases
• Knowledge of database design, indexing, and data modeling
• Strong development-oriented background (avoid pure support/DBA profiles)
Good to Have
• Experience in Agile / Scrum environments
• Familiarity with data warehousing concepts
• Understanding of Cloud Platforms
Skills: PL/SQL~Data Migration