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

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., * 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

• 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, 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