Oracle PL/SQL Developer with 7+ Years

Pravalika K

Oracle PL/SQL Developer

512-***-**** *********.***@*****.*** LinkedIn

PROFESSIONAL SUMMARY

Oracle PL/SQL Developer with 7+ years of experience in database development, performance tuning, ETL, data integration, and production support across healthcare, retail, and insurance domains. Strong hands-on experience developing complex SQL, PL/SQL packages, procedures, functions, triggers, and high-volume batch-processing solutions using BULK COLLECT, FORALL, collections, dynamic SQL, and exception handling. Expertise in Oracle 11g/12c/19c performance tuning using AWR, ASH, DBMS_XPLAN, Explain Plan, TKPROF, indexing, partitioning, and query optimization. Experienced in Informatica, IBM DataStage, SQL*Loader, AutoSys, TWS, Unix/Linux shell scripting, DBMS_SCHEDULER, and UTL_FILE for enterprise data processing and automation. Skilled in RESTful integrations using ORDS, Oracle Advanced Queuing, Oracle Forms, Reports, and BI Publisher. Hands-on experience with Oracle-to-Snowflake migration, AWS-based data integration, data validation, reconciliation, and audit controls. Experienced in database releases, schema migrations, CI/CD deployments, root cause analysis, and SLA-driven production support across multiple environments. Proven ability to collaborate with business, QA, DBA, architecture, and development teams throughout the SDLC in Agile environments.

SKILLS

Databases: Oracle 11g/12c/19c, PostgreSQL, Snowflake

Programming & Scripting: SQL, PL/SQL, Python, Unix Shell Scripting

Performance Tuning: AWR, ASH, DBMS_XPLAN, Explain Plan, TKPROF, SQL Trace, Query Optimization, Indexing, Partitioning

ETL & Data Integration: Informatica, IBM DataStage, SQL*Loader, External Tables, Data Modeling

Scheduling: DBMS_SCHEDULER, AutoSys, IBM TWS, Cron Jobs

APIs & Integration: REST APIs, ORDS, Oracle Advanced Queuing (AQ), UTL_FILE, JSON, XML

Oracle Technologies: Oracle APEX, Oracle Forms, Oracle Reports, BI Publisher

Cloud Technologies: AWS (S3, RDS, EC2), OCI

DevOps & Version Control: Git, GitHub, Bitbucket, Jenkins, Azure DevOps, CI/CD Pipelines

Development Tools: Oracle SQL Developer, SQL*Plus, TOAD, PgAdmin

Collaboration & Documentation: JIRA, Confluence, Technical Design Documents, Requirement Documentation

Operating Systems: Unix/Linux, Windows

Methodologies: Agile, Scrum, Waterfall SDLC

EXPERIENCE

CVS Health Senior Software Engineer Oct 2025 – Present

Partnered with business analysts and QA teams to translate pharmacy, claims, billing, and member requirements into scalable Oracle database solutions, defining technical specifications, data-processing rules, and validation requirements.

Designed and developed PL/SQL packages, procedures, functions, and batch-processing solutions using BULK COLLECT, FORALL, dynamic SQL, and exception handling to process 10M+ records while improving scalability and efficiency.

Built and automated ETL workflows using Informatica, PL/SQL, SQL*Loader, Python, and AutoSys, implementing transformation logic, data validations, dependency management, and failure notifications to support reliable high-volume data processing.

Developed RESTful APIs using Oracle REST Data Services (ORDS), including modules, templates, and handlers, integrating PL/SQL business logic to securely expose healthcare data to downstream applications and analytics platforms.

Designed Oracle Advanced Queuing (AQ) solutions using PL/SQL enqueue/dequeue processing and DBMS_SCHEDULER integration, implementing asynchronous messaging, controlled retries, and failure recovery for reliable downstream application integrations.

Developed and automated database workflows using DBMS_SCHEDULER, SQL*Plus, Unix/Linux shell scripts, cron jobs, and command-line utilities, implementing execution logging and scheduling controls to streamline Oracle database operations.

Developed and enhanced Oracle APEX applications using Interactive Reports, Interactive Grids, Forms, Dynamic Actions, AJAX callbacks, and PL/SQL processes, implementing real-time validations and user-friendly database workflows.

Implemented PL/SQL-based data validation, reconciliation, audit controls, and execution logging, performing detailed source-to-target comparisons and exception tracking to maintain healthcare data accuracy, traceability, and HIPAA compliance.

Optimized complex SQL and PL/SQL workloads using AWR, DBMS_XPLAN, Explain Plan, TKPROF, indexing, partitioning, and query optimization techniques, improving execution times by 35–50% across transactional and batch-processing workloads.

Supported Oracle-to-Snowflake data migration through data extraction, staging, schema mapping, file generation, and migration verification, ensuring consistent and accurate movement of enterprise data across database platforms.

Managed Oracle database releases, schema migrations, and PL/SQL deployments across Dev, QA, SIT, UAT, and Production environments, performing pre-deployment validation, post-deployment verification, and rollback planning.

Provided on-call production support for mission-critical Oracle applications, troubleshooting PL/SQL failures, batch-processing issues, data discrepancies, and performance problems, performing root cause analysis, and implementing permanent corrective fixes.

Tata Consultancy Services, India Systems Engineer Dec 2022 - Sep 2025

Designed and developed complex PL/SQL packages, procedures, and functions using collections, BULK operations, modular programming, and exception handling to support retail applications processing more than 2M transactions daily.

Designed and implemented Oracle data models and schema objects to support scalable retail applications, defining relational structures, data relationships, and integration requirements while improving maintainability across legacy and downstream systems.

