Mohamed Moosa Jamal
Summary
Accomplished Database Engineer with expertise in cloud migration and database automation. Proven track record in optimizing AWS Aurora and GCP Cloud SQL environments. Skilled in performance tuning and backup strategy development, with strong leadership in mentoring teams and driving innovation. Successfully reduced costs by 20% through strategic database consolidation.Implementation of AI in DB operations to minimize manual jobs and to boost automations. A proven track record of working in a fast-paced environment.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Database Engineer IV
Groupon Shared Service
09.2023 - Current
- Migrating the AWS DB instance from AWS cloud infra to GCP CloudSQL DB instance. Doing the POC = on how to migrate, developing the ansible playbook to automate the process.
- Working on the backup strategy and automating the process of backups.
- DB upgrade using the blue/green deployment in AWS 5.7 to 8.0.
- Cost Cutting by analyzing the Storage, Data trimming, Consolidation of Standalone DB instance, Rebuild of DB instance.
- Building self-service tools that enable teams to deploy databases in the cloud using a Web UI and N8N workflows.
- Developed automated DB provisioning with Crossplane, improving speed, consistency, and reliability of cloud DB deployments.
Senior Software Engineer
Walmart Global Tech
09.2022 - 09.2023
- Managing Walmart's fleet of Informix databases for Home office, Stores and Distribution centers.
- Providing Automation scope for self-healing replication alerts for MariaDB.
- Conducting meetings with stakeholders understanding the business requirement and getting the work done.
Senior Database Engineer
Groupon Shared Service
04.2019 - 09.2022
- Managing around 3400 plus databases as each service is a microservice and uses individual DB instances.
- Scaling and maintaining the environment on RDS using Terraform and a wrapper around as terragrand.
- Created Ansible playbooks for migration from RDS to RDS (Single instance to multi-tenant to save cost).
- Completed different POCs like scaling with Aurora serverless, using route53 for auto failover in DNS, using ProxySQL implementation and its usage.
- Migration of Database instances from non-cloud premises to AWS RDS.
- Using Ansible-playbook to maintain the on-prem environment.
- Maintaining databases in a hybrid environment (replication between on-prem & RDS).
- Implementing solution for Automatic DNS failover using Route53.
- Helping the application team identify the weak queries and helping to optimize it.
- Working on huge tables modification using online schema tools like pt-OSC & ghost.
- Expertise in snapshot, import/export, and Database optimization with the help of explain plan.
- Analyze long-running/slow queries and tune the same to optimize application and system performance.
- Upgrading the existing production environment to Aurora 3.0 which is MySQL 8.0.
- Implementing a solution for the data archiving in tables using online table partitioning.
- Performed MySQL Replication setup and administration on Master-Slave and Cascading Master-Slave. Effectively recover databases from disasters. Performed Point in time recovery (PITR) using binlogs, promotion of slave to master, and restoration.
Cloud Engineer RDS
Amazon Development Center
11.2017 - 04.2019
- Troubleshoot network issues: VPC, Subnet Groups, DNS issues.
- Management of Databases hosted on AWS especially MySQL/ Aurora MySQL & PostgreSQL.
- Handling multiple issues of customers.
- Went to multiple customer sites within India Example (Swiggy) and troubleshoot within the customer space by indulging in customer-facing.
- Providing best practices for the customer to help in migrating to AWS Cloud infra.
- Helping customers to migrate databases from On-Prem to AWS cloud infra.
- Deep troubleshooting various issues with customer environment including application troubleshooting and database base tuning.
- Explaining to the customer with a better understanding of RDS services.
- Deep knowledge of in-house products like Aurora MySQL.
- Helping customers to design the best architectural steps for DR, backup strategy, and so on.
- Providing technical support for the customers to help in troubleshooting deep dive into the issue.
- Helping the teammates with proper training materials creation and documents for future references.
- Mentoring the college grads to become independent with the work.
- Ensuring all the sessions and mentoring grads to proper functions of working up to the mark.
System Engineer
FactSet
04.2016 - 11.2017
- Management of Databases hosted on On-prem & AWS, especially MySQL/Maria.
- Management of different MySQL instances (up to 110 Mysql Individual instances).
- Implementation of MySQL Inventory to track the MySQL instances, hosts, and stake Holders.
- Implemented cross-site replication and table-level replication to provide minimal downtime.
- Implementation of MongoDB for a client-facing application.
AWS Cloud Engineer
Rean Cloud
03.2015 - 04.2016
- Providing Automation of infrastructure of clients environment by using CFTs.
- Migration of Database instances from non-cloud premises to AWS RDS.
- Developed shell scripts to automate most of the Backups.
- Working with storage Provider Netapp (Netapp AultaVault Appliance).
Engineer DBA
Wave Crest Payment Technology
08.2013 - 03.2015
- MySQL installation, client and server installation, Binary installation, RPM installation.
- User Creation with associate privileges & New instance creation, handled multiple instances.
- Automate using shell scripts to handle database tasks.
- Upgrade on various versions of MySQL databases.
- Designed long-term data archiving solutions.
Education
B.Tech - Computer Science and Engineering
ANNA University
Chennal01.2011
Skills
- Cloud migration and database automation
- MySQL and PostgreSQL administration
- AWS Aurora and GCP Cloud SQL
- Infrastructure as code with Ansible and Terraform
- Shell scripting and performance tuning
- Backup strategy development
- AI tools integration
Certification
- AWS Certified Solution Architect Associate
- AWS Certified Developer Associate
- Red Hat Certified Engineer (System Administrator)
Timeline
Database Engineer IV
Groupon Shared Service
09.2023 - Current
Senior Software Engineer
Walmart Global Tech
09.2022 - 09.2023
Senior Database Engineer
Groupon Shared Service
04.2019 - 09.2022
Cloud Engineer RDS
Amazon Development Center
11.2017 - 04.2019
System Engineer
FactSet
04.2016 - 11.2017
AWS Cloud Engineer
Rean Cloud
03.2015 - 04.2016
Engineer DBA
Wave Crest Payment Technology
08.2013 - 03.2015
B.Tech - Computer Science and Engineering
ANNA University