Senior Oracle PL/SQL Developer (11+ Years Experience)

Professional Summary

Highly accomplished Senior Oracle PL/SQL Developer with over 11 years of experience in designing, developing, optimizing, and maintaining enterprise-grade database applications using Oracle technologies. Expertise in developing complex PL/SQL packages, procedures, functions, triggers, and performance tuning for mission-critical applications. Strong background in database design, ETL development, data migration, and integration with enterprise systems. Experienced in Agile development, production support, and delivering scalable, high-performance database solutions across Banking, Healthcare, Insurance, Retail, and Financial Services domains.

Key Skills

• Oracle Database 11g/12c/19c

• Oracle PL/SQL

• SQL Performance Tuning

• Stored Procedures, Packages, Functions, Triggers

• Views, Materialized Views, Synonyms

• Query Optimization & Execution Plans

• Oracle SQL Developer, TOAD

• Oracle Data Pump (EXPDP/IMPDP)

• ETL Development & Data Migration

• Unix/Linux Shell Scripting

• Oracle Scheduler & DBMS Jobs

• Indexing, Partitioning, Constraints

• Bulk Collect, FORALL, Collections

• Dynamic SQL

• Exception Handling

• XML, JSON Processing in Oracle

• SQL Loader, External Tables

• Git, SVN

• Jira, Azure DevOps

• Agile & Scrum

• Production Support & Incident Management

Professional Experience

• Designed and developed scalable Oracle database solutions for large enterprise applications.

• Developed complex PL/SQL Packages, Procedures, Functions, Triggers, and Cursors to automate critical business processes.

• Optimized SQL queries and PL/SQL programs, significantly improving application performance and reducing execution time.

• Performed database performance tuning using Explain Plan, AWR Reports, SQL Trace, and Oracle tuning techniques.

• Developed ETL processes for large-scale data extraction, transformation, and loading from multiple data sources.

• Created and maintained database objects including tables, indexes, views, sequences, materialized views, and synonyms.

• Implemented Bulk Collect, FORALL, Collections, and Dynamic SQL to enhance processing efficiency.

• Worked extensively with Oracle Scheduler, DBMS Jobs, SQL Loader, and Data Pump utilities.

• Developed robust exception handling, logging, and auditing mechanisms to improve application reliability.

• Collaborated with application developers, architects, and business analysts to translate business requirements into technical solutions.

• Supported database deployments, release management, and production issue resolution.

• Participated in database migration, schema upgrades, and data validation activities.

• Conducted code reviews and mentored junior developers on Oracle development best practices.

• Worked in Agile/Scrum environments, participating in sprint planning, daily stand-ups, code reviews, and retrospectives.

• Ensured database security, data integrity, and compliance with organizational standards.

Technical Skills

Database: Oracle 11g, 12c, 19c

Programming: SQL, PL/SQL, Dynamic SQL

Development Tools: Oracle SQL Developer, TOAD

Performance Tuning: Explain Plan, AWR, SQL Trace, Indexing, Partitioning

ETL & Utilities: SQL Loader, Oracle Data Pump, External Tables

Operating Systems: Linux, Unix, Windows

Version Control: Git, SVN

Project Management: Jira, Azure DevOps

Methodologies: Agile, Scrum

Core Competencies

• Oracle Database Development

• Advanced PL/SQL Programming

• SQL Performance Optimization

• Database Performance Tuning

• ETL Development

• Data Migration

• Production Support

• Database Design

• Code Optimization

• Query Optimization

• Root Cause Analysis

• Team Leadership & Mentoring

• Client Communication

• Technical Documentation

• Problem Solving

Education

Bachelor''s Degree in Computer Science, Information Technology, Engineering, or a related field.

Preferred Certifications

• Oracle Certified Professional (OCP)

• Oracle Database SQL Certified Associate

• Oracle PL/SQL Developer Certified Professional