Senior Oracle PL/SQL Architect — Data Warehouse & ETL

Raas Infotek LLC; Charlotte (NC); On-site; USD 110,000 - 150,000; Full time

Job summary

Raas Infotek LLC is seeking a Senior Oracle PL/SQL Developer with 12+ years of database development experience. The role focuses on Oracle SQL/PLSQL programming, performance tuning, ETL design, and enterprise data management for large-scale applications.

You will design and optimize complex PL/SQL objects, implement ETL processes, and work with Oracle databases across versions. Strong collaboration with analysts, engineers, and QA teams is essential.

Qualifications

• 12+ years of experience in Oracle database development and ETL.
• Strong expertise in PL/SQL programming, stored procedures, and performance tuning.
• Hands-on with Oracle 12c/19c/21c and SQL Server (preferred).

Responsibilities

• Design and maintain complex PL/SQL procedures, functions, packages, and triggers.
• Develop and optimize SQL queries for large enterprise applications.
• Perform SQL/PLSQL tuning using Explain Plan, TKPROF, and AWR/ASH.
• Design and implement ETL processes and support data warehouses.
• Lead data migration, integration, and modernization efforts.
• Provide mentoring and collaborate with analysts, developers, and QA.

Skills

Oracle SQL/PLSQL

Stored Procedures

Functions

Packages

Triggers

Cursors

Bulk Collect/FORALL

Dynamic SQL

Exception Handling

SQL Server

RDBMS

Tools

Informatica PowerCenter

ODI

SQL Loader

External Tables

Azure Data Factory

SSIS

Job description

Raas Infotek LLC is seeking a Senior Oracle PL/SQL Developer with 12+ years of database development experience. The role focuses on Oracle SQL/PLSQL programming, performance tuning, ETL design, and enterprise data management for large-scale applications.

You will design and optimize complex PL/SQL objects, implement ETL processes, and work with Oracle databases across versions. Strong collaboration with analysts, engineers, and QA teams is essential.