Senior Database Engineer

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

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)