Oracle SQL & PL/SQL Data Engineer

Venkata Vamsi Krishna Divyakolu

Frisco, Texas, United States • ********.*******@*****.*** • +1-603-***-**** SUMMARY

Data Engineer with 4+ years of experience specializing in Oracle SQL and PL/SQL development, database application development, SQL performance tuning, data modeling, and enterprise data integration. Experienced in developing PL/SQL procedures, functions, packages, triggers, views, indexes, and database-driven application workflows, with strong expertise in production troubleshooting and root-cause analysis. Proven experience collaborating with application developers, ETL teams, QA, business analysts, and production support teams across enterprise environments, supporting application releases and production deployments. Strong background in Oracle, SQL, PL/SQL, Informatica, AWS, Snowflake, and Amazon Redshift with a focus on performance, reliability, and data quality. EXPERIENCE

Data Engineer Cigna Healthcare

June 2024 - Present, Bloomfield, CT

• Designed and maintained 5+ production data-processing and database integration workflows using Oracle-compatible SQL, PL/SQL, Python, AWS Glue, Snowflake, and Amazon S3 to support enterprise healthcare applications and analytics.

• Developed complex SQL and PL/SQL logic for data extraction, transformation, validation, reconciliation, and business-rule processing, improving data accuracy by approximately 25%.

• Analyzed database structures, source systems, relationships, dependencies, and business requirements to design scalable data models and reliable database application workflows.

• Performed SQL query optimization and execution-plan analysis to identify inefficient joins, filtering, indexing, and data- access patterns, improving processing performance and reducing execution time.

• Implemented data quality controls, validation procedures, reconciliation logic, and monitoring processes across source and target systems, reducing production defects by approximately 30%.

• Troubleshot production database and application integration issues by analyzing SQL results, processing failures, logs, and data inconsistencies, performing root-cause analysis and implementing corrective solutions.

• Collaborated with developers, QA engineers, business analysts, ETL teams, compliance teams, and production support stakeholders to validate database changes and coordinate application releases.

• Created database documentation, deployment procedures, validation guides, operational runbooks, and release support documentation while maintaining data governance and traceability requirements. Data Engineer Arting Digital

May 2021 - May 2023, India

• Developed and optimized 15+ enterprise ETL and database workflows using Informatica PowerCenter, Oracle, SQL, PL/SQL, and Amazon Redshift for large-scale reporting and business applications.

• Developed PL/SQL procedures, functions, packages, and database transformation logic to implement business rules, data processing, validation, and integration requirements.

• Designed and maintained database objects including tables, views, indexes, and supporting structures for enterprise reporting and analytics workloads.

• Built scalable data-processing workflows handling 10GB+ of historical data while improving reporting accuracy by approximately 25% and maintaining reliable downstream application performance.

• Performed advanced SQL performance tuning using execution-plan analysis, query optimization, indexing strategies, join optimization, and efficient data-access techniques, improving reporting performance by approximately 35%.

• Performed source-data profiling, data modeling, reconciliation, transformation testing, and validation to ensure database outputs met functional and business requirements.

• Investigated production database and application issues using SQL analysis, defect investigation, and root-cause analysis, reducing recurring data-quality and processing issues.

• Collaborated with Java/application developers, QA teams, business analysts, ETL developers, and production support teams during development, testing, code promotion, releases, and post-production support. PROJECT

Oracle Application Integration & Enterprise Data Platform

• Built a database-driven application integration platform using Oracle, PL/SQL, Java, REST APIs, JSON, and SQL to support data exchange between enterprise application components.

• Developed PL/SQL procedures and functions for application-facing data operations, validation, transformation, error handling, and transaction processing.

• Implemented database views, indexes, and optimized queries to support Java/Angular application workflows and improve data-access performance.

• Performed integration testing and troubleshooting across application, database, and ETL layers while documenting deployment and release procedures.

• Technologies: Oracle, PL/SQL, Java, SQL, REST APIs, JSON, Angular, Database Integration, Query Optimization, Integration Testing

Enterprise Oracle Database Application & PL/SQL Processing Framework

• Designed an enterprise-style Oracle database application using advanced SQL and PL/SQL, implementing packages, procedures, functions, triggers, tables, views, indexes, and materialized views to support transactional and reporting workloads.

• Developed reusable PL/SQL packages and procedures for business-rule processing, data validation, exception handling, auditing, and batch data operations.

• Performed SQL performance tuning using execution plans, indexing strategies, query restructuring, and optimized joins, improving complex query execution performance by approximately 30%.

• Designed relational data models and database objects supporting application transactions, reporting, data integrity, and efficient data retrieval.

• Technologies: Oracle 19c, SQL, Advanced PL/SQL, Packages, Procedures, Functions, Triggers, Tables, Views, Indexes, Materialized Views, Data Modeling

EDUCATION

Master of Science in Computer Science and Information system New England College Henniker, NH

Bachelors of Technology Tirumala Engineering College India

SKILLS

Oracle & PL/SQL: Oracle 12c/19c, Advanced PL/SQL, Packages, Procedures, Functions, Triggers, Cursors, Exception Handling, Dynamic SQL, Database Programming

Database Development: Tables, Views, Indexes, Materialized Views, Relational Database Design, Data Modeling, Constraints, Data Integrity, Database Application Development

SQL & Performance: Advanced SQL, Query Optimization, Execution Plan Analysis, Index Optimization, Join Optimization, SQL Performance Tuning, Performance Troubleshooting

Data Integration & ETL: Informatica PowerCenter, ETL/ELT, Data Transformation, Data Validation, Data Reconciliation, Source Profiling, Batch Processing

Enterprise Platforms: Snowflake, Amazon Redshift, AWS Glue, Amazon S3, Oracle, SQL Server Application Integration: Java, Angular, REST APIs, JSON, Application-Database Integration, Enterprise Application Support Development & Version Control: Git, Bitbucket, CI/CD, Code Promotion, Application Releases, Change Management, Deployment Support

Testing & Production Support: Unit Testing, Integration Testing, Regression Testing, Production Troubleshooting, Root Cause Analysis, Defect Resolution, Release Validation, Technical Documentatio

Contact this candidate