Mughees Ahmed

MySQL DBA I

Percona • Período integral

May 2021 - Present • 5 yrs

Administered, supported and monitored databases by proactively resolving database issues and maintaining servers. Troubleshooting & Resolved Production problems, improved operations and provided exceptional client support. Handle common database procedures such as recovery,optimization, migration,upgrades etc. Ensure performance, security, and availability of databases. Drop a large(TB) table using a hardlink process Building and supporting all installation, backup configurations, performance, maintenance, migrations and upgrade activities with MySQL, ProxySQL, Orchestrator , Galera cluster and INNODB CLUSTER 8.0. Handling minor and major upgrades 5.6 -> 5.7 -> 8 Migration from one servers to another with minimum DT (only application change to new server) using replication Migration to EC2 and Amazon RDS with mydumper restore and replication. Upgrades of AWS RDS from 5.6 to 5.7 version. AWS Aurora minor and major upgrades, using backup restore, snapshots and the blue-green method. Deployment of InnoDB Cluster and ClusterSet for DR site. Deployment of PXC/GALERA CLUSTER, managing the patching and zero downtime rolling mode Deployment of load balance PROXYSQL on separate layer and configuring read write split. Configuration of Orchestrator for Replication topology management . including manual and automatic failover and reallocation of replicas Ensuring HA & DR setup as per client environmental requirements and implementing best practices. Ensuring HA & DR setup as per client environmental requirements and implementing best practices. Troubleshooting abnormal incidents and operation problems and preparing incident Notifications. Participation in an on-call coverage rotation plan in the team. Installation and configuration Percona Monitoring and management Writing script for xtrabackup, mydumper and mysqlbinlog backup steaming to remote server Handling the on-call shift which are related to customer queries and database related issues could be server crash

Database Administrator

techvision • Meio período

Sep 2023 - Dec 2024 • 1 yr 3 mos

Responsible for Managing InnoDB Cluster and MS SQL Server Always on multiple Cluster along with the DR site; I built their Cluster and the DR site and participated in Upgrades and DR drills.

Database Administrator

ACE Currency • Meio período

May 2021 - Jul 2022 • 1 yr 2 mos

Responsible for providing support to the replication topologies, setting up the backup strategies and alerting using PMM, and managing the SQL server standalone.