Job Description
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...