Database Engineer
Advanced Tech Placement · Parsippany, NJ · 2 days ago
HybridFull-time
Responsibilities
- 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
- Develop 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
- 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
- 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
Requirements
- Bachelor's degree in computer science or related field (required)
- Master's degree in computer science, Data Science, or AI/ML (preferred)
- 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
- 2+ years of hands-on experience with Generative AI, LLMs, or ML pipelines in a production environment (preferred)
- Deep expertise in database internals, expert-level PL/SQL, SQL, and Python/Shell programming
- Oracle Certified Professional (OCP) (huge plus)
- AWS Certified Machine Learning Specialty (plus)
Qualifications
- Required Technical Skills: 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
- Preferred Technical Skills: Databases - RDS Oracle, RDS PostgreSQL; AI/ML - LangChain, LlamaIndex, RAG pipelines, Vector stores(pgVector); LLM Platforms - OpenAI API, Azure OpenAI, AWS Bedrock; Oracle Advanced Features - Golden Gate, Cloud Control, Golden Gate BDA