PLSQL Production Support

Tata Consultancy Services; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services is seeking a PL/SQL Production Support Engineer in Mumbai. The role requires 4-8 years of hands-on experience with Oracle PL/SQL, performance tuning, and incident management to ensure high availability of critical applications.

Responsibilities include troubleshooting, RCA, and collaboration with cross-functional teams to deploy production fixes and preventive measures for data integrity and smooth operations.

Qualifications

• 4-8 years experience in PL/SQL production support.
• Strong knowledge of Oracle databases and PL/SQL programming.
• Experience in incident management and production issue resolution.

Responsibilities

• Provide production support for Oracle PL/SQL applications, ensuring high availability and timely resolution of incidents.
• Analyze, troubleshoot, and resolve production issues related to PL/SQL code, database performance, jobs, and data integrity.
• Monitor application performance, conduct root cause analysis (RCA), and implement preventive measures.
• Develop, modify, and optimize PL/SQL procedures, packages, functions, triggers, and queries.
• Collaborate with development, testing, and business teams for issue resolution and production deployments.

Skills

PL/SQL

Oracle

Production Support

Incident Management

Root Cause Analysis

Performance Tuning

SQL

Job description

Job Description: PL/SQL Production Support Engineer

Experience: 4-8 Years

Key Responsibilities:

• Provide production support for Oracle PL/SQL applications, ensuring high availability and timely resolution of incidents.
• Analyze, troubleshoot, and resolve production issues related to PL/SQL code, database performance, jobs, and data integrity.
• Monitor application performance, conduct root cause analysis (RCA), and implement preventive measures.
• Develop, modify, and optimize PL/SQL procedures, packages, functions, triggers, and queries.
• Collaborate with development, testing, and business teams for issue resolution and production deployments.