Jan 2023 – Jun 2023 · 5 mos

• Installation and configurations of MySQL & MongoDB servers.
• Setting up of one-way, two-way (M-M), replication and troubleshooting
• Setting up replica set as and when required.
• Attending audit calls and explaining DB level authentication techniques to compliance team.
• Working on different replication topologies
• Implement and maintain database security (Create and maintain users and assign privileges as and when required).
• DB maintenance activities periodically
• Security policy implementation as per the client requirements
• Participating and support to app teams during the load tests.
• Migrating database servers from data centers to Azure, AWS and GCP cloud.
• Creating AWS RDS & GCP CSQL instances with using terraform code
• Coordinated and deployed Hot Fixes in the Prod environments
• Experience on creating failover jobs in AWS logic app (automation account) for MySQL database automatic failovers using HA proxy Load Balancer.
• Creating MongoDB Replica set/Cluster setup using the ops-manger with Enterprise versions.
• Storage engine migration MMAPv1 to WiredTiger.
• Giving refreshes from production backup to pre-prod, test and development environments.
• Working hands-on on technical issues & releases and acted as part of reviewing of use case and process improvements
• Contributed as a part of daily/ weekly/ monthly stand-up and reviewed calls to discuss/ resolve any managed pending issues, future projects, and also current support progress and its related issues.

Apr 2021 – Jan 2023 · 1 yr 9 mos

Mar 2020 – Apr 2021 · 1 yr 1 mo

Oct 2018 – Feb 2020 · 1 yr 4 mos · India · On-site

• Installation and configurations of MySQL & MongoDB servers.
• Setting up of one-way, two-way (M-M), replication and troubleshooting
• Setting up replica set as and when required.
• Working on different replication topologies
• Implement and maintain database security (Create and maintain users and assign privileges as and when required).
• DB maintenance activities periodically
• Participating and support to app teams during the load tests.
• Migrating database servers from data centers to AWS & GCP cloud.
• Coordinated and deployed Hot Fixes in the Prod environments
• Experience on creating failover jobs in AWS (automation account) for MySQL database automatic failovers using HA proxy Load Balancer.
• Creating MongoDB Replica set/Cluster setup using the ops-manger with Enterprise versions.
• Storage engine migration MMAPv1 to WiredTiger.
• Giving refreshes from production backup to pre-prod, test and development environments.
• Working hands-on on technical issues & releases and acted as part of reviewing of use case and process improvements
• Contributed as a part of daily/ weekly/ monthly stand-up and reviewed calls to discuss/ resolve any managed pending issues, future projects, and also current support progress and its related issues.

Oct 2012 – Oct 2018 · 6 yrs · Greater Bengaluru Area · On-site

• Installation, configuration and upgrading of MySQL server, MongoDB, Postgres and related products.
• Setting up of Replication (One way, two way & Round Robin Replication) and troubleshooting of replication.
• Maintaining backup & recovery procedures using Percona & MEB Tools.
• Implement and maintain database security (Create and maintain users and assign privileges)
• Database tuning and performance tuning.
• Syncing of schema from development to production using schema sync tools.
• Hashing the sensitive data like email & DOB, etc. using triggers in slave servers for security.
• Implemented top slow query logs report with email intimation using mysqldumpslow and auto rotating logs and analyzing top slow query logs with development teams.
• Creating and scheduling ETL jobs to take the MySQL dumps and restore the tables from production to local servers and vice versa for development & testing teams as per user requirement.
• Migrating database servers from data centers to AWS EC2.
• Configuring and scheduling and monitoring daily incremental backups and weekly full backups for production databases using Percona Tools.
• MySQL upgradations from 5.5 to 5.7.
• Replication setting up of multi masters in MySQL 5.7 with GTID based replication.
• Implementing same existing database setup for DR failover database servers.
• Implemented audit plugin for checking failed logins & access denied errors.
• Analyzing MySQL query and Index optimization with development teams.
• Writing shell script and python scripts for long running queries, query locks and error logs.
• Configured MongoDB replica sets and sharding configurations with different data centers.
• Worked as part of team to provide 7*24 support.