Senior Oracle Developer (PL/SQL, SQL Tuning)

Venkata Sai Vardhan B

Senior Oracle Developer Oracle PL/SQL Oracle SQL Oracle Database 19c/21c Performance Tuning ETL Oracle APEX Oracle Forms & Reports REST APIs Banking Financial Services Capital Markets

Contact: +1-347-***-**** Gmail: ************@*****.***

Location : Austin, TX

PROFESSIONAL SUMMARY

Senior Oracle Developer with over 12 years of experience designing, developing, optimizing, and supporting enterprise Oracle database solutions for Banking, Financial Services, Capital Markets, Retail, and Manufacturing organizations. Extensive hands-on experience in developing high-performance database applications using Oracle Database 11g/12c/19c/21c, Oracle SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Views, Materialized Views, Collections, Dynamic SQL, Bulk Processing, and Performance Tuning, delivering scalable, secure, and mission-critical enterprise solutions.

Proficient in designing robust database architectures, developing complex business logic, optimizing SQL execution plans, implementing indexing, partitioning, and query tuning strategies, and building scalable ETL and data migration solutions using SQL*Loader, Oracle Data Pump, External Tables, and Oracle Scheduler. Strong expertise in integrating Oracle databases with enterprise applications using REST APIs, JDBC, XML, JSON, Java, and Oracle integration technologies to support high-volume transactional systems and real-time business processing.

Hands-on experience with Oracle SQL Developer, TOAD, Oracle Enterprise Manager (OEM), Oracle APEX, Oracle Forms & Reports, Git, Jenkins, Azure DevOps, Maven, Jira, Confluence, Linux/Unix, Shell Scripting, and CI/CD pipelines, with a strong focus on production support, release management, database security, root cause analysis, and application performance optimization. Adept at collaborating with business stakeholders, architects, developers, QA teams, and DBAs in Agile/Scrum environments to deliver reliable, scalable, and compliant enterprise database solutions while consistently improving application performance, operational efficiency, and business outcomes.

TECHNICAL SKILLS

Category

Technologies / Tools

Programming Languages

SQL, PL/SQL, Java, Shell Scripting (Bash), Python (Basic)

Oracle Database

Oracle Database 11g, 12c, 18c, 19c, 21c, Oracle Multitenant (CDB/PDB), Oracle RAC, Oracle ASM

Oracle Development

PL/SQL Packages, Procedures, Functions, Triggers, Views, Materialized Views, Cursors, Collections, Bulk Collect, FORALL, Dynamic SQL, Analytical Functions, MERGE, Common Table Expressions (CTE), Global Temporary Tables

Database Design & Modeling

ER Modeling, Data Modeling, Schema Design, Database Normalization, Referential Integrity, Data Dictionary Management

Performance Tuning

SQL Query Optimization, Execution Plans, Explain Plan, AWR Reports, ASH Reports, ADDM, SQL Trace, TKPROF, Index Optimization, Partitioning, Optimizer Hints, SQL Profiles, Parallel Query, DBMS_STATS

Data Migration & ETL

SQL*Loader, Oracle Data Pump (EXPDP/IMPDP), External Tables, Oracle Scheduler, ETL Development, Data Migration, Data Validation, Oracle GoldenGate (Exposure)

Oracle Technologies

Oracle APEX, Oracle Forms & Reports, Oracle SQL Developer, TOAD, SQL*Plus, Oracle Enterprise Manager (OEM), Oracle XML DB

Integration Technologies

REST APIs, SOAP Web Services, JDBC, JSON, XML, Oracle Integration, API Integration

Cloud & DevOps

Oracle Cloud Infrastructure (OCI), AWS (EC2, S3, RDS), Microsoft Azure, Git, GitHub, GitLab, Bitbucket, Jenkins, Maven, Azure DevOps, CI/CD Pipelines

Operating Systems

Linux (RHEL), UNIX (AIX), Windows Server

Testing & Debugging

Unit Testing, Debugging, Root Cause Analysis, Performance Testing, Code Reviews

Reporting Tools

Oracle Reports, BI Publisher, Oracle Analytics (Exposure), Crystal Reports (Exposure)

Methodologies

Agile (Scrum), Waterfall, Software Development Life Cycle (SDLC), Sprint Planning, Backlog Grooming, Release Management

Project Management & Collaboration

Jira, Confluence, ServiceNow, Microsoft Teams

Database Administration (Working Knowledge)

RMAN, Backup & Recovery, Oracle Data Guard, User & Role Management, Database Monitoring, Patch Validation

Business Domains

Banking, Financial Services, Capital Markets, Retail, Manufacturing, Insurance, Enterprise Applications

PROFESSIONAL EXPERIENCE

Capital One Senior Oracle Developer

May 2023 – September 2026 Austin, TX

Designed, developed, and optimized enterprise-grade Oracle database solutions using Oracle 19c/21c, SQL, and PL/SQL to support high-volume banking applications, improving transaction processing performance and system scalability.

