Oracle PL/SQL Lead

Job Description
We are seeking an experienced Project Lead with strong Oracle PL/SQL development experience to support enterprise database applications. The ideal candidate will have strong expertise in Oracle development, performance tuning, and Linux scripting, along with the ability to lead technical tasks and support production systems.
Required Skills & Experience
10–12 years of experience in Oracle Database development.
Strong hands-on experience with Oracle PL/SQL development.
Expertise in developing and maintaining:
Functions
Triggers
Stored Procedures
Packages
Materialized Views
Strong experience with Exception Handling, Cursors, and Collections.
Experience in SQL performance tuning and query optimization.
Hands-on experience with SQL Loader and Oracle Data Pump for data migration and loading.
Good knowledge of Linux/Unix shell scripting.
Ability to troubleshoot and resolve database performance issues.
Experience working in production support and database maintenance environments.
Responsibilities
Design, develop, and maintain Oracle PL/SQL programs and database objects.
Perform performance tuning and query optimization to improve database efficiency.
Develop and maintain shell scripts in Linux for automation and batch processing.
Manage data migration, backup, and data loading using SQL Loader and Data Pump.
Troubleshoot production issues and provide timely resolution.
Collaborate with development teams, DBAs, and business stakeholders to deliver solutions.
Ensure adherence to coding standards, best practices, and documentation