Job Description

Job Description

Hi,

Hope you are doing well.

We have the below requirement with my client, please let me know if you are looking for a job.

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

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

Core Technical Requirements

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

Saurabh Kumar

Team Lead – Recruitment

Envision Technology Solutions

Direct Number +1 704 745 4743

Email : saurabh.kumar@envisiontechsol.com

Job Tags

Similar Jobs