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
Never miss an opportunity! Create an alert based on the job you applied for.
