Oracle PL/SQL Developer -- Alpharetta, GA/Berkeley Heights, NJ

Envision Technology Solutions; Berkeley Heights (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

Envision Technology Solutions seeks an Oracle PL/SQL Developer to design, develop, and manage high-performance database solutions. You will craft robust data models, implement server-side logic, and aggressively tune complex queries to maximize throughput and stability.

Responsibilities include implementing stored procedures, packages, and triggers; embedding complex business rules in PL/SQL; tuning SQL; data modeling; and building ETL pipelines while collaborating with Java teams to ensure API

Qualifications

• Experience with Oracle 19c/21c
• Advanced PL/SQL with bulk operations, analytic functions, and ref cursors
• Tuning: partitioning, optimizer stats, and query paths
• Design and maintenance of stored procedures, packages, functions, and triggers
• ETL data integration workflows and data ingestion pipelines
• Collaboration with backend developers to align data tier with APIs

Responsibilities

• Design, write, and maintain high-performance database objects
• Code business rules in PL/SQL for security and performance
• Diagnose, troubleshoot, and optimize sluggish SQL statements
• Design schemas, tables, keys, and indexes for relational databases
• Build, manage, and scale ETL workflows for external data
• Interface with Java teams to align data layer with frontend APIs

Skills

Oracle DB

PL/SQL mastery

Tuning

IDE Tools

UNIX scripting

Tools

Oracle SQL Developer

Toad

PL/SQL Developer

Job description

Job Title : Oracle PL/SQL Developer

Job Summary

We are seeking a highly skilled Oracle SQL/PL-SQL Developer to design, develop and manage high-performance relational database solutions. You will be responsible for creating robust data models, writing advanced server-side programmatic logic, and aggressively tuning complex queries to ensure maximum data throughput and application stability

Key Responsibilities

• Database Programming: Design, write, and maintain robust, high-performance database objects like stored procedures, packages, functions, and database triggers.
• Business Logic Integration: Code complex business rules directly into the Oracle database layer using PL/SQL for security and processing speed.
• Performance Tuning: Diagnose, troubleshoot, and optimize sluggish SQL statements using available tools
• Data Modeling: Design efficient relational database architectures including schemas, tables, primary/foreign key relationships, and indexes.
• ETL Pipeline Development: Build, manage, and scale Extract, Transform, Load (ETL) data integration workflows to ingest external application data
• Collaboration & Integration: Interface with backend application developers (e.g., Java engineering teams) to align front-end APIs with data tier structures.

Core Technical Requirements

• Oracle Database Expertise: Proficient experience with recent versions (e.g., Oracle 19c or 21c).
• Advanced PL/SQL Mastery: Proven capability utilizing collections, bulk operations, analytical functions, and ref cursors.
• Tuning Methodologies: Hands-on experience partitioning tables, managing optimizer statistics, and modifying query execution paths.
• IDE Tools: High familiarity with database interfaces, specifically Oracle SQL Developer, Toad, or PL/SQL Developer.
• Scripting Language : High familiarity and experience with UNIX scripting.