Walk-in | Production Support and PLSQL Developer

Tata Consultancy Services; Mumbai; Ibrido; INR 600.000 - 1.000.000; Tempo pieno

Descrizione del lavoro

Tata Consultancy Services in Mumbai seeks a PL/SQL Developer to monitor and optimize production systems and databases, and to implement robust error handling and logging.

You will analyze, develop, and optimize Oracle PL/SQL code, debug existing code, perform data fixes, and contribute to on-call rotations for 24/7 support.

Competenze

• Experience with Oracle PL/SQL development and tuning.

Mansioni

• Monitor and support critical production applications and databases.
• Analyze, develop, and optimize Oracle PL/SQL code for performance and efficiency.
• Debug and resolve issues in existing PL/SQL code & complex queries.
• Perform data fixes and data manipulation using SQL and PL/SQL.
• Implement robust error handling and logging mechanisms within PL/SQL code and performance tuning.

Conoscenze

PL/SQL

Oracle

SQL

Performance tuning

Descrizione del lavoro

Role & responsibilities

Key Responsibilities:

• Production Support:

1. Monitor and support critical production applications and databases.
2. Troubleshoot and resolve production incidents, performance issues, and data discrepancies.
3. Provide timely resolution to user queries and reported issues.
4. Participate in on-call rotations for 24/7 support as needed.

PL/SQL Development & Maintenance:

1. Analyze, develop, and optimize Oracle PL/SQL code (stored procedures, functions, packages, triggers, Index, Cursor, collection, View) for performance and efficiency.
2. Debug and resolve issues in existing PL/SQL code & complex queries.
3. Perform data fixes and data manipulation using SQL and PL/SQL.
4. Implement robust error handling and logging mechanisms within PL/SQL code & performance tuning & code optimization

Preferred candidate profile