Oracle PL/SQL Developer

Role:- Oracle PL/SQL Developer

Experience:- 5+ Years

Work Mode - Hybrid / Remote

Location:- Bangalore

Experienced Oracle PL/SQL Developer with strong expertise in Oracle Database development, Oracle REST Data Services (ORDS), and JSON data processing.

The candidate will be responsible for designing, developing, optimizing, and maintaining database solutions,

REST APIs, and data integration services for enterprise applications.

The ideal candidate should have hands-on experience in PL/SQL programming, Oracle performance tuning,

API development using ORDS,API testing using postman and working with structured/unstructured JSON datasets.

Key Responsibilities

1. Develop and maintain complex PL/SQL procedures, packages, functions, and triggers.
2. Design and optimize Oracle database schemas, queries, and indexing strategies.
3. Create and manage RESTful APIs using Oracle REST Data Services (ORDS).
4. Process, parse, validate, and transform JSON datasets within Oracle Database.
5. Develop integrations between Oracle databases and external systems using REST APIs.
6. Work with JSON_TABLE, JSON_OBJECT, JSON_ARRAYAGG, and related Oracle JSON functionalities.
7. Troubleshoot and resolve database performance bottlenecks.
8. Collaborate with application developers, business analysts, and QA teams.
9. Participate in code reviews and follow development best practices.
10. Prepare technical documentation and deployment scripts.