Oracle- PL/SQL Lead

Job description

Job Title:Oracle PL/SQL Developer

Experience:9-12years

Location:Pune

Job Description:

We are seeking an experienced and highly skilledOracle PL/SQL Leadto join our dynamic team. The ideal candidate will have strong expertise in Oracle PL/SQL development, performance tuning, and database optimization. If you have a passion for working with large datasets, designing efficient database solutions, and troubleshooting complex database issues, we want to hear from you!

Key Responsibilities:

• Design, develop, and maintain complexstored proceduresto handle data integration from 6-7 tables into a consolidated table.
• Ensure high performance and efficiency of all database operations.
• Analyze and optimize database queries and structures to improve performance.
• Createindexes,partitions, and other database optimizations as necessary.
• Implement data validation, transformation, and cleansing logic within stored procedures.
• Collaborate withbusiness analystsanddata teamsto understand requirements and ensure accurate data mapping.
• Identify and resolve performance bottlenecks and errors in SQL code.
• Conductroot cause analysisfor production issues and provide timely fixes.
• Work closely with cross-functional teams to deliver database solutions aligned with business goals.
• Clearly communicate technical concepts and project progress to stakeholders.

Technical Skills Required:

• 9-12 years of hands-on experience inOracle PL/SQL development.
• Proficient in designing and optimizingstored procedures,views, andmaterialized views.
• Strong knowledge ofdatabase indexing,partitioning, andperformance tuning techniques.
• Experience in working with large datasets and integrating data from multiple tables.
• Hands-on experience withOracle SQL Plus(CLI).
• Familiarity withOracle Database 19c/21c.
• Knowledge ofETL processesand tools.
• Strong analytical skills to interpret data requirements and build database solutions.
• Ability to troubleshoot complex database issues efficiently.

Preferred Skills:

• Oracle Certification (e.g.,Oracle Database SQL Certified Associateor higher) is a plus.
• Familiarity withdata migration,data warehousing, or similar projects is an advantage.
• Experience withdatabase administrationand monitoring tools.
• Knowledge ofcloud database platforms(e.g.,Oracle Cloud,AWS RDS) is a plus.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• Strong communication and interpersonal skills.
• Ability to work collaboratively in a team environment and deliver results.