Role description

Role : Oracle PLSQL developer with XML and JSON

Experience: 5-10Yrs

Location : Bangalore

Notice period: 0-15days

Primary SKills: Oracle PLSQL, functions, triggers, Advanced features of PLSQL, XML, JSON, storedprocedures.

Detailed Job description:

JD for Oracle SQL / PL/SQL Developer :

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 debugging strategies.
- Support data migration, transformation, and integration workflows.
- Work with tools like GIT, JIRA, Jenkins, AutoSys (or equivalent) for version control and deployment.
- Exposure to Agile/Scrum methodologies.

Required Skills & Experience:

- 3–6 years of experience in Oracle SQL and PL/SQL development.
- Strong knowledge of SQL optimization techniques (indexes, hints,



explain plan, statistics).
- Hands-on with PL/SQL programming constructs (procedures, packages, functions, triggers, cursors).
- Experience with performance tuning, debugging, and production incident support.
- Solid knowledge of SDLC & Agile practices.
- Experience working with large datasets in OLTP / OLAP environments.
- Good understanding of database design & normalization.
- Strong problem-solving and analytical skills.
- Exposure to XML, JSON handling in Oracle will be an added advantage.
- Good communication skills for interaction with cross-functional teams.

Nice to Have Skills:

- Knowledge of Oracle Advanced Features (Materialized Views, Partitioning, Parallel Query).
- Hands-on with Oracle XML DB / JSON functions.
- Exposure to AWS RDS / Cloud Databases.
- Experience using unit testing frameworks (utPLSQL).

Skills

Databases, PL/SQL, SQL, Oracle

About UST
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.

📌 Oracle PLSQL developer with XML and JSON (India)
🏢 UST
📍 India