Oracle (AI Developer) – Senior / Lead Consultant

Astreya; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

Astreya seeks a Senior / Lead Oracle Cloud & AI Integration Consultant to design, build, and deploy enterprise applications, integrations, and AI-driven data solutions across Oracle Fusion, OCI, OIC, and ADW/ATP.

You will bridge Oracle Cloud ecosystems with Generative AI, implement RAG architectures, NL-to-SQL capabilities, and deliver API-led integrations and cloud-native automation in hybrid environments with Azure, Snowflake, OTBI and OAC.

Qualifications

• 6–8+ years in Oracle Cloud technical consulting.
• 1–2+ years building Python-based AI workflows.
• Proven experience with Fusion Applications, OCI, OIC, and ADW/ATP.
• Strong SQL/PLSQL and Python proficiency.
• Experience with REST APIs, Event-Driven architectures, OTBI/OAC, Snowflake/Azure.

Responsibilities

• Develop and deploy Oracle Fusion Applications, OCI, OIC, and ADW/ATP solutions.
• Architect Agentic AI, RAG frameworks, and NL-to-SQL capabilities.
• Build API-led integrations and cloud-native automation using Python and PL/SQL.
• Collaborate across hybrid environments with Azure, Snowflake, OTBI and OAC.

Skills

Oracle Cloud

Python

SQL/PLSQL

Generative AI

REST APIs

Tools

OCI

OIC

Fusion Applications

ADW/ATP

OTBI

OAC

Job description

About the Role

We are seeking a Senior / Lead Oracle Cloud & AI Integration Consultant to design, build, and deploy cutting-edge enterprise applications, integrations, and AI-driven data solutions.

In this role, you will bridge traditional Oracle Cloud ecosystems (OCI, OIC, Fusion Apps) with modern Generative AI technologies, building intelligent solutions like Agentic AI, RAG architectures, and Natural Language-to-SQL capabilities across core enterprise functions (Finance, Procurement, Supplier Lifecycle, and Project Portfolio Management).

Key Responsibilities

• Enterprise Applications & Infrastructure: Develop and maintain high-performance solutions across Oracle Fusion Applications, Oracle Cloud Infrastructure (OCI), Oracle Integration Cloud (OIC), and Oracle Autonomous Database (ADW/ATP).
• AI & Data Engineering: Architect and implement Agentic AI solutions, Retrieval-Augmented Generation (RAG) frameworks, and Natural Language-to-SQL query systems.
• Integrations & Automation: Build API-led integrations, event-driven architectures, SaaS extensions, and cloud-native automation pipelines using Python and PL/SQL.
• Cross-Cloud Collaboration: Integrate data flows, enterprise reporting frameworks, and analytics solutions across hybrid environments (Oracle, Microsoft Azure, Snowflake, OAC, OTBI).

Required Qualifications

• Experience: 6+ to 8+ years of total experience in Oracle Cloud technical consulting, with at least 1–2+ years of hands-on experience building Python-based AI workflows and data pipelines.
• Core Oracle Stack: Proven experience with Oracle Fusion Applications, OCI, OIC, and Autonomous Database (ADW/ATP).
• AI & Machine Learning: Hands-on experience with Generative AI, RAG architectures, Agentic AI frameworks, Prompt Engineering, and Natural Language processing for database querying.
• Database & Scripting: Strong proficiency in SQL, Oracle PL/SQL, and Python.
• Integrations & Analytics: Experience with REST APIs, Event-Driven Architectures, OTBI, OAC, and cloud integrations (Snowflake / Azure).