Oracle SQL/PL-SQL Developer

Next Gen Software Solutions•Alpharetta, GA

1d•Onsite

About The Position

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.

Requirements

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

Nice To Haves

Experience managing or mapping databases on cloud infrastructures like AWS (Amazon RDS/S3) or Oracle Cloud Infrastructure (OCI).
Basic competency with Python, or core Java.
Understanding of DevOps data practices such as database version control.

Responsibilities

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