Oracle Database Engineer

AGM Tech Solutions - A Woman and Latina-owned IT Staffing Firm-an Inc. 5000 company; Jersey City (NJ); On-site; USD 120,000 - 190,000; Full time

Job summary

AGM Tech Solutions seeks a database engineer at the intersection of traditional DB engineering and AI-powered data solutions. You will design scalable services, debug critical issues, and prototype AI-enabled database tooling to transform how thousands interact with large HCM systems.

Responsibilities include implementing RAG solutions, AI-assisted optimization, and integrating modern tooling like LangChain and Copilot-style assistants. Strong SQL/Python skills required.

Qualifications

• Proficient in Python and SQL-based data tooling.
• Experience with Oracle features like VPD, Partitioning, and JSON data.
• Knowledge of NL2SQL and Text-to-SQL systems for AI-assisted data tasks.

Responsibilities

• Design and build scalable database services for enterprise needs.
• Debug critical DB issues and provide long-term root-cause solutions.
• Develop AI-powered data solutions and GenAI tooling for faster insights.
• Prototype AI-powered database solutions using LangChain, LlamaIndex, or similar.
• Create RAG solutions using data from Oracle and PostgreSQL databases.
• Integrate AI-assisted query optimization into database workflows.
• Leverage Copilot-like tools to accelerate PL/SQL and Python development.
• Build vector DB integrations for semantic search capabilities.
• Evaluate AI/ML model serving patterns for database-adjacent workloads.
• Drive prompt engineering best practices for AI database apps.

Skills

Python

Shell scripting

NL2SQL

Prompt Engineering

Text-to-SQL

AI/ML

Tools

Oracle

PostgreSQL

LangChain

LlamaIndex

Job description

If you are a passionate database engineer who would love to sit at the intersection of traditional enterprise database engineering and the emerging Gen AI revolution — building next-generation, AI-powered data solutions that transform how tens of thousands of users interact with the largest Human Capital Management system then we have a perfect role for you and we would like to have a discussion with you.

• Core Database Engineering
• Design and build scalable database services and solutions to complex business problems
• Debug critical database issues and provide root-cause analysis with long-term solutions
• Research, Design, Develop, and/or modify applications using SQL, PL/SQL, Python, and AI-assisted development tools
• Prototype solutions and recommend adoption of new technologies including Generative AI and LLM-powered database tooling
• Development and Deployment of application database changes/releases across production and non-production environments
• Build and maintain LLM-powered database assistants using frameworks such as LangChain, LlamaIndex, or similar
• Develop Retrieval-Augmented Generation (RAG) solutions using structured/unstructured data from Oracle and PostgreSQL databases
• Integrate AI-powered query optimization tools to enhance database performance tuning workflows
• Leverage GitHub Copilot, Amazon Q, or similar AI coding assistants to accelerate PL/SQL and Python development
• Build vector database integrations (pgvector, Oracle AI Vector Search) for semantic search capabilities
• Evaluate and adopt AI/ML model serving patterns (batch vs. real-time inference) for database-adjacent workloads
• Drive prompt engineering best practices for database-related AI applications

Technical Skills

Required

• Programming: Python, Shell scripting
• Oracle Features: VPD, Partitioning, Expert-level Performance Tuning, JSON data in databases
• AI/ML: Prompt Engineering, NL2SQL, Text-to-SQL systems

Preferred

• Cloud AI Services: AWS SageMaker, Azure ML