Developed complex PL/SQL packages, procedures, functions, triggers, and materialized views to automate business workflows, ensuring secure and efficient processing of financial transactions.

Optimized complex SQL queries using AWR, ASH, Explain Plan, SQL Trace, indexing, and partitioning techniques, reducing execution time by 35% and improving overall database performance.

Designed and implemented RESTful API integrations between Oracle databases and enterprise applications, enabling secure real-time data exchange across digital banking and payment platforms.

Built and maintained scalable ETL and data migration processes using SQL*Loader, Data Pump (EXPDP/IMPDP), External Tables, and Oracle Scheduler, ensuring accurate and reliable movement of large financial datasets.

Collaborated with solution architects, business analysts, and application development teams to translate business requirements into robust database designs, supporting Agile-based enterprise application delivery.

Performed database performance monitoring and production support using Oracle Enterprise Manager (OEM), SQL Developer, TOAD, and Oracle diagnostic tools, proactively resolving performance bottlenecks and critical production issues.

Developed reusable PL/SQL components and standardized coding frameworks, improving development efficiency, reducing code redundancy, and maintaining enterprise coding standards across multiple applications.

Implemented robust exception handling, auditing, logging, and data validation mechanisms within PL/SQL programs to ensure data integrity, regulatory compliance, and secure financial processing.

Supported CI/CD release activities using Git, Jenkins, Azure DevOps, and Jira, participating in code reviews, deployment planning, release validation, and post-production verification across multiple environments.

Worked extensively with Oracle Database 19c/21c, Linux, Shell Scripting, and batch scheduling to automate recurring database processes, reducing manual effort and improving operational efficiency.

Partnered with infrastructure and DBA teams to support database upgrades, patch validation, backup verification, and environment migrations while ensuring high availability and minimal production downtime.

Participated in Agile Scrum ceremonies including sprint planning, backlog refinement, estimation, and retrospective meetings, consistently delivering high-quality solutions within sprint timelines and business priorities.

Mentored junior Oracle developers by conducting technical reviews, sharing PL/SQL best practices, and promoting performance optimization techniques, contributing to improved code quality and faster project delivery.

Mizuho Bank Senior Oracle Developer

August 2021 – June 2023 Houston, TX (Hybrid)

Designed and developed enterprise-grade Oracle database applications using Oracle 19c, SQL, and PL/SQL to support corporate banking, treasury management, loan processing, and payment transaction systems with high availability and performance.

Developed complex PL/SQL packages, stored procedures, functions, triggers, collections, and cursors to automate business processes, improving transaction accuracy and reducing manual intervention across banking operations.

Optimized high-volume SQL queries by leveraging AWR Reports, ASH, Explain Plan, indexing, partitioning, and optimizer hints, reducing response times by 40% for critical financial reporting applications.

Developed secure REST API-enabled database services to integrate Oracle applications with Java-based enterprise systems, enabling seamless real-time data exchange between internal banking platforms and external payment gateways.

Built and maintained ETL workflows using SQL*Loader, External Tables, Oracle Data Pump, and Oracle Scheduler for processing large volumes of customer, transaction, and compliance data with improved efficiency.

Designed normalized database schemas and data models supporting commercial banking applications, ensuring data integrity, scalability, and compliance with enterprise data governance standards.

Collaborated with business analysts, solution architects, and development teams to analyze business requirements, perform impact assessments, and deliver scalable Oracle database solutions within Agile development cycles.

Implemented comprehensive exception handling, auditing, logging, and validation mechanisms within PL/SQL programs to improve application reliability, simplify troubleshooting, and support regulatory compliance initiatives.

Performed production support activities by analyzing application logs, resolving database performance issues, troubleshooting SQL execution problems, and implementing permanent fixes while consistently meeting SLA targets.

Automated recurring database processes using Oracle Scheduler, Shell Scripting, Git, and Jenkins, streamlining deployment activities and reducing manual operational effort across development, testing, and production environments.

Supported database release management activities, including code migration, deployment validation, regression testing, and post-production verification, ensuring smooth application rollouts with minimal business disruption.

Worked closely with infrastructure and DBA teams during database upgrades, environment refreshes, backup validations, and performance tuning initiatives to maintain highly available and secure Oracle environments.

Participated actively in Agile Scrum ceremonies, technical design discussions, code reviews, and mentoring junior developers by promoting Oracle development best practices, coding standards, and database performance optimization techniques.

Broadridge Financial Solutions Oracle Developer

September 2019 – July 2021 Boston, MA (Hybrid)

Developed and enhanced enterprise Oracle database applications using Oracle 12c/19c, SQL, and PL/SQL to support capital markets, securities processing, trade lifecycle management, and post-trade settlement systems.

Designed and implemented complex PL/SQL packages, stored procedures, functions, triggers, and database objects to automate trade processing, reconciliation, and financial reporting, improving transaction accuracy and operational efficiency.

Optimized high-volume SQL queries using Explain Plan, AWR Reports, indexing, partitioning, and optimizer hints, improving batch processing performance by 35% and reducing database response times.

