Senior Oracle PL/SQL Developer

Senior Oracle PL/SQL Developer

Experience: 11+ Years

Job Overview:
We are looking for a highly experienced Senior Oracle PL/SQL Developer with 11+ years of experience in Oracle database development, PL/SQL programming, performance tuning, and production support. The candidate should have strong experience working with complex enterprise applications and large-volume data.

Key Responsibilities

• Develop and maintain complex PL/SQL Procedures, Functions, Packages, Triggers, Cursors, and Views.
• Write and optimize complex SQL queries using joins, subqueries, CTEs, and analytical functions.
• Perform SQL/PLSQL performance tuning using Explain Plan, AWR, ADDM, ASH, and SQL Trace.
• Design database objects including tables, indexes, constraints, sequences, and materialized views.
• Troubleshoot production issues and perform root-cause analysis.
• Develop Unix/Linux shell scripts for database and batch processes.
• Support ETL, data migration, data validation, and reconciliation activities.
• Collaborate with application developers, DBAs, QA, business teams, and architects.
• Participate in code reviews, technical design, deployments, and production support.
• Mentor junior developers and provide technical leadership.

Required Skills

• Oracle Database 11g/12c/19c
• Advanced SQL & PL/SQL
• Stored Procedures, Functions, Packages, Triggers, Cursors
• BULK COLLECT, FORALL, Dynamic SQL
• SQL/PLSQL Performance Tuning
• AWR, ADDM, ASH, Explain Plan
• Unix/Linux Shell Scripting
• Database Design & Data Modeling
• ETL/Data Migration
• Git/SVN, Jira
• Strong troubleshooting and communication skills

Preferred: Oracle APEX, ORDS, RAC, Data Guard, GoldenGate, Informatica/ODI, and cloud database experience.

Education: Bachelor''''s/Master''''s degree in Computer Science, IT, Engineering, or a related field.