Sreedhar Puppali
Aldie,VA
Summary
Results-driven Lead SRE Database Engineer specializing in database performance tuning and disaster recovery. Led cloud infrastructure migrations, enhancing system reliability and efficiency. Skilled in automated deployment scripting and data migration strategies, contributing to organizational success.
Overview
27
27
years of professional experience
Work History
Lead (SRE) Database Engineer
Oracle America, INC
03.2013 - Current
- Managing and leading all DB Scaling and Performance issues.
- Deploy Oracle Exadata engineered system clusters (EXACS) on Oracle cloud Infrastructure.
- Currently setting and Testing Databases for Oracle Autonomous Database (ADB).
- Working in Site Reliability Management, leading a team to support the Environment for OCI Oracle SaaS Customers.
- Certify and Validate Database Releases for Public and Private clouds.
- Monitor Oracle databases using various tools including Oracle Enterprise Manager 13c, ODIN dashboards.
- Configure and manage backups for Oracle databases using Oracle RMAN and Oracle recovery appliance.
- Upgrade EXACS databases from 12c to 18c, 18c to 19c.
- Automated kafka installation on OCI with Ansible and terraform, streamlining deployment processes.
- Automate data loads from excel sheets to oracle tables using python(pandas) and shell scripts.
- Migrated Oracle’s mission-critical GSI database from on-prem to OCI using transportable tablespace method, enhancing system reliability.
- Migrated VCP(Value chain planning), CZD databases from on-prem to OCI using dataguard.
- Built, supported goldengate in single instance, micro services fashion for GSI-GCW environments.
- Supported SAAS business continuity planning and maintained disaster recovery sites.
Database Advisor
KANA Software
01.2012 - 03.2013
- Database Architect and Performance consultant for all KANA CRM Products.
- Design, Develop and Certify All types of Databases for the KANA product.
- Install Oracle database 11gR2, 12c and 19c binaries on Linux, AIX and Exadata.
- Monitor Oracle databases using various tools including Oracle Enterprise manager 13c.
- Created and administered Oracle physical standby databases using Oracle Data Guard 11g and 12c for effective disaster recovery.
- Apply quarterly patches to Oracle 11 g, 12c databases on Exadata, Linux and AIX systems.
- Configure and manage backups for Oracle databases using Oracle RMAN and Oracle ZDLRA recovery appliance.
Database Admin Advisor
VISA
09.2011 - 02.2012
- Setup HA, DR, Listener and Performance Tools.
- Develop Backup Strategy for One of the Complex Database.
- Fine-tune Listener, scale Listener issues in VISA systems.
- Deploy Oracle Exadata engineered systems X6, X7 at Anthem data centers.
- Build and drive private cloud on Oracle Exadata using Oracle OEM.
- Build various services that can be offered using OEM for DBAAS using in house Exadata machines.
- Support a 500 TB database on day-to-day basis for various performance issues.
- Apply QFSDP for Exadata machines and ZDLRA appliances on Quarterly basis.
- Use Oracle ITA and identify possible problem scenarios and work proactively on performance tuning scenarios.
- Final point of escalation for technical issues for Anthem corporate database related issues.
- Drive the team for compliance related to patching and upgrades.
- Mentor the team with new Oracle technologies and arrange POC, training environments.
- Onboard new DBA team members with technical and non-technical onboarding processes.
- Support Exadata engineered systems in OVM configuration and take care of Dom0/U.
- Addressed performance challenges in production databases.
- Work with Oracle for various ASRs generated by platinum gateway for various hardware issues (Grid disk, flash card) related to Exadata, ZDLRA.
- Configure and manage backup and recovery procedures for Oracle databases using ZDLRA recovery appliances.
- Participate in key decision making meetings including bringing in new Oracle database projects, Oracle database upgrades, resource planning etc for Oracle Exadata machines.
- Ensured adherence to regulations
Sr Oracle DBA
VMWare
09.2010 - 01.2011
- Install Oracle 10g, 11g, 12c database binaries on Linux, Aix systems in a SOX compliant environment.
- Work on oracle engineered systems Exadata X6-2/X5-2, ODA X5/X6 in a DMA role.
- Design database, schema, object architectures for the application teams.
- Design upgrade, migration plans based on the size of the databases.
- Install, configure POSTGRES 8, 9 database software on Linux machines.
- Coordinated deployment of Exadata and ODA machines at NDH with Oracle ACS teams, ensuring timely implementation.
- Performed bare metal installations and created documentation for ODA X5-2 and X6-2.
- Apply QFSDP patches for engineered systems X4-2, X5-2 and X6-2.
- Worked with Oracle for various ASRs(Automatic service requests) generated by platinum gateway for various hardware issues(Grid disk, flash) related to Exadata.
- Managed daily operations for 85 TB database, addressing performance issues to maintain optimal functionality.
- Upgraded multiple databases including 65 TB database from 11.2.0.3 to 12.1.0.2.
- Configured and managed physical standby databases for databases including 65 TB VLDB primary database.
- Configured AWR warehouse to maintain a central repository for AWR snapshots.
- Defined standard procedures for yearly switchover testing of databases using dataguard.
- Refresh the Test environments with Production data using RMAN & Data pump.
- Upgrade the Oracle databases from 11g to 12c using DBUA and manual process.
- Migrated the databases from non-cdb model to CDB-PDB model.
- Collaborated with Oracle Support to resolve and track open Service Requests, ensuring prompt issue resolution.
- Worked on 12cR2 Beta testing for oracle databases and suggested several improvements.
Database Administrator
Fujitsu
10.2006 - 01.2010
- Design, implement, architect and maintain complex Oracle Databases running on Oracle customers for all Database Flavours and Releases.
- Installation of 9i, 10g, 11g Oracle RAC on Unix, Linux systems with ASM and file systems.
- Configure Oracle Goldengate replication between Oracle Exadata databases and OLTP databases.
- Configure Physical, Logical standby databases using Oracle Dataguard for disaster recovery. Switch over and failover of databases for disaster recovery verification.
- Migrated Streams replication to GoldenGate replication, implementing negative rules to prevent deletion data transmission to target side.
- Monitor the real time replication of data through Streams and Golden gate to avoid missing SCN errors and restore the archive logs when the errors are generated.
- Migrate the database agents and the backup jobs, Dataguard monitoring jobs from 10g to 11g Oracle grid control without impacting the job schedules.
- Refresh the QA environments with the production data using RMAN Duplicate or Datapump and change the database names manually or using NID.
- Install oracle 11gr2(11.2.0.2) on Amazon cloud hosts running RHEL.
- Performed performance tuning on database instances and SQL queries, enhancing overall database performance.
- Restored databases from backups, identified block corruption, and resolved issues by restoring from previous backups.
- Confer with team members to determine the impact of database changes on applications.
Sr Oracle DBA
GE Industrial
01.1999 - 10.2006
- Install/Configure Oracle 10g, 11g RAC with ASM on Red Hat Enterprise Linux, Unix.
- Install Oracle OEM agent on Linux hosts and configure databases to get them monitored.
- Migrating non ASM Oracle databases to ASM.
- Patch the ASM, RDBMS and Grid Infrastructure homes using OPatch utility.
- Rename the existing Oracle databases manually and using NID.
- Configure table level, schema level Oracle Streams between OLTP databases to Exadata Datawarehousing databases.
- Manage, monitor and configure RMAN Oracle database backups.
- Delete/Add RAC nodes to an existing 10g RAC cluster.
- Cluster a standalone Oracle database using RCONFIG.
- Monitor the databases using Oracle OEM Grid Control.
- Resolved support tickets to ensure timely database issue resolution.
- Part of team to limit the resources allocated to a instance using Oracle Resource manager and Instance Caging.
- Database code reviews and code migrations through RPR system.
- Coordinated with Storage, Network, and Linux teams to ensure prerequisites for Oracle RAC installation were met.
- Coordinated with My Oracle Support on open service requests to expedite solutions.
- Involve in deployment meetings before application new/upgrade Releases.
- Rename Oracle ASM diskgroups using Renamedg.
- Analyzed AWR and ADDM reports to identify and implement performance tuning measures.
- GE Turbine. GE – Medical, GECIS -India -to -Atlanta
Education
Continuous Studies - Leadership, Design, Communications
Stanford University
Master of Science - Computer Science
MK University
Chennai, IndiaSix Sigma Black Belt Certification - Quality
Leadership Trainings
Skills
- Database performance tuning
- Disaster recovery orchestration
- Cloud infrastructure management
- Automated deployment scripting
- Data migration strategies
- Database design architecture
Legal Status
US Citizen with Public Trust Clearance
Timeline
Lead (SRE) Database Engineer
Oracle America, INC
03.2013 - Current
Database Advisor
KANA Software
01.2012 - 03.2013
Database Admin Advisor
VISA
09.2011 - 02.2012
Sr Oracle DBA
VMWare
09.2010 - 01.2011
Database Administrator
Fujitsu
10.2006 - 01.2010
Sr Oracle DBA
GE Industrial
01.1999 - 10.2006
Continuous Studies - Leadership, Design, Communications
Stanford University
Master of Science - Computer Science
MK University