Key Responsibilities:

• Develop, enhance, and maintain Oracle SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Should have knowledge in python scripting
• Work on L3 Development with real-time problem-solving including debugging, performance tuning, and root cause analysis.
• Optimize SQL queries for large datasets (millions of rows) to improve application performance.
• Implement bulk processing using BULK COLLECT, FORALL, and collections to handle high volumes of data.
• Work with cursors, ref cursors, dynamic SQL for complex requirement handling.
• Design and maintain database objects (tables, views, indexes, constraints, partitions).
• Collaborate with Dev, QA, and Business teams for requirement gathering, triaging, and defect resolution.
• Implement error handling, exception handling, logging, and...