Job Title: Oracle PL/SQL Developer

Location: Charlotte, NC (Hybrid/Onsite)
Duration: Long-Term Contract (12+ Months)
Experience: 12+ Years

Job Summary

We are seeking an experienced Oracle PL/SQL Developer with 12+ years of hands-on experience in designing, developing, optimizing, and supporting enterprise database applications. The ideal candidate will possess deep expertise in Oracle Database, PL/SQL programming, SQL performance tuning, ETL development, and data modeling. Experience working in Banking, Financial Services, Insurance, Healthcare, or Retail domains is highly preferred.

The candidate should have strong analytical skills, extensive experience with large-scale transactional databases, and the ability to collaborate with cross-functional teams in an Agile environment.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, and triggers.
• Develop high-performance SQL queries and optimize existing database objects for maximum efficiency.
• Design and implement scalable database solutions supporting enterprise applications.
• Analyze business requirements and translate them into technical database solutions.
• Create and maintain database schemas, indexes, constraints, sequences, views, and materialized views.
• Perform SQL and PL/SQL performance tuning using Explain Plan, SQL Trace, TKPROF, AWR, and Oracle Enterprise Manager.
• Develop ETL processes for loading, cleansing, transforming, and validating large volumes of data.
• Build and maintain data migration, reconciliation, and data validation processes.
• Work closely with application developers to integrate Oracle database solutions with Java, .NET, or cloud-based applications.
• Develop batch processing and scheduling solutions using Oracle Scheduler, Shell Scripts, or Autosys.
• Support production deployments, troubleshoot performance issues, and perform root cause analysis.
• Participate in code reviews and ensure adherence to coding standards and best practices.
• Create technical documentation, database design documents, and operational runbooks.
• Collaborate with QA, Business Analysts, Architects, and DevOps teams throughout the SDLC.
• Participate in Agile ceremonies including sprint planning, backlog grooming, daily stand-ups, and retrospectives.

Required Technical Skills

Oracle Database

• Oracle Database 12c/19c/21c
• Oracle PL/SQL
• SQL Optimization
• Oracle SQL Developer
• TOAD
• Oracle Enterprise Manager (OEM)

PL/SQL Development

• Packages
• Procedures
• Functions
• Triggers
• Cursors
• Collections
• Bulk Collect
• FORALL
• Exception Handling
• Dynamic SQL
• Ref Cursors

Database Design

• Data Modeling
• ER Modeling
• Normalization
• Partitioning
• Indexing
• Materialized Views
• Constraints
• Sequences
• Synonyms

Performance Tuning

• SQL Performance Tuning
• PL/SQL Optimization
• Explain Plan
• SQL Trace
• TKPROF
• AWR Reports
• ASH Reports
• Execution Plans
• Query Optimization
• Index Optimization

ETL & Data Integration

• Oracle Data Integrator (ODI)
• Informatica (Preferred)
• Data Migration
• Data Validation
• Data Cleansing
• Data Reconciliation
• Batch Processing

Database Administration Knowledge

• Oracle Backup & Recovery
• RMAN
• Data Pump
• Oracle Scheduler
• User Management
• Security & Privileges

Programming & Scripting

• Shell Scripting
• UNIX/Linux
• Python (Preferred)

Version Control & CI/CD

• Git
• Bitbucket
• Jenkins
• Azure DevOps

Cloud (Preferred)

• Oracle Cloud Infrastructure (OCI)
• AWS RDS Oracle
• Azure Oracle Database

Required Qualifications

• Bachelor''s or Master''s degree in Computer Science, Information Technology, Engineering, or related field.
• 12+ years of experience in Oracle Database Development.
• Extensive experience writing complex SQL and PL/SQL programs.
• Strong knowledge of Oracle Database architecture and optimization techniques.
• Experience working with very large databases (VLDB).
• Strong experience in SQL performance tuning and database optimization.
• Experience developing ETL processes and data migration solutions.
• Experience with Oracle Scheduler, batch processing, and job automation.
• Hands-on experience supporting production databases and troubleshooting issues.
• Strong understanding of relational database concepts and data modeling.
• Experience with Agile/Scrum software development methodologies.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong communication and stakeholder management abilities.

Preferred Qualifications

• Experience in Banking, Financial Services, Healthcare, Insurance, or Retail domains.
• Experience with Oracle RAC and Oracle Exadata.
• Experience with Oracle GoldenGate or Data Guard.
• Knowledge of Snowflake, Databricks, or cloud data platforms.
• Familiarity with Kafka or event-driven architectures.
• Experience with REST APIs and database integration.
• Oracle Database Certification (OCP/OCE).
• Experience working with DevOps and CI/CD pipelines.