PL/SQL Developer with Production Support

Hello

PFA

Job Title: PL/SQL Developer with Production Support

Client: TCS
Location: Remote
Job Type: Contract

Job Summary

TCS is seeking an experienced PL/SQL Developer / Lead / Architect with strong expertise in Oracle Database development, performance tuning, and production support. The ideal candidate should have experience designing, developing, and optimizing complex PL/SQL applications while collaborating with cross-functional teams in an Agile environment.

Key Responsibilities

• Design, develop, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Optimize SQL queries and PL/SQL code for high performance and scalability.
• Analyze and resolve production issues, ensuring minimal downtime.
• Perform query tuning, indexing, partitioning, and execution plan analysis.
• Develop and maintain database objects, data models, and ETL processes.
• Collaborate with application developers, business analysts, and DBAs to deliver robust solutions.
• Participate in code reviews and enforce coding standards and best practices.
• Support database deployments, releases, and production maintenance.
• Work in an Agile/Scrum environment and provide technical leadership when required.

Required Skills

• 8+ years of experience in Oracle PL/SQL development.
• Strong expertise in Oracle Database (11g/12c/19c or later).
• Hands-on experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, and Cursors.
• Experience with SQL performance tuning, query optimization, indexing, and partitioning.
• Strong understanding of Oracle execution plans and database performance analysis.
• Experience with Unix/Linux shell scripting.
• Knowledge of Git, Jira, and CI/CD practices.
• Excellent troubleshooting and production support experience.
• Strong communication and problem-solving skills.

Preferred Skills

• Experience with Oracle APEX, Oracle Forms/Reports, or Oracle Cloud.
• Knowledge of ETL tools such as Informatica or ODI.
• Experience with data migration and large-scale database implementations.
• Prior experience leading development teams or working as a Technical Lead/Architect.

Nice to Have

• Banking, Healthcare, Insurance, or Retail domain experience.
• Experience working with distributed teams and enterprise applications.