Oracle SQL/PL-SQL Developer - ETL & Performance Expert

Next Gen Software Solutions LLC; Alpharetta (GA); On-site; USD 96,000 - 152,000; Full time

Job summary

Next Gen Software Solutions LLC in Alpharetta, GA, is seeking an Oracle SQL/PL-SQL Developer for a long-term contract-to-hire engagement. You will design, develop, and manage high-performance relational database solutions, create robust data models, and implement server-side logic to support critical applications.

The role emphasizes tuning complex queries, building ETL workflows, and collaborating with Java teams to align APIs with the data tier.

Qualifications

• Proficient Oracle SQL and PL/SQL development skills.
• Experience with performance tuning and query optimization.
• Strong data modeling and ETL development capabilities.
• Hands-on UNIX scripting experience with scripting languages.
• Familiarity with Oracle IDE tools for development and debugging.
• Ability to collaborate with back-end teams and integrate business logic.

Responsibilities

• Database Programming: Design, write, and maintain robust, high-performance database objects like stored procedures, packages, functions, and triggers.
• Business Logic Integration: Code complex business rules directly into the Oracle database layer using PL/SQL.
• 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 to align front-end APIs with data tier structures.

Skills

Oracle SQL

PL/SQL

Performance tuning

Data modeling

ETL development

UNIX scripting

Tools

Oracle SQL Developer

Toad

PL/SQL Developer

Job description

Next Gen Software Solutions LLC in Alpharetta, GA, is seeking an Oracle SQL/PL-SQL Developer for a long-term contract-to-hire engagement. You will design, develop, and manage high-performance relational database solutions, create robust data models, and implement server-side logic to support critical applications.

The role emphasizes tuning complex queries, building ETL workflows, and collaborating with Java teams to align APIs with the data tier.