JOB ID: QT-SNB-11-437
Experience: 6–10 Years
Role Summary: Design, develop, enhance, and maintain database objects and business logic using Oracle SQL and PL/SQL.
Key Responsibilities
- Develop and optimize complex SQL queries, PL/SQL procedures, functions, packages, triggers, cursors, and views.
- Design database objects, constraints, indexes, sequences, materialized views, and exception-handling mechanisms.
- Analyze execution plans and tune SQL using indexing, partitioning, bulk processing, and query rewrite techniques.
- Develop batch jobs, scheduler jobs, data validation routines, and interfaces for application workflows.
- Perform unit testing, code reviews, defect fixing, deployment support, and production issue resolution.
- Collaborate with application, ETL, and reporting teams to understand data flows and integration requirements.
Mandatory Skills
Oracle SQL; PL/SQL; packages, procedures, functions and triggers; query optimization; execution plans; indexing; transactions; data modeling; performance troubleshooting.
Good to Have
Oracle 12c/19c/21c; partitioning; materialized views; advanced PL/SQL; bulk collect/forall; shell scripting; Git; Agile; exposure to APEX or ODI.
Education
Bachelor's degree in Computer Science, IT, Engineering, or equivalent practical experience.