PL/SQL Engineer

Matlen Silver
Jersey City, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 141K

Job location

Jersey City, United States of America

Tech stack

API
Artificial Intelligence
Application Layers
Azure
Cloud Database
Databases
Information Engineering
ETL
Data Retrieval
Data Security
Database Security
Python
Oracle
Oracle Applications
Performance Tuning
Query Optimization
SQL Stored Procedures
PL-SQL
SQL Databases
Strategies of Testing
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Delivery Pipeline
Large Language Models
Database Optimization
Database Performance
Generative AI
Amazon Web Services (AWS)
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.

Benefits & conditions

3.43.4 out of 5 stars Jersey City, NJ $65 - $68 an hour - Contract

Apply for this position