PL/SQL Developer

Smart IT Frame LLC; Alpharetta (GA); On-site; USD 120,000 - 150,000; Full time

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.

Tools

Oracle Database

PL/SQL

UNIX scripting

Oracle SQL Developer

Toad

PL/SQL Developer

AWS

OCI

Python

Java

Job description

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.

Technical Skills & Qualifications:

Experience:

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.

Preferred / "Nice-to-Have" Skills

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