Oracle PL/SQL Developer - High-Performance Data & ETL

Smart IT Frame LLC

Alpharetta (GA)

On-site

USD 120,000 - 150,000

Full time

1 hour ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Smart IT Frame LLC in Alpharetta, GA is 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 include designing and maintaining stored procedures, integrating business logic in PL/SQL, tuning

Qualifications

Oracle Database expertise: Proficient experience with recent versions (e.g., Oracle 19c or 21c).
Advanced PL/SQL Mastery: Proficiency with collections, bulk operations, analytical functions, and ref cursors.
Tuning Methodologies: Experience partitioning tables, managing optimizer statistics, and modifying query execution paths.
IDE Tools: Familiarity with Oracle SQL Developer, Toad, or PL/SQL Developer.
Scripting Language: UNIX scripting experience.

Responsibilities

Database Programming: Design, write, and maintain robust, high-performance database objects like stored procedures, packages, functions, and database triggers.
Business Logic Integration: Implement complex business rules in PL/SQL for security and speed.
Performance Tuning: Diagnose and optimize sluggish SQL statements.
Data Modeling: Design relational database architectures with schemas, tables, keys, and indexes.
ETL Pipeline Development: Build and scale ETL workflows to ingest external data.
Collaboration & Integration: Interface with backend developers to align APIs with data structures.