We are seeking an Oracle Technical Consultant with strong backend and integration skills to join our AI Solutions practice. You will be the technical backbone of our Oracle AI Agent Studio implementations — building the ORDS endpoints, PL/SQL logic, and BIP reports that power intelligent agents. This is a hands-on role where your technical work directly enables AI-driven automation at scale.
Key Responsibilities
- Design and develop ORDS REST endpoints on Oracle ATP/DB to serve as tool backends for AI agents
- Write and optimise PL/SQL procedures, functions, and packages that encapsulate Fusion business logic
- Build and maintain BIP/BI Publisher reports for data extraction and agent consumption
- Integrate with Oracle Fusion REST APIs for procurement, finance, and HR transaction processing
- Collaborate with functional consultants to translate data specs into efficient backend implementations
- Support Oracle AI Agent Studio tool definition — parameter schemas, response handling, error flows
- Manage Oracle ATP schema design, grants, and performance tuning for agent workloads
- Troubleshoot integration failures across ORDS, OIC, and Fusion REST layers
Required Skills & Experience
- 7–15 years of Oracle technical development experience
- Strong PL/SQL — procedures, packages, agile SQL, exception handling
- Hands-on experience with Oracle REST Data Services (ORDS) — module/handler design, parameter binding
- Experience with BIP/BI Publisher report development (data models, templates, bursting)
- Working knowledge of Oracle Fusion REST APIs — authentication, request/response patterns, error handling
- Familiarity with Oracle ATP or Oracle DB cloud — schema management, user grants, REST enablement
- Ability to read and interpret Fusion functional requirements and convert to technical specifications
Nice to Have
- Experience with Oracle Integration Cloud (OIC) — REST/SOAP adapters, scheduled orchestrations
- Exposure to Oracle AI Agent Studio tool configuration or agent integration patterns
- Understanding of Oracle BPM workflow and approval routing
- Knowledge of JSON schema design for REST API contracts