Envision Technology Solutions

Job Title : Oracle PL/SQL Developer
Location : Alpharetta, GA/Berkeley Heights, NJ
Hire Type : Long Term Contract
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
<ul>
<li>Database Programming
: Design, write, and maintain robust, high-performance database objects like
stored procedures, packages, functions, and database triggers
.</li>
<li>Business Logic Integration
: Code complex business rules directly into the Oracle database layer using PL/SQL for security and processing speed.</li>
<li>Performance Tuning
: Diagnose, troubleshoot, and optimize sluggish SQL statements using available tools</li>
<li>Data Modeling
: Design efficient relational database architectures including schemas, tables, primary/foreign key relationships, and indexes.</li>
<li>ETL Pipeline Development
: Build, manage, and scale
Extract, Transform, Load (ETL)
data integration workflows to ingest external application data</li>
<li>Collaboration &amp; Integration
: Interface with backend application developers (e.g., Java engineering teams) to align front-end APIs with data tier structures.</li>
<li>Migration &amp; Maintenance
: Author deployment scripts, execute data migration runs, and maintain comprehensive schema version control.</li>
</ul>
Core Technical Requirements
<ul>
<li>Oracle Database Expertise
: Proficient experience with recent versions (e.g., Oracle 19c or 21c).</li>
<li>Advanced PL/SQL Mastery
: Proven capability utilizing collections, bulk operations, analytical functions, and ref cursors.</li>
<li>Tuning Methodologies
: Hands-on experience partitioning tables, managing optimizer statistics, and modifying query execution paths.</li>
<li>IDE Tools
: High familiarity with database interfaces, specifically Oracle SQL Developer, Toad, or PL/SQL Developer.</li>
<li>Scripting Language :
High familiarity and experience with UNIX scripting.</li>
</ul>

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

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

This job is no longer available

Talents

Recruiters

About