Summary
Overview
Work History
Education
Skills
Websites
Certification
Additional Information - Green Card Holder
Timeline
Generic

Pavan Kumar Gotety

Senior Oracle & Cloud DBA
Guilderland,NY

Summary

Results-driven IT professional with overall 22 plus years of extensive experience as a Senior Oracle DBA/Team Lead, specializing in both on-premise and cloud database management. Demonstrated expertise in handling over 1500 databases for GE company and managing database sizes exceeding 45 terabytes, with a strong focus on Oracle Database administration & tuning. Proficient in cloud migrations, upgrades, and automation projects that drive cost savings and operational efficiency. Skilled in a diverse range of database technologies, including MySQL, MSSQL, and PostgreSQL, with a proven track record in RAC Administration on Exadata and AWS Cloud. Adept at implementing robust backup and recovery solutions, ensuring database security, and performing performance monitoring and tuning to optimize system reliability. Experienced in designing and implementing high availability solutions. Recognized for delivering innovative database solutions and fostering collaborative relationships across teams to drive successful project outcomes.

Overview

22
22
years of professional experience
5
5
Certifications

Work History

Senior Principal consultant

Genpact
04.2005 - Current
  • Company Overview: Presently in USA. Client GE Corporate, Healthcare and Aerospace.
  • Managing and supporting more than 1500 databases for GE which comprises of Oracle, MSSQL, MySQL and PostgreSQL both on-premise on RAC, Exadata and standalone and Cloud RDS instances. (24/7 support).
  • Operational Technical lead SME managing a team of 30 DBAs, providing mentorship and guidance on best practices and emerging technologies. Responsible for gathering business requirements from these clients and come up with technical designs and solution.
  • Led the successful migration of 300 + Oracle databases for GE corporate from OnPrem to AWS RDS /EC2 using datapump, DMS, RMAN tools resulting in a 30% reduction in operational costs.
  • Migration of 150 On Prem Oracle databases to Azure VM as part of GE aerospace/Vernova split business.
  • Implemented & configured more than 100 plus Oracle Data Guard environments for disaster recovery for GE business achieving a Recovery Time Objective (RTO) of 15 minutes on RAC and Azure servers and performed switchovers and failovers for planned maintenance and disaster testing drills.
  • Implemented oracle basic compression on large scale data warehouses, resulting in 1TB storage cost savings and 40% improvement in query performance.
  • Collaborated with development teams to optimize database performance & queries using Automatic Workload Repository (AWR), ADDM, ASH, SQLT and SQL Tuning Advisor, improving query response times by 40%.
  • Developed automation scripts using shell and Ansible streamlining routine database tasks for oracle and reducing manual intervention by 50% and have led patch management efforts, reduced vulnerabilities and ensuring compliance with security standards.
  • As part of obsolescence project upgraded 300 + Oracle databases from 12c to 19c, including the implementation of multitenant architecture on OnPrem and RDS.
  • Conversion of non-partition to partitioned for huge tables of 6Tb using Oracle Goldengate for GE corporate business.
  • Developed automated backup and recovery procedures using RMAN, reducing backup windows by 50% and ensuring 99.99% data recoverability.
  • Designed and implemented a proactive database monitoring system using Oracle Enterprise Manager, reducing unplanned downtime by 75%.
  • Led the implementation of Oracle Two/Three node RAC on Exadata and configured the backups on ZDLRA for GE Healthcare improving overall system performance by 60% and providing high availability for critical applications.
  • Implementing strict access controls, auditing, password complexities and implementing all security recommendations as per GE and Oracle documentation and standards.
  • HVR Replication Implementation, Partitioning, Creation of Instance Strategy, automating patching strategy, Backup Plans and strategies, Interaction with Project teams on Database issues, Resolution of Performance issues on Databases.
  • Managed daily operations and troubleshooting of Oracle, SQL Server, MySQL and PostgreSQL databases, addressing Tier 1 and Tier 2 issues to ensure critical IT systems run smoothly.
  • Administered day-to-day operations like cloning, patching, tickets handling, P0/P1 Incidents and maintenance of Oracle, Mysql, PostgreSQL & MSSQL databases, implementing utility routines to address performance declines and ensuring maximum availability.
  • Conducted regular assessments of database performance, recommending changes and enhancements that aligned with business goals.
  • Designed and implemented Multi-AZ and Read Replica solutions for HA and reporting workloads on RDS.
  • Automated RDS snapshot lifecycle and cross-region backups using AWS Lambda.
  • Designing and deploying a multitude application utilizing almost all of the AWS stack (Including EC2, S3, RDS, IAM) focusing on high-availability, fault tolerance.
  • Assisted DevOps teams in provisioning databases using Terraform and CloudFormation templates.
  • Presently in USA. Client GE Corporate, Healthcare and Aerospace.

Senior Analyst (DBA)

Covansys India ltd pvt
08.2004 - 03.2005
  • Company Overview: Client: Peoplesoft USA Inc. Peoplesoft USA Inc. develops Core people tools, applications, modules and provides support to Global customers around the world.
  • 24/7 prod support for 100+ Oracle databases across development, test, and production environments.
  • Installation and configuration of Peopletool 8.18 and 8.42, PIA.
  • Designed and implemented a database patching strategy which includes Bug fix patches, Interim patches, Enhancements patches, Database patches, Interoperability patches, CPUs and PSUs, etc.
  • Assisted in capacity planning and resource allocation to ensure optimal database performance.
  • Cloning of Oracle Instance from Production to Development, Stage (UAT) and QA environments.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers. Utilized Oracle SQL Tuning Advisor to optimize poorly performing queries, resulting in a 50% reduction in CPU utilization for key business processes.
  • Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
  • Client: Peoplesoft USA Inc. Peoplesoft USA Inc. develops Core people tools, applications, modules and provides support to Global customers around the world.

Consultant Database Administrator

Sierra Atlantic Pvt ltd
02.2003 - 08.2004
  • Company Overview: Client Corio Inc, San Carlos. Provides worldwide customer Support for Peoplesoft applications through Siebel application.
  • 24/7 Day to day operations support of Oracle databases for a rapidly growing e-commerce platform, ensuring 99.9% uptime.
  • Installation of oracle software 10g, 9i, Create database, configure, Monitors and troubleshoot database.
  • Developed and maintained PL/SQL stored procedures and packages, optimizing business logic execution within the database.
  • Conducted regular security audits and implemented least privilege access controls, enhancing overall database security.
  • Implemented Oracle Resource Manager to effectively manage workloads across different user groups, improving overall system performance.
  • Performed routine database monitoring, including checking for errors.
  • Assisted in the implementation of backup and recovery strategies, ensuring data integrity and availability.
  • Client Corio Inc, San Carlos. Provides worldwide customer Support for Peoplesoft applications through Siebel application.

Education

Bachelor of Science - Physics (Electronics)

Mumbai university

Skills

Oracle Database: 11g,12c,19c

Certification

AWS Associate Certified Solutions Architect

Additional Information - Green Card Holder

True

Timeline

Senior Principal consultant

Genpact
04.2005 - Current

Senior Analyst (DBA)

Covansys India ltd pvt
08.2004 - 03.2005

Consultant Database Administrator

Sierra Atlantic Pvt ltd
02.2003 - 08.2004

Bachelor of Science - Physics (Electronics)

Mumbai university
Pavan Kumar GotetySenior Oracle & Cloud DBA