Work Overview ? Managing over 2000 servers in AWS and AWSCN (China). ? Controlling change management on 500+ Mongo servers and 200+ MySQL servers. ? AWS Services: EC2 instance management, AMI, Snapshots, Volume management, S3 ? Deployed MySQL instances successfully. ? Configured master-master and master-slave replication for failover and reporting. ? Right sizing of several servers according to the need ? Partitioned our ever-growing database for pruning and archival records. ? Slow query optimization. ? Automation of scripts and logs. ? Implemented Percona toolkit and monitoring tools. ? Scripted mysqldump, zfs snapshots, aws snapshots and Percona Xtrabackup to backup databases in different scenarios. ? Successful Point-in-Time Recovery Using Binary Logs, xtrabackup copies and snapshots. ? Designed a process to prune and archive old data to keep the database efficient and within capacity. S3 Archiving ? Deployed MongoDB using replica sets. ? Implemented Sharding to scale up. ? Designed ETL job for mongo analytics server using AWS snapshots.m