About the role
- Monitor and support critical production applications and databases.
- Troubleshoot and resolve production incidents, performance issues, and data discrepancies.
- Provide timely resolution to user queries and reported issues.
- Participate in on-call rotations for 24/7 support as needed.
- Analyze, develop, and optimize Oracle PL/SQL code (stored procedures, functions, packages, triggers, Index, Cursor, collection, View) 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 & performance tuning & code optimization