Description

You will design, develop, and optimize complex Oracle-based solutions for high-volume enterprise applications.

Responsibilities

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers.
• Perform advanced performance tuning of PL/SQL code, queries, and database structures.
• Analyze and refactor poorly performing database code to resolve performance bottlenecks.
• Collaborate with DBAs, application developers, and architects to implement performance and scalability best practices.
• Utilize AWR, ASH, SQL Trace, and SQL Plan Baselines to monitor and enhance performance.

Required Skills

• 10+ years of experience in Oracle PL/SQL development.
• 5+ years of experience with Informatica ETL workflows.
• Deep expertise in performance tuning Oracle packages and SQL queries (Oracle 12c/19c/21c).
• Strong understanding of Oracle internals, execution plans, indexing, partitioning, and optimizer behavior.
• Hands-on experience with SQL Developer, TOAD, AWR, ASH, TKPROF, SQL Trace, and Oracle Enterprise Manager.
• Bachelor's degree in Computer Science, Information Systems, or a related field.

Preferred Skills

• Oracle Certified Professional (OCP) certification.
• Exposure to Agile or DevOps environments.
• Experience with performance tuning in cloud-based Oracle environments.

Key Skills

Education

Bachelor's degree in Computer Science, Information Systems