PL/SQL Developer

Envision Technology Solutions; Alpharetta (GA); On-site; USD 90,000 - 130,000; Full time

Job summary

Envision Technology Solutions is seeking a skilled Oracle SQL/PL-SQL Developer to design, develop and manage high‑performance relational database solutions. You will create robust data models, write server‑side logic, and aggressively tune complex queries to ensure maximum data throughput and application stability.

This onsite role in Berkeley Heights, NJ or Alpharetta, GA requires PL/SQL mastery, performance tuning, ETL workflow development, and collaboration with Java teams to align front‑end

Qualifications

• Proficient in Oracle SQL/PL-SQL development.
• Strong PL/SQL mastery with advanced features.
• Experience tuning complex SQL and optimizing performance.

Responsibilities

• Design, write, and maintain high-performance database objects (procedures, packages, functions, triggers).
• Code business rules in PL/SQL for security and speed.
• Diagnose and optimize sluggish SQL statements.
• Design relational database architectures including schemas, tables, keys, and indexes.
• Develop and manage ETL data integration workflows.

Skills

Oracle PL/SQL

PL/SQL Development

Performance Tuning

Data Modeling

ETL

Unix Scripting

Tools

Oracle SQL Developer

Toad

PL/SQL Developer

Job description

Job Title : PL/SQL Developer

Location : Berkeley Heights, NJ / Alpharetta, GA (5 Days Onsite in a week)

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.