Developed Unix shell scripts for file validation, decompression, data cleansing, format conversion, directory management, and preprocessing, ensuring inbound files were properly prepared before Oracle database and Informatica ETL processing.

Developed and optimized Informatica ETL workflows for high-volume retail data, implementing transformation logic, data validation, audit controls, exception handling, and batch-processing improvements that increased overall processing efficiency by 25%.

Performed source-to-target data reconciliation across source, staging, and target systems, identifying record mismatches, resolving data-quality issues, and ensuring accurate and consistent data availability for downstream reporting and business applications.

Performed PL/SQL unit testing, debugging, and peer code reviews, identifying logic, data, and performance issues before deployment while validating database functionality and maintaining established development and coding standards.

Refactored and optimized legacy SQL and PL/SQL modules using execution-plan analysis, indexing strategies, and query optimization techniques, identifying inefficient database operations and reducing query execution time by 20%.

Implemented Git and Jenkins-based CI/CD processes for Oracle SQL and PL/SQL deployments, enabling version-controlled database changes, automated deployment activities, and consistent releases across development, testing, and production environments.

Provided production support for business-critical Oracle applications, troubleshooting PL/SQL failures, Informatica job issues, data discrepancies, and performance problems, performing root cause analysis and implementing fixes within SLA timelines.

Accenture, India Application Development Analyst Oct 2020 - Nov 2022

Designed and developed Oracle PL/SQL packages, procedures, triggers, views, and complex SQL queries supporting high-volume retail merchandising and pricing applications, implementing business logic and reliable transactional data processing.

Designed and implemented end-to-end ETL workflows using IBM DataStage, performing data ingestion, transformation, validation, and reconciliation across multiple source systems while loading high-volume enterprise data into Oracle databases.

Developed Oracle BI Publisher reports using optimized SQL queries and materialized views, improving reporting performance and enabling efficient retrieval and presentation of large-volume retail merchandising and pricing data.

Automated database and batch-processing activities using Unix shell scripting and TWS scheduling, reducing manual intervention, recurring production issues, and operational effort while improving reliability of scheduled processing workflows.

Implemented standardized PL/SQL exception handling, auditing, and execution logging to capture processing errors, track batch execution details, support troubleshooting, and improve overall application stability and recoverability.

Performed unit-level validation and troubleshooting of PL/SQL and ETL processes by analyzing data flows, processing logic, execution results, and dependencies to identify defects before production implementation.

Performed SQL and PL/SQL performance tuning using AWR reports, Explain Plan, indexing strategies, and query optimization techniques, identifying inefficient database operations and improving application response time and database efficiency.

Performed root cause analysis of PL/SQL and batch-processing failures by analyzing logs, execution plans, and job dependencies, implementing permanent code and scheduling fixes that reduced recurring job failures by 30%.

Provided production support for business-critical Oracle applications, monitoring scheduled jobs, troubleshooting PL/SQL and batch-processing issues, resolving incidents within SLA timelines, and ensuring reliable availability of critical database applications.

Atos, India Associate Software Engineer Oct 2019 - Sep 2020

Developed and maintained Oracle PL/SQL packages, procedures, functions, and triggers supporting health insurance policy administration, member eligibility, claims processing, and coverage-related business rules.

Developed PL/SQL and SQL*Loader-based data-load processes handling 100K–500K records per run, validating member, policy, and claims data before loading into Oracle staging and target tables.

Developed Oracle Forms and Reports components integrated with PL/SQL business logic to support policy servicing, claims-related transactions, operational reporting, and day-to-day insurance application processing.

Implemented PL/SQL exception handling, auditing, and execution logging to capture processing errors, track batch execution details, support troubleshooting, and reduce batch failures and reprocessing effort by approximately 20%.

Performed source-to-target validation and reconciliation of insurance data across staging and target systems, identifying discrepancies in member, policy, and claims records and maintaining more than 99% data accuracy.

Supported SIT and UAT testing by analyzing PL/SQL defects, data-processing issues, validation failures, and application errors, implementing fixes and supporting successful completion of insurance business test scenarios.

Optimized SQL queries using joins, indexing strategies, and execution-plan analysis, improving batch-processing and reporting performance by approximately 15–20% across high-volume insurance data workloads.

Provided production support for business-critical health insurance applications, monitoring failed jobs, troubleshooting PL/SQL and data issues, rerunning batch processes, and resolving production incidents within established SLA timelines.

Microsoft, India WISE(Women in Software Engineering) Sep 2018 - Sep 2019

Developed Kitchen Pal, a smart grocery optimization application using Python and SQL, integrating data ingestion, database processing, recommendation logic, and backend functionality to improve grocery planning and product selection.

Built Python-based web scraping pipelines using BeautifulSoup to collect product pricing, availability, and ratings data, transforming and storing the information for downstream analysis and application processing.

Designed and queried SQL databases for product, user, and consumption data, developing optimized queries and aggregations to support recommendation logic, usage analysis, and predictive replenishment functionality.

CERTIFICATIONS

Oracle Cloud Infrastructure 2025 Certified Generative AI Professional

Microsoft Certified Data Analyst Associate

Oracle APEX Cloud Developer Professional

Oracle Cloud Infrastructure 2025 Certified Foundations Associate

PUBLICATIONS

Published a research paper on “Breast Cancer Prediction using Supervised Machine Learning Techniques” in the International Journal of Innovative Technology and Exploring Engineering (IJITEE), a Scopus-indexed journal.

EDUCATION

Sreenidhi Institute of Science and Technology, Hyderabad 2016 - 2020

Bachelor of Technology, Information Technology

Contact this candidate