Summary
Overview
Work History
Education
Skills
Certification
Timeline
background-images
Chinna L Vinjarapu

Chinna L Vinjarapu

San Jose,CA

Summary

Results-driven IT professional with over 10 years of experience as a Database Administrator, specializing in Oracle RAC Databases, Oracle ERP Applications, and PostgreSQL. Expertise includes managing Oracle Exadata database machines, performing migrations, conducting health checks, and optimizing resource management. Proficient in overseeing database infrastructure within AWS environments, including RDS and EC2, ensuring high availability and performance. Committed to leveraging technical skills to enhance database operations and drive organizational success.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Lead Engineer

Wipro Technologies
06.2021 - Current
  • Rolling GRID upgrade node at a time from 12c to 19c version with zero downtime.
  • Have very good experience in database Upgrade Oracle EBS (12.2.5) from 12c to 19c.
  • Have involved in 19c database and GRID upgrade team and converting non-CDB to CDB architecture.
  • Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby with zero downtime.
  • Worked on Oracle EBS Upgrade from 11.5.10.2 to R12.2.5 with OS migration (DB, App) from RHEL 5(32 bit) to RHEL 6(64 bit) in Linux.
  • Hands on upgrade experience on R12.1.3 to 12.2.5.
  • MySQL database migration using the AWS Database migration service (DMS) from S3 bucket to RDS MySQL database.
  • Design EC2 instance architecture to meet high availability application architecture and security.
  • Involved in database troubleshooting and maintenance activities and solve some Golden Gate issues such like abended, lagging, long transaction issues.
  • Resolved the issues in conflicts between the target and source database in Golden Gate.
  • Involved in designing and deploying multitude applications utilizing almost all of the AWS stack (Including EC2, S3, RDS, DMS) focusing on high-availability, fault tolerance.
  • Migrating PostgreSQL database on premises to AWS RDS service PostgreSQL/Aurora.
  • Continuous Deployment with AWS Code Pipeline for Static Websites and Front-End Apps hosted in S3 and maintaining the code versioning using the GIT.
  • Good experience in Oracle Advanced transparent data encryption (TDE) enablement with Master key auto login.
  • Good experience in maintain the TDE master key externally using oracle HSM.
  • Analyze data gathered from performance test runs, identify bottlenecks of applications, and provide solution like Sql tunning, index creation, hint, and rules implementation.
  • Design, implement and schedule Oracle databases maintenance tasks using Core Java and Python.

Associate Consultant

Tata Consultancy Services
04.2014 - 06.2021
  • Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby with zero downtime.
  • Have involved in 19c database and GRID upgrade team and converting non-CDB to CDB architecture.
  • MySQL database migration using the AWS Database migration service (DMS) from S3 bucket to RDS MySQL database.
  • Involved in database troubleshooting and maintenance activities and solve some Golden Gate issues such like abended, lagging, long transaction issues.
  • Resolved the issues in conflicts between the target and source database in Golden Gate.
  • Involved in designing and deploying multitude applications utilizing almost all of the AWS stack (Including EC2, S3, RDS, DMS) focusing on high-availability, fault tolerance.
  • Migrating PostgreSQL database on premises to AWS RDS service PostgreSQL/Aurora.
  • Continuous Deployment with AWS Code Pipeline for Static Websites and Front-End Apps hosted in S3 and maintaining the code versioning using the GIT.
  • Good experience in Oracle Advanced transparent data encryption (TDE) enablement with Master key auto login.
  • Good experience in maintain the TDE master key externally using oracle HSM.
  • Rolling GRID upgrade node at a time from 12c to 19c version with zero downtime.
  • Have involved in 19c database and GRID upgrade team and converting non-CDB to CDB architecture.
  • Worked on Oracle EBS Upgrade from 11.5.10.2 to R12.2.5 with OS migration (DB, App) from RHEL 5(32 bit) to RHEL 6(64 bit) in Linux.
  • Hands on upgrade experience on R12.1.3 to 12.2.5.
  • Good experience in Oracle Advanced transparent data encryption (TDE) enablement with Master key auto login.
  • Good experience in maintain the TDE master key externally using oracle HSM.
  • Good experience in Backup / Recovery using User Managed / RMAN, export / import (Data Pump) and SQL Loader, OEM, Dataguard etc.
  • Good Knowledge in monitors, alarms, and notifications the AWS resources using the CloudWatch service.
  • Have involved in migrating the on-premises MySQL DB to AWS cloud using the DMS service.
  • Have involved in migrating the on premises VM to AWS cloud using the VM import.
  • Design, implement and schedule Oracle databases maintenance tasks using Core Java and Python.

Associate Consultant

TechMahindra
01.2012 - 01.2014
  • Administering production databases as large as 9TB on a 3 node RAC installation (SunSPARC machines), with 6 node PCP configuration exclusively for Concurrent Processing, Load balancing form services and apache through F5 setup on 3 web servers.
  • Administering and maintaining Production Apps 11i instances, 24X7 Production Database Support and maintenance.
  • New environment creation, configuration, and maintenance.
  • Cloning of Oracle Apps Databases/Environments.
  • Troubleshooting all Oracle Apps Issues like Apache, Forms, CCM and Workflow.
  • Applied application patches and merged patches manually.
  • Working on different issues in co-ordination with different teams.
  • Resolved configuration issues raised by development teams.
  • Administration by using AD Utilities.
  • Implemented shared appltop.
  • Application of Quarterly release of Oracle Critical Patch Updates to Oracle Application Databases.

Education

Master of Science - Computer Science

JNTU
Hyderabad India

Skills

  • Operating Systems: Red Hat Enterprise Linux (RHEL), Solaris, Microsoft Windows
  • Databases: Oracle 12c, Oracle 19c, PostgreSQL, Oracle Exadata,MySql
  • Enterprise Applications: Oracle E-Business Suite R12 / R122
  • Middleware: Oracle WebLogic Server
  • Cloud Platforms: Amazon Web Services (AWS), Oracle Cloud Infrastructure (OCI)
  • Data Replication & Integration: Oracle GoldenGate, Dell SharePlex

Certification

  • AWS Certified Solutions Architect - Associate
  • OCI Architect 2021 Associate [1Z0-1072-21]
  • Oracle Cloud Database Migration and Integration 2021 Specialist (1Z0-1094-21)
  • Oracle Database 11g Administrator

Timeline

Lead Engineer

Wipro Technologies
06.2021 - Current

Associate Consultant

Tata Consultancy Services
04.2014 - 06.2021

Associate Consultant

TechMahindra
01.2012 - 01.2014

Master of Science - Computer Science

JNTU

Similar Profiles

CREATE PROFILE
Chinna L Vinjarapu