Senior Oracle Technical Consultant Job at Advantra Consulting Group, California

  • Advantra Consulting Group
  • California

Job Description

Senior Oracle Technical Consultant AI Enablement

Remote

Video Interview

Long Term Contract

Role Summary

We are looking for a Senior Oracle Technical Consultant with a strong Oracle EBS technical background and practical experience with AI/GenAI enablement and enterprise integrations.

The ideal candidate has strong hands-on experience across Oracle RICEW/CEMLI, SQL/PLSQL, integrations, data conversion, reporting, troubleshooting, and production support, combined with the ability to work with AI/ML teams to enable AI-driven workflows within the Oracle environment.

This is not a pure Oracle Functional role or a pure AI Engineering role. We are looking for someone who can bridge the Oracle technical environment with modern integration and AI capabilities.

Key Responsibilities

Oracle Technical Development

  • Design, develop, enhance, and support Oracle EBS applications across RICEW/CEMLI components:
  • Reports
  • Interfaces
  • Conversions
  • Extensions
  • Workflows
  • Strong hands-on development using SQL and PL/SQL.
  • Experience with Oracle Forms, OAF, XML Publisher/BI Publisher and related Oracle technical components.
  • Develop technical solutions based on business and functional requirements.
  • Prepare technical specifications, perform impact analysis, troubleshoot issues, and support production environments.
  • Support Oracle upgrades, patches, testing, deployment, and release activities.
  • Perform data fixes, performance tuning, root-cause analysis, and Oracle Support SR resolution.

Integration & API Development

  • Strong emphasis on enterprise integration methodologies and REST APIs.
  • Design and develop integrations between Oracle EBS and external applications, platforms, services, and data sources.
  • Strong understanding of REST APIs, API-based integration, web services, data exchange, and integration patterns.
  • Develop, consume, test, and troubleshoot REST/SOAP APIs and other integration interfaces.
  • Work with JSON, XML, data mapping, transformations, authentication, error handling, and integration monitoring.
  • Understand different integration approaches and determine the appropriate methodology based on business and technical requirements.
  • Experience integrating Oracle with third-party applications, SaaS platforms, data platforms, and modern cloud services.
  • Work with middleware, integration platforms, APIs, and data pipelines where required.
  • Support integration design, technical documentation, testing, deployment, and production troubleshooting.

AI / GenAI Enablement

  • Partner with AI/ML engineering teams to identify opportunities for AI-enabled Oracle workflows.
  • Translate Oracle business processes and technical requirements into AI use cases.
  • Enable AI/GenAI applications to securely access and interact with Oracle data and business processes.
  • Support integration of LLMs, AI agents, RAG-based solutions, and intelligent automation with Oracle applications.
  • Work with AI engineering teams on APIs, data pipelines, retrieval, data access, and workflow integration.
  • Help expose relevant Oracle data and services through APIs or other appropriate integration mechanisms for AI workflows.
  • Support AI-driven use cases such as:
  • Intelligent document/process automation
  • Business-user assistance
  • Exception identification and handling
  • Data retrieval and knowledge access
  • Recommendations and workflow automation
  • Automated reporting and reconciliation
  • Participate in testing AI-enabled workflows for accuracy, security, data access, and business-process alignment.

Required Technical Skills

Oracle

  • Strong Oracle EBS / R12 technical experience.
  • Strong RICEW/CEMLI experience.
  • SQL / PL/SQL.
  • Oracle Reports, Forms, OAF, XML Publisher / BI Publisher.
  • Interfaces, conversions, extensions, workflows.
  • Oracle database and technical architecture.
  • Unix/Linux and shell scripting.
  • Oracle upgrades, patches, testing, deployment, and production support.

Integration & APIs Strong Requirement

  • Strong understanding of integration methodologies and patterns.
  • Strong hands-on experience with REST APIs.
  • Experience consuming and developing REST-based services.
  • SOAP/Web Services exposure.
  • JSON/XML and data transformation.
  • API authentication, error handling, logging, monitoring, and troubleshooting.
  • Oracle-to-third-party and third-party-to-Oracle integrations.
  • Experience with middleware, integration platforms, or cloud integration services is preferred.
  • Understanding of API-based architecture and integration with modern cloud applications.

AI / GenAI

  • Practical understanding of GenAI, LLMs, AI agents, or AI-driven automation.

Job Tags

Long term contract, Remote work

Similar Jobs

KV Inc.

EDM Programmer-Setter, RAM/Wire Job at KV Inc.

 ...such as punches into punch. Communicate setups to other personnel to ensure consistent results. Tools & technologies EDM Machine (Sinker) EDM Machine (Wire) How we work Paid to Think Use your judgment to solve problems at the source. Make it Fun... 

Kevin Kelley Concepts

Director of Restaurant Operations Job at Kevin Kelley Concepts

 ...Job Description Job Description Director of Restaurant Operations Summary: We are looking for a dynamic and experienced Director of Operations to lead our company's operational strategies and drive efficiency, productivity, and growth. As a key member of the... 

TSMC

Environmental Health & Safety Engineer Job at TSMC

 ...We are seeking ISEP Safety Engineers to join our growing team!At TSMC, We Develop the Technologies that Shape the Future and Change the...  ...Environmental Protection Management System and an ISO 45001 Occupational Health and Safety (OH&S) management systemEstablish the ESH culture... 

Everest Clinical Research

Senior Clinical Data Manager Job at Everest Clinical Research

 ...Senior Clinical Data Manager Everest Clinical Research ("Everest") is a full-service contract research organization (CRO) providing a broad range of expertise-based clinical research services to worldwide pharmaceutical, biotechnology, and medical device industries.... 

Omnivision Technologies

Sr. Analog Design Engineer Job at Omnivision Technologies

DescriptionWe are looking for qualified Analog circuit design engineers who have a good understanding of analog circuit and CMOS Image Sensor. Candidates should have the capability to design and develop analog circuit independently, as well as experience in debugging/verifying...