Senior Oracle PL/SQL Cloud Data Engineer

AJAY APPAM

Senior Oracle PL/SQL Developer Cloud Data Engineering Specialist

+1-726-***-**** ***********@*****.***

PROFESSIONAL SUMMARY

Senior Oracle PL/SQL Developer with 8 years of hands-on experience designing, developing, optimizing, and supporting high-performance database solutions, ETL pipelines, and cloud-integrated data systems. Deep expertise in PL/SQL packages, procedures, functions, triggers, advanced SQL, performance tuning, large-scale data processing, and production support. Hands-on experience with Oracle Autonomous Data Warehouse (ADW) on Azure and Amazon Redshift, including cloud data warehousing, query optimization, workload management, S3 data ingestion, and IAM security configuration. Experienced with SAP BODS, Informatica PowerCenter, SQL*Loader, SSIS, UNIX/Linux shell scripting, Git, Jenkins, Control-M, AutoSys, Agile/Scrum, CI/CD, data migration, data reconciliation, and L2/L3 production support.

CORE COMPETENCIES

Oracle PL/SQL: Packages, Procedures, Functions, Triggers, Dynamic SQL, Cursors, Ref Cursors, Collections, Bulk Collect, FORALL, Exception Handling

SQL & Performance: Advanced SQL, Explain Plan, AWR, ASH, SQL Trace, TKPROF, AUTOTRACE, Optimizer Hints, Cost-Based Optimizer, Indexing, Partitioning

Databases: Oracle 10g/11g/12c/19c, PostgreSQL/PLpgSQL, MS SQL Server, DB2, Teradata

Cloud & Data Warehousing: Oracle ADW on Azure, Azure networking/security integration, Amazon Redshift, AWS S3, IAM, cloud data pipelines, Star/Snowflake schemas, ODS, Data Marts

ETL & Data Integration: SAP BODS, Informatica PowerCenter, SQL*Loader, SSIS, ETL design, incremental/full loads, CDC, data migration, reconciliation, data integrity

Automation & DevOps: UNIX/Linux Shell Scripting, Git, Jenkins, SVN, CI/CD, automated deployments, Control-M, AutoSys

Data Modeling & Delivery: ER Modeling, Normalization, Erwin, Agile/Scrum, SDLC, peer code reviews, technical documentation, release management, RCA/L2/L3 support

TECHNICAL SKILLS

Cloud Platforms: Oracle Autonomous Data Warehouse (ADW) on Azure, Amazon Redshift, AWS S3, AWS IAM, Azure SQL

Tools: SQL Developer, TOAD, SQL*Plus, SQL Navigator, Crystal Reports, VS Code, GitHub Copilot

Operating Systems: UNIX/Linux, Solaris, AIX, HP-UX, Windows

Data Engineering: ETL, data pipelines, data warehousing, ODS, data migration, reporting, batch processing

Scheduling: Control-M, AutoSys

PROFESSIONAL EXPERIENCE

Carelon Health Care – Richmond, VA Sep 2025 – Present

Sr. Oracle PL/SQL Developer / ETL Developer

• Design, enhance, and optimize Oracle PL/SQL packages, procedures, functions, and complex SQL queries with focus on performance tuning, indexing strategies, and execution time reduction.

• Develop scalable, reusable, and maintainable PL/SQL components with robust exception handling, logging, and error tracking for large-scale healthcare data systems.

• Optimize high-volume healthcare reporting queries to improve scalability, efficiency, and data retrieval performance.

• Engineer and maintain SAP BODS ETL workflows, optimizing data flows, transformation logic, restartability, and error-handling mechanisms.

• Execute and validate incremental and full data loads while enforcing data integrity, reconciliation accuracy, and business-rule compliance across data pipelines.

• Tune SQL and PL/SQL using EXPLAIN PLAN, SQL Trace, TKPROF, indexing strategies, and optimizer hints across ETL and reporting workloads.

• Support cloud-aware database deployments and collaborate on schema design, indexing strategies, data modeling, and distributed data environments.

• Provide L2/L3 production support, root cause analysis (RCA), performance bottleneck diagnosis, failed-load resolution, and impacted ETL job reruns.

• Automate ETL execution, monitoring, and batch processing using UNIX shell scripts; maintain Control-M and AutoSys scheduling workflows.

• Ensure data governance, compliance, quality, and security standards across claims, provider, member, and reporting datasets.

• Manage Dev, SIT, UAT, and Production deployments with validation scripts, rollback strategies, and post-deployment verification.

• Participate in Agile sprints, peer code reviews, technical design discussions, release management, and ETL operational documentation.

Environment: Oracle 19c, PL/SQL, SQL, SAP BODS, ETL, Data Warehousing, ODS, SQL Developer, TOAD, UNIX/Linux, Shell Scripting, Explain Plan, TKPROF, Git, Jenkins, Agile/Scrum, Healthcare Data, Production Support

IQVIA – Durham, NC Dec 2024 – Sep 2025

Sr. Oracle PL/SQL Developer

• Designed and developed scalable Oracle PL/SQL packages, procedures, and functions supporting high-volume data processing and complex business logic.

• Built end-to-end ETL pipelines using PL/SQL, SQL*Loader, and UNIX shell scripting to ingest and transform large datasets from multiple sources.

