devopsgrind

Over a decade of individual experience in DBA includes SLQ, MYSQL, Mongodb, AWS EC2, S3 and development using PHP, Magento, Wordpress , Dotnet (sample work available on request) Managing over 2000 servers in AWS & AWSCN (China). Controlling change management on 500+ Mongo servers & 200+ MySQL servers. AWS Services: EC2 instance management, AMI, Snapshots, Volume management, S3 Deployed MySQL instances successfully. Automation of scripts, logs. Implemented Percona toolkit and monitoring tools. Scripted mysqldump, zfs snapshots, aws snapshots & Percona Xtrabackup to backup databases in different scenarios. Designed a process to prune & archive old data to keep the database efficient & within capacity. S3 Archiving Deployed MongoDB using replica sets. Implemented Sharding to scale up. Designed ETL job for mongo analytics server using AWS snapshots. Deployed PostgreSQL 9.2 for analytics & planned successful upgrade to 9.4 Ansible automation & implementation for different release projects.