Senior PL/SQL Developer

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

• Oracle PL/SQL Development – 12+ Years
• Advanced SQL Queries and Performance Tuning
• Stored Procedures, Functions, Packages, and Triggers
• Oracle Database 12c/19c
• ETL Development and Data Integration
• Data Warehousing and Data Modeling
• Unix/Linux Shell Scripting
• Database Optimization and Troubleshooting