PL/SQL Engineer

Matlen Silver

Jersey City, NJ, United States

3 months ago

Apply on indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Compensation

$135,200.0 - $141,440.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence Application Layers Microsoft Azure Cloud Database Databases Information Engineering Extract Transform Load (ETL) Data Retrieval Data Security Database Security Python (Programming Language)

+17 more

Oracle Databases Oracle (Applications) Performance Tuning Query Optimization SQL Stored Procedures PL-SQL SQL Databases Strategies of Testing Scripting Freeform SQL Delivery Pipeline Large Language Models Database Optimization Database Performance Generative AI Amazon Relational Database Service Oracle Cloud Infrastructure

Job description

Design, develop, and optimize complex SQL queries, PLSQL procedures, functions, packages, and views.
Integrate Oracle-hosted AI/embedding features into database workflows.
Partner with AI/ML and Data Engineering teams to expose structured data safely to LLM-driven agents.
Build reusable patterns for structured data retrieval in AI and RAG pipelines.
Optimize database performance through indexing, partitioning, and query tuning.
Develop monitoring, alerting, and testing strategies for database-backed AI solutions.
Support API or microservice layers that encapsulate complex SQL logic when required.
Enforce data security, governance, and least-privilege access for AI integrations.

Requirements

Overview We are seeking a highly experienced SQL / PLSQL Engineer to support the integration of structured Oracle data into AI-driven applications. This role focuses on building performant database logic and enabling secure, scalable access for AI agents and Retrieval-Augmented Generation (RAG) workflows, leveraging Oracle’s embedded AI and embedding capabilities., * 10+ years of hands-on SQL experience with advanced PLSQL expertise.

Strong experience with Oracle Database (11g, 12c, 19c, or later).
Proven background in performance tuning, indexing strategies, and query optimization.
Experience building and maintaining production-grade stored procedures, functions, and packages.
Experience integrating database systems with application layers or automation pipelines.
Strong communication skills with the ability to explain technical decisions and tradeoffs.

Preferred Qualifications

Experience with Oracle embedded AI or embedding models.
Exposure to LLM/AI integrations, especially structured data access for agents.
Familiarity with RAG architectures and vector embedding concepts.
Knowledge of database security, masking, and governance in AI contexts.
Scripting experience (e.g., Python) for orchestration or ETL workflows.
Experience with cloud database platforms (OCI, AWS RDS, Azure) and Infrastructure as Code.