Walk-in || Production Support and PLSQL Developer

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