Senior PL/SQL Developer

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

Job Title: Senior Oracle PL/SQL Developer

Experience: 12 Years

Employment Type: W2 Contract

Job Summary

We are seeking a highly experienced Senior Oracle PL/SQL Developer with 12 years of experience in database development, performance optimization, data modeling, ETL processes, and enterprise data management.

The ideal candidate should have strong hands‑on expertise in Oracle SQL, PL/SQL programming, stored procedures, functions, packages, triggers, database performance tuning, and complex query optimization.

Key Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL procedures, functions, packages, triggers, and database objects.

• Develop and optimize complex SQL queries for large-scale enterprise applications.

• Perform SQL and PL/SQL performance tuning using Explain Plan, SQL Trace, TKPROF, and AWR reports.

• Design and implement ETL processes for data extraction, transformation, and loading.

• Develop and maintain database solutions supporting enterprise data warehouses.

• Work with Oracle Database 12c, 19c, and newer versions.

• Develop complex SQL scripts, views, materialized views, indexes, and partitions.

• Implement database performance optimization strategies for high-volume transactional systems.

• Design and maintain data models, schemas, and database architecture.

• Perform data migration, data integration, and database modernization activities.

• Develop batch processing solutions using PL/SQL and Unix/Linux shell scripting.

• Troubleshoot database performance issues, production defects, and data inconsistencies.

• Implement database security, data integrity, and access control mechanisms.

• Collaborate with business analysts, data engineers, application developers, and QA teams.

• Participate in Agile/Scrum ceremonies, code reviews, and technical documentation.

• Provide technical leadership and mentoring to junior developers.

Required Technical Skills

Database Technologies

• Oracle Database 12c/19c/21c

• Oracle SQL and PL/SQL

• SQL Server (preferred)

• Relational Database Management Systems (RDBMS)

PL/SQL Development

• Stored Procedures

• Functions

• Packages

• Triggers

• Cursors

• Collections

• Bulk Collect and FORALL

• Dynamic SQL

• Exception Handling

Performance Tuning

• SQL Query Optimization

• Explain Plan

• Indexing and Partitioning

• AWR and ASH Reports

• SQL Trace and TKPROF

• Database Performance Monitoring

ETL & Data Integration

• Informatica PowerCenter

• Oracle Data Integrator (ODI)

• SQL Loader

• External Tables

• Data Migration

• Data Warehousing

• ETL/ELT Pipeline Development

Preferred Qualifications

• Experience in Banking, Financial Services, Healthcare, or Insurance domains.

• Experience with Oracle-to-cloud database migration.

• Knowledge of AWS, Azure, or Oracle Cloud.

• Experience with Informatica, ODI, SSIS, or Azure Data Factory.

• Familiarity with CI/CD pipelines and DevOps practices.

• Experience leading database modernization and performance optimization initiatives.

Mandatory Skills

1. Oracle PL/SQL Development — 12 Years

2. Advanced SQL Queries and Performance Tuning

3. Stored Procedures, Functions, Packages, and Triggers

4. Oracle Database 12c/19c

5. ETL Development and Data Integration

6. Data Warehousing and Data Modeling

7. Unix/Linux Shell Scripting

8. Database Optimization and Troubleshooting