Developed scalable ETL processes using SQL*Loader, External Tables, Oracle Data Pump (EXPDP/IMPDP), and Oracle Scheduler to process large volumes of trading, portfolio, and settlement data with high reliability.

Designed relational database models, normalized schemas, and implemented referential integrity constraints to support enterprise trading platforms while maintaining data consistency and regulatory compliance.

Developed secure database interfaces and REST API integrations with Java-based applications, enabling seamless communication between Oracle databases and enterprise investment management platforms.

Collaborated with business analysts, solution architects, and QA teams to analyze business requirements, prepare technical designs, and deliver scalable Oracle database solutions within Agile development environments.

Implemented advanced exception handling, auditing, logging, and validation mechanisms in PL/SQL modules, improving application stability and simplifying production issue analysis.

Performed production support activities by troubleshooting performance bottlenecks, resolving data inconsistencies, optimizing SQL execution plans, and ensuring critical financial applications consistently met SLA requirements.

Automated recurring database processes using Oracle Scheduler, Shell Scripting, Git, and Jenkins, reducing manual intervention and improving deployment consistency across development, testing, and production environments.

Participated in application release management, database deployments, regression testing, and production validations, ensuring successful implementation of new business functionality with minimal operational impact.

Worked closely with DBA and infrastructure teams to support database upgrades, patch implementations, backup verification, and environment migrations while maintaining high availability and business continuity.

Participated in Agile Scrum ceremonies, peer code reviews, technical knowledge sharing, and continuous process improvement initiatives, contributing to enhanced code quality, faster delivery cycles, and improved team productivity.

Etsy Oracle Developer

February 2017 – August 2019 Chicago, IL (On-Site)

Developed and maintained enterprise database applications using Oracle Database 12c, SQL, and PL/SQL to support e-commerce operations, seller management, inventory tracking, order processing, and payment reconciliation systems.

Designed and implemented PL/SQL packages, stored procedures, functions, triggers, and views to automate order fulfillment, inventory synchronization, and financial reconciliation, improving operational efficiency and data accuracy.

Developed optimized SQL queries, indexes, and database objects for high-volume transactional systems, improving application response time by 30% and supporting peak shopping events with minimal latency.

Built and maintained data loading and migration processes using SQL*Loader, Oracle Data Pump, External Tables, and Oracle Scheduler, ensuring reliable movement of product, customer, and transaction data across environments.

Integrated Oracle database applications with Java-based web services and REST APIs, enabling secure and efficient communication between e-commerce applications, payment gateways, and inventory management platforms.

Collaborated with business analysts, developers, and QA teams to gather requirements, prepare technical specifications, and implement scalable database solutions following Agile Scrum methodologies.

Performed production support by analyzing SQL performance issues, resolving application defects, optimizing database objects, and implementing permanent fixes to maintain system stability and meet business SLAs.

Participated in application deployments, code migrations, unit testing, integration testing, and release validation using Git, Jenkins, Jira, and SQL Developer, ensuring smooth production releases with minimal downtime.

Created technical documentation, database design specifications, data flow diagrams, and operational procedures to support application maintenance, knowledge transfer, and audit compliance activities.

Worked closely with senior developers and DBAs to implement database performance improvements, coding standards, and best practices while contributing to continuous enhancements across enterprise retail applications.

Schneider Electric Junior Oracle Developer

February 2014 – January 2017 Cincinnati, OH (On-Site)

Developed and maintained Oracle database applications using Oracle 11g, SQL, and PL/SQL to support manufacturing operations, production planning, inventory management, and supply chain processes across enterprise applications.

Created and enhanced PL/SQL packages, stored procedures, functions, triggers, views, and cursors to automate business workflows, improve data processing efficiency, and ensure accurate transaction management.

Developed SQL queries and reports to support production scheduling, inventory analysis, procurement activities, and operational reporting, enabling business users to make timely data-driven decisions.

Assisted in designing database objects, implementing data validation rules, and maintaining referential integrity to support reliable and consistent enterprise data management.

Participated in developing data migration and batch processing solutions using SQL*Loader, Oracle Data Pump, and Oracle Scheduler, ensuring accurate loading of manufacturing and inventory data across multiple environments.

Worked with Java development teams to support Oracle database integrations through JDBC, REST APIs, and XML-based interfaces, enabling seamless communication between enterprise applications.

Assisted in performance tuning activities by optimizing SQL queries, creating indexes, analyzing execution plans, and resolving database performance issues under senior developer guidance.

Participated in unit testing, integration testing, defect resolution, and production support activities while collaborating with QA teams to ensure stable application releases and adherence to quality standards.

Worked in an Agile Scrum environment, collaborating with senior developers, business analysts, and project managers to deliver application enhancements, maintain technical documentation, and support continuous process improvements.

Supported application deployment, code migration, release validation, and post-production monitoring using Oracle SQL Developer, TOAD, Git, Jenkins, and Jira, contributing to successful project deliveries and operational stability.

Contact this candidate