Senior PL/SQL Developer

Job Title: Senior PL/SQL Developer

Location: Jersey City, NJ
Duration: Long Term Contract
Experience: 12+ Years

Job Summary

We are seeking a highly experienced PL/SQL Developer with 12+ years of experience in designing, developing, and optimizing enterprise database solutions. The ideal candidate should have strong expertise in Oracle PL/SQL, SQL, performance tuning, data modeling, and ETL development, with experience supporting mission-critical applications.

Required Skills

• 12+ years of experience in Oracle PL/SQL development.
• Strong expertise in Oracle SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, and Cursors.
• Experience with performance tuning, query optimization, and execution plan analysis.
• Strong knowledge of Oracle Database architecture and data modeling.
• Experience with ETL processes, data migration, and data integration.
• Experience with Unix/Linux Shell Scripting.
• Hands-on experience with SQL Developer, TOAD, or similar Oracle tools.
• Experience with Git, Jira, and Agile/Scrum methodologies.
• Strong analytical, debugging, and problem-solving skills.
• Excellent communication and collaboration skills.

Preferred Skills

• Experience with Oracle Forms & Reports.
• Exposure to Informatica, ODI, Talend, or other ETL tools.
• Knowledge of AWS, Azure, or Oracle Cloud.
• Experience with Banking, Healthcare, Insurance, or Financial Services domains.

Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL programs and database objects.
• Develop and optimize stored procedures, packages, functions, triggers, and views.
• Perform database performance tuning and query optimization.
• Support ETL processes, data migration, and data validation activities.
• Collaborate with business analysts and development teams to implement database solutions.
• Troubleshoot production issues and provide performance improvements.
• Participate in code reviews, unit testing, deployment, and production support.
• Ensure data integrity, security, and adherence to database development standards.