• Optimized SQL and PL/SQL with EXPLAIN PLAN, SQL Trace, TKPROF, AUTOTRACE, Bulk Collect, FORALL, partitioning, and optimizer hints.

• Developed testable, observable PL/SQL components with comprehensive exception handling and error tracking.

• Developed materialized views, partitioned tables, and advanced indexing strategies to improve query performance and scalability.

• Collaborated with architects and DBAs on data modeling, schema design, indexing strategies, data consistency, and integrity.

• Provided L2/L3 production support, troubleshooting performance bottlenecks and resolving critical issues with minimal downtime.

• Contributed to CI/CD pipelines, automated deployments, Git/Jenkins version control, Agile ceremonies, and code reviews.

• Developed PostgreSQL PL/pgSQL functions and triggers for cross-platform data processing and reporting.

Environment: Oracle 19c, PL/SQL, SQL, SQL Developer, TOAD, SQL*Loader, Shell Scripting, Data Pipelines, ETL, Explain Plan, TKPROF, Git, Jenkins, VS Code, GitHub Copilot, Linux

BCBS – Richardson, TX Dec 2023 – Oct 2024

Oracle PL/SQL Developer

• Developed advanced PL/SQL packages, procedures, triggers, functions, indexes, and collections for complex business logic and data manipulation workflows.

• Optimized SQL using execution plans, partitioning, indexing, and optimizer hints; redesigned tables with partition indexes to improve database performance.

• Built ETL processes for claims data transformation and reporting pipelines using SQL*Loader and SSIS for flat-file and XML data sources.

• Implemented UNIX shell scripts to automate database operations, batch jobs, and data-loading processes.

• Processed healthcare claims, provider, and member data while supporting data accuracy and compliance requirements.

• Participated in change management, code reviews, performance tuning, production fixes, and multi-environment deployments.

Environment: Oracle 11g/12c, PL/SQL, SQL*Loader, Oracle Streams, SQL*Plus, SQL Server SSIS, TOAD, XML, HP-UNIX Shell Scripting

S.P Soft Pvt. Ltd – Hyderabad, India Jun 2019 – Dec 2022

Oracle Developer / Analyst

• Wrote complex PL/SQL stored procedures, functions, packages, and conversion scripts to migrate and transform data across Oracle and SQL Server databases.

• Performed database administration of tables, clusters, indexes, views, sequences, packages, and procedures; implemented backup and recovery strategies.

• Improved application performance by rewriting and fine-tuning SQL queries; used SQL*Loader and DTS packages for ETL and data migration workflows.

• Designed logical and physical database layouts and supported Oracle upgrades from 9i to 11g across multiple environments.

• Developed UNIX shell scripts for data loading, DDL operations, and automated database processes.

• Provided production support, user training, and bug fixes across development, QA, and production environments.

• Supported database operations, data loading, and production troubleshooting in an Oracle Exadata environment.

• Performed SQL and PL/SQL performance tuning for Exadata workloads using execution plans, indexing, partitioning, and query optimization techniques.

• Worked with Oracle Exadata in a previous project environment supporting high-volume Oracle database workloads and performance-sensitive processing.

Environment: Oracle 10g/11g/12c, SQL, PL/SQL, SQL*Loader, SQL Navigator, Crystal Reports, TOAD, Oracle Exadata

HDFC Bank – Hyderabad, India Jun 2017 – May 2019

Oracle Developer

• Participated in full SDLC activities including planning, analysis, design, development, testing, and implementation for banking database applications.

• Designed logical and physical data models for star and snowflake schemas using Erwin; developed triggers, packages, functions, and stored procedures for data conversions.

• Fine-tuned procedures and SQL queries using Oracle hints and optimization techniques to improve database efficiency.

• Developed PL/SQL programs using cursors, exception handling, and collections; worked with XML and PL/SQL to develop and modify web forms.

• Created indexes on critical tables to eliminate full table scans and built custom reports and forms for end-user data analysis.

Environment: Oracle 10g/11g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, TOAD, Windows

CLOUD & DATA WAREHOUSING EXPERTISE

• Oracle Autonomous Data Warehouse (ADW) on Azure: architecture, performance tuning, workload management, networking/security integration, and data pipelines.

• Amazon Redshift: storage strategies, query optimization, workload management, S3 data ingestion, and IAM security configuration.

• Experience migrating on-premises database workloads to cloud environments and optimizing for cloud performance, scalability, and cost efficiency.

• Integration of PL/SQL-based systems with cloud services, APIs, and data pipelines across AWS and Azure platforms.

• Exposure to cloud-based ETL pipelines and data engineering workflows in distributed cloud architectures.

EDUCATION

Bachelor of Science – Computer Science 2015

Master's Degree — Webster University San Antonio, TX 2024

ADDITIONAL HIGHLIGHTS

• Strong analytical and problem-solving skills with experience working independently in complex database environments.

• Experienced partnering with business analysts, application teams, DBAs, architects, and cloud teams on technical design and delivery.

• Detail-oriented focus on performance, quality, data governance, and security compliance.

• Familiar with AWR, ASH, SQL Trace for proactive database monitoring and stability improvement.

• Experienced with Git-based version control, peer code reviews, CI/CD practices, Agile/Scrum, and technical documentation.

Contact this candidate