Ruchi Agarwal

• Supporting MySQL DBs on Onprem (Linux host) and AWS Aurora
• Handling more than 500 MySQL DBs
• Enabling Audit logging in RDS and in Cloudwatch logs.
• Migrating the DBs from Onprem to RDS using ansible scripts
• Decommissioning the Onprem DBs using ansible scripts and RDS instances through RDS console and AWS cli
• Backup and recovery in RDS Upgraded the instance class in RDS to improve DB performance for highly active DBs
• Downgraded the DB instance class in RDS for cost optimization
• Identified and purged the old and unused table for cost optimization
• Upgraded the Aurora from version 2 to 3
• Created route53 endpoints both for RW and RO instances
• Upgraded the Aurora instances to latest Graviton2 Processors using terraform
• Used oak-chunk utility to update the records for large table
• Used gh-ost and PTOSC to alter large tables
• Whitelisted the application IPs using ansible play
• Using the Jira as ticketing tool.

· Supporting Percona MHA Replication databases.

· Installing, upgrading MySQL databases using ansible scripts

· Deployment of scripts across PROD servers as per standard Change Management Process

· Configuring backup using innobackupex tool of Percona

· Online altering, optimization of huge tables using pt-online-schema-change.

· Restoring the DB using copy-back and enabling replication via keyring.

· Enabling and set-up the MHA+1 and MHA+2 DBs.

· Helping team to resolve customer requests/incidents within limits of SLA's.

· Preparing the RCA for major issues and mentor other members of the team.

· Monitoring & tuning the database and troubleshooting performance issues of the server.

· Experience in supporting large DBs.

· Supporting Unix Patching of 40+ PROD servers in single go by failing over and failing back using MHA scripts

· Checking the DB status and generating the PCI Audit reports from MHA Master Nodes.

· Led a team of DBAs covering L1, L2 and L3 support.

· Attending Daily Customer Call/meetings and prepare Plan-Of-Action for activities to be carried out.

· Involved in transition of new projects onboarding to Mindtree. Also led the transition internally of projects moving from dedicated to shared model.

· Installing, configuring, managing, monitoring and troubleshooting MySQL Server 5.5/5.5/5.6/5.7

· Involved in discussions and implementation of migration and upgrades from 5.1 to 5.5, 5.5 to 5.6, 5.6 to 5.7

· Designed and configured Master-Master and Master-Slave Replication databases

· Designed and configured disaster recovery for critical production databases.

· Helping team to resolve customer requests/incidents within limits of SLA's.

· Preparing the RCA for major issues and mentor other members of the team.

· Monitoring & tuning the database and troubleshooting performance issues of the server.

· Managing Databases in AWS by creating new instance, creation read replica, deleting instance, and backup job creation, upgradation, enabling Cloudwatch logs, metrics monitoring, changing parameter values, user creation and managing access.

· Preparing the monthly roster and managing the shifts.

· Trained new team members about the process and technology and also extensively provided training to fresher batch joining Mindtree as a part of Mindtree Kalinga Program

· Installation of MySQL 5.6 (Binary & RPM) in Linux and Windows.

· Up gradation of MySQL from 5.1 to 5.5 and 5.5 to 5.6.

· Database Migration from Solaris and Linux.

· Good knowledge in MySQL Architecture and Storage Engines.

· Created Testing, Development and Production databases.

· Provide database administration on production, testing and development database servers.

· Responsible for user creation and granting permissions.

· Regular Monitoring of different log Files, backup files and analyze jobs on Day to Day Basis.

· Monitoring File System and Data files utilization.

· File System Management and User Management.

· Managing system and dynamic variables and tuning it based on database and application requirement.

· Using mysqldump and mysqlbinlog utility for full backup, table backup and point in time recovery.

· Restoring database from full backup, table level backup, single database and incremental backup.

· Monitoring the user sessions and take appropriate action to kill the inactive sessions.

· Remedy Management.

· Worked on BMC Remedy tool and SNOW tool to close the incidents.

· Responsible for DC maintenance after every shutdown and startup.

Weekly & Monthly Reports.