Oracle Technical Consultant

Oracle Technical Consultant

Mid–Senior | 5–8 Years | Oracle Practice | Full Time

About the Role
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 specifications into efficient backend implementations.
• Support Oracle AI Agent Studio tool definition, including parameter schemas, response handling, and 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
• 5–8 years of Oracle technical development experience.
• Strong PL/SQL skills, including procedures, packages, dynamic SQL, and exception handling.
• Hands-on experience with Oracle REST Data Services (ORDS), including module/handler design and parameter binding.
• Experience with BIP/BI Publisher report development, including data models, templates, and bursting.
• Working knowledge of Oracle Fusion REST APIs, including authentication, request/response patterns, and error handling.

Nice to Have
• Experience with Oracle Integration Cloud (OIC), including REST/SOAP adapters and 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.
• Experience with OCI services, including Object Storage and Autonomous Database tooling.