Senior Oracle Database & PL/SQL Developer

PATEL FALGUNI

Senior Oracle Database & PL/SQL Developer 12+ Years Oracle 19c/12c/11g SQL Performance Tuning AWR ADDM TKPROF Data Migration Oracle Data Pump SQL*Loader Unix/Linux Git Jenkins Enterprise Banking Retail Government

Phone: 347-***-**** Email: ****************@*****.***

PROFESSIONAL SUMMARY

Senior Oracle Database & PL/SQL Developer with 12+ years of progressive IT experience in designing, developing, enhancing, and supporting enterprise Oracle database applications across Banking, Financial Services, Retail, State Government, and Enterprise Software domains. Extensive hands-on expertise in Oracle Database 19c/12c/11g, SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Cursors, Views, Materialized Views, Indexing, Query Optimization, Database Design, Performance Tuning, Data Modeling, Data Validation, Data Migration, and Production Support. Highly proficient in SQL performance tuning using AWR, ADDM, SQL Trace, TKPROF, Explain Plan, Execution Plans, and Optimizer Statistics to improve application performance, scalability, and database efficiency. Strong experience with Oracle SQL Developer, TOAD, SQLPlus, Oracle Enterprise Manager, Oracle Data Pump, SQLLoader, Unix/Linux, Shell Scripting, Git, GitHub, and Jenkins, supporting the complete Software Development Life Cycle (SDLC) in Agile environments.

Demonstrated success in delivering business-critical database solutions for leading organizations including Wells Fargo, The Home Depot, State Street, State of Texas, and BMC Software, developing high-volume transaction processing systems, batch-processing solutions, database automation, and data integration workflows. Experienced in database architecture, SQL and PL/SQL development, production troubleshooting, root cause analysis, data reconciliation, release management, and cross-functional collaboration with business analysts, QA teams, application developers, and infrastructure teams. Proven ability to translate complex business requirements into scalable, high-performance Oracle database solutions while ensuring data integrity, application reliability, and operational excellence. A results-driven professional with strong analytical, problem-solving, communication, and technical leadership skills, committed to delivering secure, efficient, and high-quality enterprise database solutions.

TECHNICAL SKILLS

Programming Languages

SQL, PL/SQL, Dynamic SQL, Shell Scripting (Bash)

Oracle Database

Oracle Database 19c, 12c, 11g

PL/SQL Development

Stored Procedures, Packages, Functions, Triggers, Cursors, Collections, Exception Handling, Dynamic SQL

SQL Development

Complex SQL Queries, Joins, Subqueries, Common Table Expressions (CTEs), Analytical Functions, Aggregations, Views, Materialized Views

Database Design & Development

Database Design, Data Modeling, Schema Design, Tables, Indexes, Sequences, Synonyms, Constraints, Referential Integrity, Database Objects

Performance Tuning

SQL Performance Tuning, Query Optimization, Explain Plan, Execution Plans, Optimizer Statistics, AWR, ADDM, SQL Trace, TKPROF

Data Migration & Integration

Oracle Data Pump, SQL*Loader, External Tables, Data Migration, Data Validation, Data Transformation, Data Reconciliation, Batch Processing

Oracle Development Tools

Oracle SQL Developer, TOAD, SQL*Plus, Oracle Enterprise Manager

Operating Systems

Unix, Linux

Scripting & Automation

Shell Scripting, Bash, Cron Jobs, Batch Automation, File Processing

Version Control & CI/CD

Git, GitHub, Jenkins, Version Control, Build Automation, Deployment Support

Production Support

Production Troubleshooting, Incident Management, Root Cause Analysis (RCA), SQL Debugging, PL/SQL Debugging, Job Monitoring, Release Validation

Testing & Quality Assurance

Unit Testing, Integration Testing, Regression Testing, SQL Validation, Data Reconciliation, Defect Analysis, Production Verification

Development Methodologies

SDLC, Agile/Scrum, Requirement Analysis, Code Reviews, Change Management, Release Management

Business Domains

Banking, Financial Services, Retail, State Government, Enterprise Software

PROFESSIONAL EXPERIENCE

Wells Fargo Senior Oracle Database Developer

Jun 2023 – Oct 2026 (Remote)

Designed, developed, and enhanced enterprise Oracle Database 19c solutions using advanced SQL and PL/SQL to support high-volume banking applications for customer, account, and transaction processing.

Developed and maintained complex PL/SQL packages, stored procedures, functions, triggers, cursors, views, and materialized views to implement scalable and maintainable business logic.

Wrote optimized SQL queries utilizing joins, subqueries, Common Table Expressions (CTEs), analytical functions, and aggregations to support mission-critical banking applications and operational reporting.

