Senior Database Engineer

Compunnel, Inc.; New Jersey; On-site; USD 130,000 - 190,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Oracle

MSSQL

PL/SQL

SQL

Python

Shell scripting

Git

Jenkins

Ansible

Artifactory

AWS

Linux/RedHat

VPD

Partitioning

Performance tuning

NL2SQL

Text-to-SQL

Education

Bachelor's degree in CS

Master's degree (preferred)

OCP certification (huge plus)

AWS ML certification (plus)

Tools

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

Job description

Senior Database Engineer

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)