Senior AI-Powered Database Engineer

Compunnel Inc.; New Jersey; Presencial; USD 130.000 - 190.000; Jornada completa

Descripción de la vacante

Compunnel, Inc. seeks a Senior Database Engineer to bridge traditional DB engineering with Gen AI.

You will design scalable SQL-based solutions, prototype AI integrations, and lead performance tuning across Oracle and PostgreSQL environments.

Formación

• Expert in Oracle, MSSQL, PL/SQL, and SQL with strong design skills.
• Proficient in Python and shell scripting for automation.
• Experience with AWS, Linux/RedHat environments and DevOps tools.
• Hands-on knowledge of AI/ML concepts, prompt engineering, and NL2SQL.
• 10+ years in database development/DBA in agile settings.

Responsabilidades

• Design and build scalable database services for complex problems.
• Lead AI-enabled database projects and governance practices.
• Develop AI-assisted tooling and RAG pipelines for data work.
• Mentor teams on AI adoption and best practices for TDD.

Conocimientos

Oracle

MSSQL

PL/SQL

SQL

Python

Shell scripting

Git

Jenkins

Ansible

Artifactory

AWS

Linux/RedHat

VPD

Partitioning

Performance tuning

NL2SQL

Text-to-SQL

Educación

Bachelor's degree in CS

Master's degree (preferred)

OCP certification (huge plus)

AWS ML certification (plus)

Herramientas

LangChain

LlamaIndex

RAG pipelines

pgVector

Oracle AI Vector Search

OpenAI API

Azure OpenAI

AWS Bedrock

Bitbucket

CI/CD for AI model deployment

AWS SageMaker

Azure ML

Golden Gate

Cloud Control

Descripción del empleo

Sr. PL/SQL deeloper

JOB SUMMARY
Database engineer who will 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.

Key Responsibilities
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

Quality & Leadership
Self-reliant, hands-on technical leader driving code quality, AI governance, and database AI practices
Collaborate with database peers, product owners, UX/UI, and globally distributed teams on AI-enhanced database solutions
Define engineering best practices including AI-assisted Test-Driven Development (TDD) and automated unit testing for database development
Mentor teams on AI tool adoption, prompt engineering, and AI use in data engineering
Develop specifications for new database services incorporating AI-native design patterns
Meet deadlines and manage multiple, dynamic priorities in an agile environment

Required Qualifications
Technical Skills Required
Databases: Oracle, MSSQL, PL/SQL, SQL
Programming: Python, Shell scripting
DevOps: Git, Jenkins, Ansible, Artifactory
Cloud: AWS
OS: Linux/RedHat
Oracle Features: VPD, Partitioning, Expert-level Performance Tuning, JSON data in databases
AI/ML: Prompt Engineering, NL2SQL, Text-to-SQL systems

Education / Experience / Certification
Bachelor's degree in computer science or related field (required)
10+ years of experience as a Database Developer/DBA in a fast-paced agile environment
7+ years as an Oracle Developer/DBA with expert-level PL/SQL and SQL skills
Deep expertise in database internals, expert-level PL/SQL, SQL, and Python/Shell programming

Preferred Qualifications
Education / Experience / Certification
Master's degree in computer science, Data Science, or AI/ML (preferred)
2+ years of hands-on experience with Generative AI, LLMs, or ML pipelines in a production environment (preferred)

Technical Skills Preferred
Databases: RDS Oracle, RDS PostgreSQL
AI/ML: LangChain, LlamaIndex, RAG pipelines, Vector stores(pgVector)
LLM Platforms: OpenAI API, Azure OpenAI, AWS Bedrock
DevOps: Bitbucket, CI/CD for AI model deployment
Cloud AI Services: AWS SageMaker, Azure ML
Oracle Advanced Features: Golden Gate, Cloud Control, Golden Gate BDA

Certifications
Oracle Certified Professional (OCP) (huge plus)
AWS Certified Machine Learning Specialty (plus)