Performed SQL performance tuning using Explain Plan, Execution Plans, Indexing, Optimizer Statistics, AWR, ADDM, SQL Trace, and TKPROF, improving database efficiency and query performance.

Designed and maintained Oracle database objects including tables, indexes, sequences, synonyms, constraints, and schema objects while ensuring data integrity and application reliability.

Developed robust data validation, reconciliation, and transformation processes to ensure consistency and accuracy across customer, account, transaction, and reporting databases.

Supported large-scale batch processing by developing Unix/Linux shell scripts integrated with Oracle PL/SQL to automate file processing, database loads, scheduled jobs, and validation routines.

Executed data migration and bulk-loading activities using Oracle Data Pump and SQL*Loader, validating source-to-target data, load results, rejected records, and overall data quality.

Investigated and resolved complex production issues involving SQL failures, PL/SQL exceptions, long-running queries, batch-job failures, and database performance bottlenecks through detailed root cause analysis.

Utilized Oracle SQL Developer, TOAD, SQL*Plus, and Oracle Enterprise Manager for SQL development, PL/SQL debugging, performance analysis, database administration support, and production validation.

Managed database source code through Git and GitHub while supporting Jenkins-based CI/CD deployment processes, ensuring controlled releases and successful post-deployment validation.

Collaborated closely with business analysts, application developers, QA engineers, infrastructure teams, and project stakeholders throughout Agile/Scrum and SDLC phases to deliver high-quality database solutions.

Participated in requirements analysis, technical design, code reviews, release planning, defect resolution, production support, and continuous process improvements to enhance application stability and performance.

Delivered secure, scalable, and high-performance Oracle database solutions by following enterprise coding standards, database best practices, change management procedures, and release governance, ensuring reliable support for business-critical banking operations.

The Home Depot Senior Oracle Database Developer

Feb 2021 – May 2023 Atlanta, GA USA (Hybrid)

Developed and enhanced enterprise Oracle Database 19c/12c applications using advanced SQL and PL/SQL to support high-volume retail business operations, including product, inventory, customer, order, and store management systems.

Designed, developed, and maintained complex PL/SQL packages, stored procedures, functions, triggers, cursors, views, and materialized views to implement scalable business logic and improve application performance.

Created optimized SQL queries using joins, subqueries, Common Table Expressions (CTEs), analytical functions, aggregations, and set operators to process large volumes of retail transaction data efficiently.

Performed SQL performance tuning using Explain Plan, Execution Plans, Indexing, Optimizer Statistics, AWR, ADDM, SQL Trace, and TKPROF to improve database performance and reduce query execution time.

Designed and maintained Oracle database objects including tables, indexes, sequences, synonyms, constraints, and schemas while ensuring data integrity, consistency, and application reliability.

Developed automated data validation, reconciliation, and transformation routines to verify product, customer, inventory, order, and transaction data across multiple Oracle database environments.

Built Unix/Linux shell scripts integrated with Oracle PL/SQL to automate batch processing, scheduled jobs, file handling, database loading, validations, and recurring operational activities.

Supported enterprise data migration and bulk-loading initiatives using Oracle Data Pump and SQL*Loader by validating source-to-target data, rejected records, load statistics, and overall data quality.

Investigated and resolved production issues involving SQL errors, PL/SQL exceptions, long-running queries, failed batch jobs, and data inconsistencies through detailed root cause analysis and corrective actions.

Utilized Oracle SQL Developer, TOAD, SQL*Plus, and Oracle Enterprise Manager for SQL development, PL/SQL debugging, performance analysis, testing, production validation, and database support activities.

Managed database source code using Git and GitHub while supporting Jenkins CI/CD deployment pipelines, release management, version control, and post-production validation.

Collaborated with business analysts, application developers, QA engineers, infrastructure teams, and project stakeholders throughout Agile/Scrum and SDLC phases to deliver high-quality Oracle database solutions.

Participated in technical design discussions, requirements analysis, code reviews, unit testing, defect resolution, release planning, production support, and continuous process improvement initiatives.

Delivered secure, scalable, high-performance Oracle database solutions by following enterprise coding standards, database best practices, change management processes, and release governance to support mission-critical retail applications.

State Street Oracle Developer

Apr 2019 – Jan 2021 Austin, TX USA (Remote)

Developed and enhanced Oracle Database 12c/11g applications using advanced SQL and PL/SQL to support enterprise financial services, investment, account, and transaction processing systems.

Designed and maintained PL/SQL packages, stored procedures, functions, triggers, cursors, views, and other database objects to implement scalable business logic and support critical financial applications.

Developed complex SQL queries using joins, subqueries, Common Table Expressions (CTEs), analytical functions, and aggregations to retrieve, validate, and process high-volume financial data.

