Naga Hema Makina

- Administered 60+ SQL Server databases in 24x7 rotational shift model across AMEAA & APAC regions - Configured and managed AlwaysOn Availability Groups & Transactional Replication for mission-critical DBs, achieving 99.9% uptime with RTO of 15 mins - Reduced P1/P2 deadlock and blocking incidents by 60% by analyzing execution plans, creating optimal indexes, and tuning T-SQL queries - Automated database health checks, disk space, and backup monitoring using T-SQL & SQL Agent jobs, eliminating manual effort by 1hr/day - Led backup, restore, and disaster recovery drills; ensured 100% recoverability for 50+ DBs in line with RPO/RTO requirements - Performed root cause analysis for recurring production issues and implemented permanent fixes, reducing overall ticket volume by 30% - Managed database security, user access, and compliance audits; implemented least-privilege access for all production environments - Coordinated patching, version upgrades, and database deployments with zero-downtime strategies for critical applications- Administered 60+ SQL Server databases in 24x7 rotational shift model across AMEAA & APAC regions - Configured and managed AlwaysOn Availability Groups & Transactional Replication for mission-critical DBs, achieving 99.9% uptime with RTO of 15 mins - Reduced P1/P2 deadlock and blocking incidents by 60% by analyzing execution plans, creating optimal indexes, and tuning T-SQL queries - Automated database health checks, disk space, and backup monitoring using T-SQL & SQL Agent jobs, eliminating manual effort by 1hr/day - Led backup, restore, and disaster recovery drills; ensured 100% recoverability for 50+ DBs in line with RPO/RTO requirements - Performed root cause analysis for recurring production issues and implemented permanent fixes, reducing overall ticket volume by 30% - Managed database security, user access, and compliance audits; implemented least-privilege access for all production environments

MySQL DB Administration — Installation, Configuration & Maintenance • Administered 60+ MySQL databases across production and non-production Linux/Unix environments — maintaining 99.9% uptime for PepsiCo enterprise applications through proactive configuration, upgrades, and patch management. • Executed 10+ MySQL version upgrades and quarterly patching cycles with zero unplanned downtime by building pre-tested runbooks and post-deployment validation checklists. • Tuned my.cnf (InnoDB buffer pool, thread settings) — reduced database CPU utilization by 35% on peak-traffic workloads without any hardware changes. High Availability · MySQL Replication · Clustering · Failover · Disaster Recovery • Implemented MySQL Master-Slave and Group Replication with automatic failover — cut Mean Time to Recovery (MTTR) from 45 minutes to under 10 minutes, sustaining 99.9% availability across all environments. • Validated RTO under 15 minutes and RPO under 30 seconds through quarterly DR drills — AlwaysOn AG, Failover Clustering, and Log Shipping maintained with zero gaps. • Achieved 100% backup success rate across 60+ databases over 24 months using mysqldump and Percona XtraBackup — confirmed full recoverability through monthly restore validation. Database Tuning · Query Optimization · Indexing • Reduced query response time by 40% on 15+ high-traffic schemas — eliminated full-table scans through EXPLAIN plan analysis, index redesign, and slow-query log review. • Prevented 15+ potential P1 outages using MySQL Enterprise Monitor, Prometheus, and Nagios — resolved blocking chains, deadlocks, and replication lag before any business impact. • Partnered with developers on 10+ pre-deployment schema reviews — eliminated 30+ performance regressions from reaching production through query and index analysis.

• Delivered 99.9% production availability for PepsiCo’s on-premise MySQL environments across multiple regions — supporting Tier-1 business applications around the clock. • Resolved 100% of PepsiCo P1/P2 incidents within SLA — documented RCA for every critical issue, reducing repeat incidents by 60%. • Identified and resolved 15+ critical risks through weekly health checks and capacity monitoring — prevented all from escalating to production outages. • Supported 10+ release cycles and database migrations with zero data loss — coordinated cross-team patching and post-deployment validation with infrastructure and application teams.