Managing Master- Slave, Master - Master Setup in MySQL 8.0. Managing InnoDB Cluster with Single-Master and Multi-Master Deployment in MySQL 5.7 and 8.0. Managing MongoDB Replica Set, Sharding Clusters.Managing ELK clusters.Managing Opensearch clusters.

Worked on 5.5, 5.6, 5.7 version.Having good knowledge on installing MySQL on Unix PlatformManage Multimaster-Multisalve Architecture.24*7 Transactional Databases.Experience on MySQL InnoDB and MyISAM Database engines.Performance Tunning and Benchmark MySQL databases.Query optimization.Backup & Recover MySQL databases.Mysql Database Installation, Architecture and Database creation.Monitor and optimize MySQL database performance and capacity planning.To manage database users & privileges, creating users, assigning privileges and quota on table, monitoring database.Troubleshoot database issues, maintain database systems availability and scalabilityDatabase Performance optimization by finding and diagnosing slow-running queries.Develop and optimize database design for new applicationsTrouble shooting database issues (analysis, escalation, follow-up, solution).Monitoring database health, usage, growth of database size and disk spaces on regular basis.Installed and configure Codership Galera Cluster.Migrated MySQL master-master replication to Codership galera multi-master replication.Managing MongoDB replica Sets & Sharding Cluster.Implemented proxySQL+keepalived for read traffic distribution.

• Installation, configuration, and troubleshooting on Linux servers.• Responsible to install configure LAMP(Linux, Apache, MySql, PHP) softwares on Linux environment.• Installed and configured MySQL Master-Master Replication and Master-Slave Replication.• Providing grants to MySQL Users as per Security Compliance.• Real time database server monitoring and reviewing server logs. • Configure Backups of MySQL databases.• Configuration of Cron jobs for Backup Scheduling among different servers.• Manage mysql installation and configure master-slave replication, grants, user.• Responsible to installation/configuration of Tomcat servers• Configure mod_jk module and tomcat Load balancing.• Subversion(svn) installation, configuration for development team.• Installation, configuration and manage monitoring by using Zabbix server.• Configuration and manage DNS, FTP,NFS, SSH, Samba Server in Linux environment.• Responsible to provide high end technical support to the client.• Troubleshoot apache, nginx, php & mysql related issues.• Monitoring Servers uptime, Disk, Memory, Services, MySql Replication etc from Zabbix.

Worked as NOC Engineer (FM Services) in IT Infrastructure Management at the Client Site (Ibibo Web Pvt. Ltd. Gurgaon). Basic role was troubleshooting and monitoring of Windows Server 2003 and Linux Servers on which many applications are running like Web Servers, Database, Antivirus, SQL, and Exchange 2003. Also monitor and troubleshoot Network related issues on Routers, Switches, Firewalls and Backup. Synchronize with Netmagic Mumbai & Rackspace USA NOC Teams in Network related issues.• Manage disk management through LVM (logical volume management).• Ensure continuous operations of all servers and services via Troubleshooting of all network and server related problems.• Ensure monitoring of remote Data Centre environments is maintained to a high-level physical security.• Operate the NOC Monitoring tool (Application Manager, Opmanager & Munin) set monitor networks, applications, servers as defined in monitoring views and as required. • Assist with maintenance of accurate records and documentation, update of Standard Operating Procedures.• Monitoring & testing of different sites like Ibibo.com, Tradus.com, goibibo & Payu.• Reboot & take consoles the servers through Dell DRAC, IBM RSA.• Installations, Configurations and Troubleshooting of Windows 2003 and Linux servers, DNS, DHCP, TCP/IP, and User account management, Permission Management.