Pavan Sunkara

Senior-level professional with proven track record in managing complex projects and leading cross-functional teams. Known for results-driven approach and commitment to excellence in all endeavors. Highly adaptable, collaborative, and focused on achieving organizational objectives through effective team coordination and strategic planning.

• Installed configured Multi Node RAC and Non RAC database’s for enterprise environments and Provided 24X7 support to Mission critical Enterprise databases on Exadata X2-2 , Sun M5000, M4000, E2900, HP 9000, IBM POWER5+ Servers Implemented Database on Exadata X2-2 by using Siebel Application Best Practices and Migrated Siebel 3T database from six node cluster (RAC) to Exadata half rack and Quarter Rack environment. Responsible for providing Technical direction, planning, design, build, operate Tier 0, Tier 1 database infrastructure on Oracle 12c/11g Version. Implemented Oracle Data Guard (12c/11g) for Disaster Recovery solution and experience in database switchover (converting standby as primary vice versa) converting physical standby as snapshot database and performing DR exercise. Responsible for managing and troubleshoot 11g/12c data guard issues like archive log gaps, missing data file, data guard sync issues. Responsible for Design, develop, and implement replication with the golden gate for database high availability solutions, real-time data integration, and Disaster recovery solution. Hands on experience in setting up unidirectional replication between datacenter and consolidation replication (many to one) between databases. Expert in install, configure, golden gate IR replication, hands on experience in golden gate process and troubleshooting golden gate abend, lag issues. Expertise in 10g/12c Grid Control. Installed ,configured, maintained OEM 10g/12x Grid Control Management Server and Agent with 10g/12c Repositories to manage 600+ targets( Database include primary and stand-by databases , Grid Control Agents, Server , 9i/10g application server components on more then 100+ server ) Developed comprehensive backup and recovery policy, designed, tested, implemented backups on Oracle ZFS storage. Minimized backup time up to 80%. Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN, Shadow Image, Data pump (expdp, impdp) Export/Import. Clone/refresh database by using rman backup set, active database clone features. Schema refresh by using expdp / impdp. Monitor and manage Oracle database Security by implementing security Policies as per guidelines and ensure that database are met with compliances. Extensive experience with Oracle Database Migration, upgrade, Patching of RAC and Non RAC environment. Expertise in Environment using Veritas HA Cluster and Cluster automatic failover configurations. Perform fire drill tests every 3 months and make sure VCS configuration is properly defined. Troubleshoot Database Performance issues using sqlt, extract report, 10046 and 10053 Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Fixing execution plan for queries by using sql profile.. Hands on experience is reading analyzing oswatcher data, generating dash board and analyze server health in terms with CPU/IO/Memory. Design, Developed & Sizing of Couchbase cluster based on Application requirements, which includes working dataset, no: of replica’s and total dataset’s sufficing application response time. Responsible for installing, configuring, and administering multi node Couchbase cluster activities, which includes adding/removing node, resetting memory quota, rebalance the cluster after adding/removing node from the cluster. Performed multiple Couchbase upgrades from versions 3.x to 4.5.1, 5.1, 6.5 in a rolling fashion with ZERO downtime. Hand-on experience on offline Couchbase upgrades when allowed. Responsible for working with various vendors (oracle, Couchbase) and various internal team to handle planned/ unplanned database events Responsible to Installation and configuration of PostgreSQL and define standard guidelines to deploy PostgreSQL on visa Infrastructure. Performed couple of Oracle to PostgreSQL migration by using Ora2pg and golden gate and worked with PostgreSQL Development team to handle code change during the Migration. Review the PostgreSQL bloat report and come up with a plan to perform Auto Vacuum jobs to those objects that are heavily bloated. Responsible to Design, Develop, Maintain PostgreSQL Single Node cluster and Multi-node cluster with Various other components such as repmgr, logical replication, pgbouncer. Designed and Developed PostgreSQL HA system with physical replication with 2 min outage which Includes auto failover in case of Primary loss. Responsible to providing database design for Tier-0, Tier-0.5, Tier-1, Tier-2, Tier-3 which had RTO 10 Min to 24 Hours. Responsible for Designing Tier-RT and Tier-NRT which requires Less then 2min RTO by using PostgreSQL Logical replication HA-proxy components. Responsible to create backup and recovery procedure of PostgreSQL database by using pgbase backup and barman. Hands on experience of Handing Critical PostgreSQL database issues, Physical replication Issues, Logical replication issues and coordinating Various teams during planned, Unplanned events. Created several shell scripts for PostgreSQL monitoring, Implemented Grafana for PostgreSQL Monitoring

Key Milestones as a lead database administrator

1. Successful Project Completion: Leading the team to deliver the project on time , meeting all specified requirements and quality standards.

2. Efficient Resource Management: Optimally allocating resources and managing the team's workload to maximize productivity and efficiency.

3. Problem Solving and Innovation: Identifying and resolving critical issue or road blocks that arise during project, and implementing innovative solutions to improve project outcome.

4. Risk Management: Proactively identify potential risks and implementing strategies to militate them, there by minimizing negative impact on project.

5. Onboarded Couchbase to a critical project where response time is less than 2.5 milli seconds.

6. Onboarded PostgreSQL to organization to reduce oracle foot print there by saving cost to organization.

7. Architected and developed a robust PostgreSQL database solution tailored to meet the specific need of the project.

8. Achieved zero downtime during the deployment and subsequent operations, ensuring uninterrupted service availability

9. Designed and implemented a disaster recovery plan that ensure a recovery time under 2 minutes and minimize data loss and downtime in the event of failure

10. Designed and Developed various bash scripts to monitor PostgreSQL, Couchbase health , Auto failover , Switchover scripts.