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.