Pavan Kumar Gotety

Client GE Corporate, Healthcare and Aerospace

• Operational Lead managing a team of 20 DBAs, providing mentorship and guidance on best practices and emerging technologies
• Managed Oracle databases, maintaining high levels of performance, availability, and security.
• Managing and supporting 500 databases both on-premise and Cloud RDS instances.(24/7 support)
• Implemented oracle basic compression on large scale data warehouses, resulting in a 30% reduction in storage costs and 20% improvement in query performance
• Led the migration of 200 + Oracle databases to AWS RDS, resulting in a 30% reduction in operational costs
• Implemented Oracle Data Guard for disaster recovery, achieving a Recovery Time Objective (RTO) of 15 minutes
• Designed and implemented a comprehensive database security strategy, including data encryption and access controls, ensuring compliance with GDPR and PCI-DSS standards
• 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 and reducing manual intervention by 50% and have led patch management efforts,reducing vulnerabilities and ensuring compliance with security standards
• Upgrade of 100 + Oracle databases from 12c to 19c, including the implementation of multitenant architecture on Onprem and RDS
• Implemented Oracle GoldenGate for real-time data replication between on-premises and cloud environments, ensuring data consistency across platforms
• 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 three node RAC on Exadata, 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
• Enabled Unified auditing across oracle databases,enhancing security and compliance
• Oversaw the installation, configuration,database Migration upgrade of Oracle database software across multiple environments
• 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
• Designed and implemented Oracle RAC for high availability, improving system uptime and minimizing downtime during maintenance activities
• Designing and deploying a multitude application utilizing almost all of the AWS stack (Including EC2, S3, RDS, IAM) focusing on high-availability, fault tolerance
• Client GE Corporate, Healthcare and Aerospace

Peoplesoft USA inc develops Core peopletools, applications, modules and provides support to Global customers around the world

• Managed a fleet of 100+ Oracle databases across development, test, and production environments
• Implemented Oracle Data Pump for efficient data migration, reducing transfer times by 40% during large-scale data movements
• Designed and implemented a database patching strategy, ensuring all systems remained up-to-date and secure
• Utilized Oracle SQL Tuning Advisor to optimize poorly performing queries, resulting in a 50% reduction in CPU utilization for key business processes
• Implemented Oracle Flashback Technology, reducing recovery time for accidental data loss incidents by 70%
• Assisted in capacity planning and resource allocation to ensure optimal database performance
• Documented database configurations, procedures, and troubleshooting steps
• Peoplesoft USA inc develops Core peopletools, applications, modules and provides support to Global customers around the world
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.

Client Corio Inc, San Carlos Provides worldwide customer Support for Peoplesoft applications through Siebel application

• Managed Oracle databases for a rapidly growing e-commerce platform, ensuring 99.9% uptime, including installation, configuration, and patching
• 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 and optimizing query performance
• 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