Role & responsibilities

- Develop, enhance, and maintain Oracle SQL queries, PL/SQL procedures, functions, packages, and triggers.

- Work on L3 development and production support, including debugging, performance tuning, troubleshooting, and root cause analysis.

- Optimize SQL queries for large datasets involving millions of rows to improve application performance.

- Implement bulk processing using BULK COLLECT, FORALL, and collections for high-volume data processing.

- Work with cursors, REF CURSORs, and dynamic SQL for complex business requirements.

- Design and maintain database objects such as tables, views, indexes, constraints, and partitions.

- Collaborate with Development, QA, and Business teams for requirement gathering, issue triaging, and defect resolution.

- Implement effective error handling, exception handling, logging, and debugging mechanisms.

- Support data migration, transformation, and integration activities.

- Work with tools such as Git, JIRA, Jenkins, and AutoSys or equivalent tools for version control, CI/CD, and job scheduling.

- Follow Agile/Scrum methodologies and participate in relevant ceremonies.

Required Skills & Experience





- 36 years of hands-on experience in Oracle SQL and PL/SQL development.

- Solid knowledge of SQL optimization techniques, including indexes, hints, execution plans, and statistics.

- Hands-on experience with PL/SQL programming constructs such as procedures, packages, functions, triggers, and cursors.

- Experience in performance tuning, debugging, and production incident support.

- Strong understanding of SDLC and Agile practices.

- Experience working with large datasets in OLTP/OLAP environments.

- Good understanding of database design and normalization.

- Strong problem-solving and analytical skills.

- Exposure to XML and JSON handling in Oracle is an added advantage.

- Good communication and collaboration skills for working with cross-functional teams.

Nice-to-Have Skills

- Knowledge of Oracle advanced features such as Materialized Views, Partitioning, and Parallel Query.

- Hands-on experience with Oracle XML DB and JSON functions.

- Exposure to AWS RDS / Cloud Databases.

- Experience with unit testing frameworks such as utPLSQL.

📌 Walk-in || Oracle PLSQL Programmer (Hyderabad)
🏢 Orcapod Consulting Services
📍 Hyderabad