Role Overview

We are looking for an experienced Oracle SQL / PL/SQL Developer with 36 years of strong experience in designing, developing, optimizing, and supporting database solutions.

The candidate will be responsible for developing efficient SQL queries, building scalable PL/SQL programs, troubleshooting production issues, performing performance tuning, and supporting mission-critical applications.

Key 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

- 3–6 years of hands-on experience in Oracle SQL and PL/SQL development.
- Strong 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.
- Positive 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.

Education

- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.

Interested candidate share your updated resume to [email protected]

📌 plsql (Hyderabad)
🏢 Hexaware Technologies
📍 Hyderabad