Performed SQL performance tuning using Explain Plan, Execution Plans, Indexing, Optimizer Statistics, AWR, ADDM, SQL Trace, and TKPROF to improve query efficiency and overall database performance.

Built comprehensive data validation and reconciliation routines to identify data inconsistencies between source and target systems while ensuring data accuracy and integrity.

Developed Unix/Linux shell scripts to automate Oracle batch processing, scheduled jobs, file handling, and recurring database operations supporting financial data workflows.

Supported enterprise data migration and bulk-loading activities using Oracle Data Pump and SQL*Loader, validating source-to-target data, resolving load exceptions, and maintaining data quality.

Designed and maintained Oracle database objects including tables, indexes, sequences, synonyms, constraints, and views to support application functionality and operational reporting requirements.

Investigated and resolved production issues involving SQL errors, PL/SQL exceptions, failed batch jobs, long-running queries, and database performance bottlenecks through detailed root cause analysis.

Utilized Oracle SQL Developer, TOAD, SQL*Plus, and Oracle Enterprise Manager for SQL development, PL/SQL debugging, database testing, performance analysis, and production support activities.

Collaborated with business analysts, application developers, QA engineers, and cross-functional teams throughout Agile/SDLC phases, supporting requirements analysis, code reviews, testing, release management, and production deployments.

Delivered secure, scalable, and high-performance Oracle database solutions by following enterprise development standards, database best practices, and change management processes while supporting mission-critical financial applications.

State of Texas Oracle Developer

Jan 2018 – Mar 2019 Austin, TX USA (On-Site)

Developed and enhanced Oracle Database 12c/11g applications using SQL and PL/SQL to support state government systems managing citizen services, program administration, eligibility, and case management.

Designed and maintained PL/SQL packages, stored procedures, functions, triggers, cursors, views, and other database objects to implement business rules and streamline government application workflows.

Developed complex SQL queries using joins, subqueries, Common Table Expressions (CTEs), analytical functions, and aggregations to support operational reporting, data retrieval, and business validation requirements.

Performed SQL performance tuning using Explain Plan, Execution Plans, Indexing, Optimizer Statistics, and query optimization techniques to improve database response time and batch-processing efficiency.

Built PL/SQL-based data validation and reconciliation routines to identify duplicate, missing, and inconsistent records while ensuring the accuracy and integrity of government application data.

Developed Unix/Linux shell scripts to automate Oracle batch processing, scheduled jobs, file processing, database validation, and recurring operational activities.

Supported enterprise data migration and bulk-loading activities using Oracle Data Pump and SQL*Loader by validating source-to-target data, investigating rejected records, and maintaining data quality.

Designed and maintained Oracle database objects including tables, indexes, sequences, synonyms, constraints, and views to support application functionality, reporting requirements, and database integrity.

Investigated and resolved production issues involving SQL errors, PL/SQL exceptions, failed batch jobs, data discrepancies, and database performance issues by performing detailed root cause analysis and implementing corrective solutions.

Utilized Oracle SQL Developer, TOAD, SQL*Plus, and Oracle Enterprise Manager for SQL development, PL/SQL debugging, database testing, performance analysis, and production support.

Collaborated with business analysts, application developers, QA engineers, and cross-functional teams throughout Agile/SDLC phases, supporting requirements gathering, code reviews, testing, release management, and production deployments.

Delivered reliable, secure, and scalable Oracle database solutions by following enterprise development standards, database best practices, coding guidelines, and change management processes to support mission-critical government applications.

BMC Software India Private Limited Junior Oracle Developer

Aug 2013 – Nov 2016 Pune, India (On-Site)

Developed and maintained Oracle Database 11g applications using SQL and PL/SQL to support enterprise software solutions, backend data processing, and business application workflows.

Designed and implemented PL/SQL packages, stored procedures, functions, triggers, cursors, and views to automate database operations and deliver scalable, maintainable application functionality.

Developed complex SQL queries using joins, subqueries, analytical functions, aggregations, and correlated queries for reporting, data validation, and operational data processing.

Performed SQL troubleshooting and basic performance tuning using Explain Plan, indexing strategies, and query optimization techniques to improve database efficiency and application performance.

Developed Unix/Linux shell scripts to automate batch processing, scheduled database jobs, file handling, and recurring operational tasks supporting enterprise applications.

Utilized Oracle SQL Developer, TOAD, and SQL*Plus for SQL development, PL/SQL debugging, database testing, data validation, and application support throughout the development lifecycle.

Participated in unit testing, integration testing, defect analysis, and production support while collaborating with senior developers, QA teams, and business analysts to resolve database-related issues and deliver high-quality solutions.

Followed SDLC, coding standards, documentation, code review, change management, and release management best practices, building a strong foundation in Oracle database development and enterprise application support.

Contact this candidate