KHUMENDRA LILHARE

Experience

• 

  Loop Methods

  Feb 2010 - Jun 2013

  Sql dba

  mysql:>install mysql server by generic binary tar file>install mysql server by native package manager (rpm/pkg) in linux/unix and also by yum>did the decommission of mysql servers as per company process >set up percona xtradb cluster with galera plug-in and syncing two cluster of two dc by asynchronous replication by gtid.>installing and managing arbitrator/garbd for avoiding spilt brain in percona xtradb cluster.>setup master-master and master-slave replication in same box (machine) and in different boxes.>setup replication by log position and by gtid. setup semi-sync replication and also loss less semi-sync replication.>migrated mysql servers from windows machine to linux machine.>upgraded mysql server from 5.0.67 to 5.5.16.>creating hot, cold, adhoc, warm, object level backup. creating full backup and incremental>creating logical backup by mydumper and restoring by myloader. >restoration of dump, point-in-time recovery and validate it.>executing, planning dr activities twice in year in fixed time window.>user management and setting up password expiry policy.>performing online ddl in mysql servers.>customization of storage engine of mysql by changing parameter values.>performance tuning of mysql server by mysql slap etc, index creation.postgresql:>install postgresql server by source code and rpm>install multi-instance of postgresql server in same boxes and in different boxes>did the decommission of postgresql servers as per standard>configuring and troubleshooting replications>upgraded the postgresql server>creating hot, cold, adhoc, warm, object level backup>creating full backup and incremental backup>restoration of dump, point-in-time recovery and validate it.>establish and maintain backup and recovery policies and procedures>implement and maintain database security like create and maintain roles and assign privileges>experience in batch processes, import, export, backup, database monitoring tools and application support show less

• 

  People Prime Worldwide

  Jun 2013 - May 2014

  System administrator

  mysql:>install mysql server by generic binary tar file>install mysql server by native package manager (rpm/pkg) in linux/unix and also by yum>did the decommission of mysql servers as per company process >set up percona xtradb cluster with galera plug-in and syncing two cluster of two dc by asynchronous replication by gtid.>installing and managing arbitrator/garbd for avoiding spilt brain in percona xtradb cluster.>setup master-master and master-slave replication in same box (machine) and in different boxes.>setup replication by log position and by gtid. setup semi-sync replication and also loss less semi-sync replication.>migrated mysql servers from windows machine to linux machine.>upgraded mysql server from 5.0.67 to 5.5.16.>creating hot, cold, adhoc, warm, object level backup. creating full backup and incremental>creating logical backup by mydumper and restoring by myloader. >restoration of dump, point-in-time recovery and validate it.>executing, planning dr activities twice in year in fixed time window.>user management and setting up password expiry policy.>performing online ddl in mysql servers.>customization of storage engine of mysql by changing parameter values.>performance tuning of mysql server by mysql slap etc, index creation. show less

• 

  Tata Consultancy Services

  May 2014 - Jan 2016

  System engineer

  mysql:>install mysql server by generic binary tar file>install mysql server by native package manager (rpm/pkg) in linux/unix and also by yum>did the decommission of mysql servers as per company process >set up percona xtradb cluster with galera plug-in and syncing two cluster of two dc by asynchronous replication by gtid.>installing and managing arbitrator/garbd for avoiding spilt brain in percona xtradb cluster.>setup master-master and master-slave replication in same box (machine) and in different boxes.>setup replication by log position and by gtid. setup semi-sync replication and also loss less semi-sync replication.>migrated mysql servers from windows machine to linux machine.>upgraded mysql server from 5.0.67 to 5.5.16.>creating hot, cold, adhoc, warm, object level backup. creating full backup and incremental>creating logical backup by mydumper and restoring by myloader. >restoration of dump, point-in-time recovery and validate it.>executing, planning dr activities twice in year in fixed time window.>user management and setting up password expiry policy.>performing online ddl in mysql servers.>customization of storage engine of mysql by changing parameter values.>performance tuning of mysql server by mysql slap etc, index creation.postgresql:>install postgresql server by source code and rpm>install multi-instance of postgresql server in same boxes and in different boxes>did the decommission of postgresql servers as per standard>configuring and troubleshooting replications>upgraded the postgresql server>creating hot, cold, warm, object level backup>creating full backup and incremental backup>restoration of dump, point-in-time recovery and validate it.>establish and maintain backup and recovery policies and procedures>implement and maintain database security like create and maintain roles and assign privileges>experience in batch processes, import, export, backup, database monitoring tools and application support show less

• 

  Wipro

  Jan 2016 - Dec 2017

  Senior database administrator

  mysql:>install mysql server by generic binary tar file>install mysql server by native package manager (rpm/pkg) in linux/unix and also by yum>did the decommission of mysql servers as per company process >set up percona xtradb cluster with galera plug-in and syncing two cluster of two dc by asynchronous replication by gtid.>installing and managing arbitrator/garbd for avoiding spilt brain in percona xtradb cluster.>setup master-master and master-slave replication in same box (machine) and in different boxes.>setup replication by log position and by gtid. setup semi-sync replication and also loss less semi-sync replication.>migrated mysql servers from windows machine to linux machine.>upgraded mysql server from 5.1 to 5.7.>creating hot, cold, adhoc, warm, object level backup. creating full backup and incremental>creating logical backup by mydumper and restoring by myloader. >restoration of dump, point-in-time recovery and validate it.>executing, planning dr activities twice in year in fixed time window.>user management and setting up password expiry policy.>performing online ddl in mysql servers.>customization of storage engine of mysql by changing parameter values.>performance tuning of mysql server by mysql slap etc, index creation.postgresql:>install postgresql server by source code and rpm>install multi-instance of postgresql server in same boxes and in different boxes>did the decommission of postgresql servers as per standard>configuring and troubleshooting replications>upgraded the postgresql server>creating hot, cold, adhoc, warm, object level backup>creating full backup and incremental backup>restoration of dump, point-in-time recovery and validate it.>establish and maintain backup and recovery policies and procedures>implement and maintain database security like create and maintain roles and assign privileges>experience in batch processes, import, export, backup, database monitoring tools and application support show less

• 

  CenturyLink

  Dec 2017 - Mar 2019

  Senior software engineer

  cassandra, mysql postgresql database administration.

• 

  Cognizant

  Mar 2019 - Oct 2020

  Infrastructure technology specialist

  cassandra dba:• install new cassandra database releases and related software tools to evaluate in test/dev environments, eventually promote to production• manage and monitor availability, performance, and utilization of cassandra clusters.• strong knowledge of cassandra architecture, command line utility (nodetool)• apply software patches and upgrades to server software for cassandra database to stay in compliance with security standards and performance• analyze and resolve complex technical problems, including performance tuning, and debugging• monitor database backups and maintain automated disaster recovery procedures• plan database and server level capacity according to statistics and user requests• work with massive datasets in a real-time distributed system• continually improve availability, scalability, performance, and automation of our services• explore and evaluate cutting-edge distributed systems technologies and practices.mysql dba and postgresql dba: migration from on-prem mysql server to aws aurora mysql. also doing all mysql and postgresql dba activity. show less

• 

  UBS

  Oct 2020 - Mar 2022

  Associate director

  greenplum / postgresql dba