SUMMARY

• 10+ years of experience in IT Operations.
• Master of Science Graduate, Computer Science.
• Extensive experience in planning, implementing and managing different database services.
• Ability to manage thousands of servers in a SAAS model.
• Results - driven IT personnel wif skills in team building and problem-solving.

TECHNICAL SKILLS

• MySQL 4.1-5.6
• Percona Server 5.5
• MongoDB 2.4 -2.6
• PostgreSQL
• AWS
• Ansible 2.0 aws-cli
• Maatkit/Percona Toolkit mtools
• Puppet
• SQL Server 2008
• VMware vSphere 5
• Vmware Fusion
• Cognos 8
• Jsp
• JQuery
• Php
• Red Hat Enterprise Linux 4/5
• Microsoft Visio
• MySQL Admin phpMyAdmin
• SQLite
• SQLyog.

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Senior Database Administrator

Responsibilities:

• Planned successful migration of teh database zone from Equinix data center to AWS.
• Created multi zone architecture for disaster recovery.
• Planned and implemented MySQL 5.6 upgrade throughout teh database zone.
• Planned and implemented MongoDB upgrade to 2.6.8
• Implemented various backup strategies such as ZFS, AWS snapshots and Percona XtraBackup.
• Tuned and supported DRBD replication on MySQL database for our telephony architecture based in Mexico DC.
• Implemented New Relic, Nagios and MongoDB cloud manager and MySQL Enterprise Monitor for production monitoring.
• Ansible automation for deployments, log rotation and backups.
• Designed ETL jobs for mongo analytics server using AWS snapshots.
• Deployed PostgreSQL 9.2 for analytics and planned successful upgrade to 9.4 wif replication for failover.
• Server and query tuning using different tools such as Percona toolkit, mtools, innotop.
• Implemented Hexatier(GreenSQL) for data masking and SQL monitoring on analytics servers.
• Designed SAAS architecture for various retail stores wif multiple databases sharing teh host.
• Capacity planning: collected data to estimate growth and implemented online solution to cope wif.
• Cost control: scripts to purge S3 buckets, snapshots and volumes that are beyond teh retention policy.
• Security: Worked wif cyber security team to create/manage security groups to enforce and tighten access.
• User management: Coordinated wif HR to give controlled access on teh databases and using teh AD groups.
• Planned and implemented quarterly failover and restore drills to verify and improve teh process.

Confidential, San Francisco, CA

Senior Database Administrator

Responsibilities:

• Managed over 2000 servers in AWS and AWSCN (China).
• Controlling change management on 500+ Mongo servers and 200+ MySQL servers.
• Serving in a GAAS (Game as a Service) model to different studios including Moscow, Beijing, San Francisco and Hyderabad.
• AWS Services: EC2 instance management, AMI, Snapshots, Volume management, S3
• Deployed MySQL instances successfully for teh Gserve and GWallet game engine.
• Configured master-master and master-slave replication for failover and reporting.
• Pre and Post launch rightsizing of instances to fit teh need. Deployed both on GP2 and SSD EBS-optimized servers to scale up.
• Partitioned our ever-growing GWallet database for pruning and archival records. Configured raid for data growth.
• Scripting to collect data for capacity management, log rotation, backups and collecting slow query logs.
• Implemented Percona tools to monitor and maintain ongoing operations.
• Designed new backup strategies: mysqldump, zfs snapshots, aws snapshots and Percona XtraBackup.
• Successful Point-in-Time Recovery Using Binary Logs, XtraBackup copies and snapshots.
• Designed Archival process to retain data from production to S3.
• Deployed MongoDB and Configured replica sets in different zones wif 3 and 5 node setup.
• Managed mongo replica configuration using priority settings wif hidden replicas for backups.
• Implemented sharding for all teh gluon games to support concurrent users in millions.
• Pre/Post launch right sizing of teh environment using load test results wif QA team to meet teh expected CCU need.
• Online scaling and right sizing: additions/removal of shards, instance size management.
• Designed unique backup strategies for sharded mongo clusters using mongodump and snapshots.
• Managing and controlling retention of backup snapshots using aws-cli.
• Monitoring Services using Nagios, New Relic and Mongo cloud manager.
• Implemented MongoDB tools for maintenance like mtools, mongostat and mongotop.
• Autoscaling: Implemented autoscaling on tomcat servers using AWS ASG.
• AWS Migration: Managed data migration between 5 different AWS accounts including AWSCN.
• BI: Implemented ETN between Studio AWS account and BI AWS accounts to stream data analytics.
• BI: Using JQuery and Php, created reports using live game data to report revenue vs aws cost, dau vs cost and arpdau vs cost.
• Designed database archival process for disaster recovery using S3 and Glacier.
• Central Logging: Implemented using elasticsearch/Logstash to halp DevSupport troubleshoot issues on Live games.

Confidential , Watertown, MA

Senior Database Administrator

Responsibilities:

• Managed Production\QA\Engineering\UAT environments in their SAAS environment.
• MySQL\Percona Server: Replication setup\support: Master-Slave, Master-Slave-Slave.
• Capacity Planning, DR management, change control, Performance tuning, Index Optimization.
• Percona XtraBackup, mysqldump, ZFS snapshot backups.
• Maatkit/Percona Toolkit: query-digest, index-usage, archiver, table checksum, table sync.
• AWS, RDS admin.
• Monitoring using custom scripts, Nagios and Scope.
• Oracle 10g support and maintenance.
• ETL using Data pump, SQL Loader.
• RMAN backup planning\management using recovery catalog.
• Knowledge and Understanding of Data Guard for switchover and failover.
• Supported SQL Server BI env, managing ETLs between different SQL environments via Linked Servers, Db Links and ODBC.
• Managing ETLs between different SQL environments.
• Log Shipping Implemented for failover.

Confidential, Westborough, MA

Technical Architect / SAAS DBA

Responsibilities:

• Designing server architecture, capacity planning, and right sizing for new clients.
• Project Planning for Server Moves, Data migration and Architecture changes.
• MySQL: Deployment, monitoring, scaling, replication, partitioning, archiving and maintenance for SAAS hosting.
• Installation and setup of SQL Server 2008 R2.
• Backup procedures using SSIS: Full and Differential backups.
• DR planning for SAAS database servers
• Replication Setup: Transactional Replication.
• Setting up MySQL Database servers: MyISAM and InnoDB.
• Ability to work at MySQL binary logs level used by disaster recovery planning.
• Migration of database from MySQL to MSSQL.
• WatsUp gold, Nagios, MySQL admin, Replication Monitor, Percona Toolkit.
• VMware: ESXi installation, vCenter Server,.
• Creating and monitoring VMs on VMware vSphere 5.

Confidential, Westborough, MA

MySQL DBA

Responsibilities:

• Lead teh offshore Tier1 and 2 DBA support teams.
• Deploying MySQL servers and setting up monitoring.
• Performance Tuning, DR planning, capacity planning, backup management.
• Experience in both MyISAM and InnoDB Engines, migrating database to and fro.
• Cognos server installation, configuration wif MySQL and MSSQL databases.
• Creating custom reports using Report Studio.
• Installing Tomcat Application server and Ftp servers.
• Coordinating wif Dev-Support for deployments, CRs, bug tracking and documentation.

Confidential

Network Engineer

Responsibilities:

• Provided service as network consultant to banks and other institutions.
• Deployed MySQL servers for several clients.
• Configured replication master-master and master-slave for failover and reporting purposes.
• Backup management for disaster recovery.
• On Call support and services as a database consultant.