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
