Oracle Database Engineer

Hi,

Greetings from Iflowsoft Solutions Inc

Position - Sr Database Engineer

Location - Parsippany NJ, hybrid (Nearby to Parsippany will get priority)

Duration - 1 year

Note - The client is looking for (70% oracle and 30% sql) - In Database Engineering

This is a senior role, so profiles 12+ and above only

Position Summary:

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.

Essential Duties & 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

Education / Experience / Certification

· 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)

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

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

Iflowsoft Solutions inc is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law. We promote and support a diverse workforce at all levels in the company. This is not an unsolicited mail and if it is not intended for you or you are not interested in receiving our e-mails, you may unsubscribe