Oct 2018 – Present · 7 yrs 7 mos · Noida, Uttar Pradesh, India

• Working as Technical Support Manager at Linuxmantra. My profile includes managing Oracle, MySQL and Postgresql databases for clients. Installing various mysql servers, managing replication, Query optimization, monitoring overall performance of db server and tuning the same, taking regular backups. Automation of various dba related tasks. Partitioned table management

Dec 2016 – Oct 2018 · 1 yr 10 mos · Gurugram, Haryana, India

• Managing MySQL, MariaDB and Oracle database for different clients including Databases of TCL. Application Tuning via Query optimization. Handling replication . Automation of daily dba task such as scheduling database backups, analyzing slow query logs,,memory usage, capturing of various database logs. Monitoring performance of overall server at various levels and provide suggestions for improvement.

Jul 2015 – Dec 2016 · 1 yr 5 mos

• Completely responsible for overall configuration of the server.
• Managing multiple production servers with MySQL 5.6, and Mariadb 5 .
• Configuration of multiple Replication topologies, handling and troubleshooting replication related errors, keeping all the slaves sync with master all the time.
• Working closely with developers for writing good applications.
• Analyzing and changing MySQL related configuration variables regularly and tune them according to data growth.
• Implemented DR site to make Mysql highly available.
• Upgrading mysql servers .
• Automated daily backup of servers via Linux scripts.
• Migration of mysql to NoSQL, esp, cassandra
• Ensure backup of servers on daily or as per requirement basis
• Using multiple percona tools for backup, restoration and performance related monitoring.
• Working with slow query log and using EXPLAIN and EXPLAIN EXTENDED to analyze queries and optimize them.
• Responsible to analyzing the current performance of the Server and providing recommendations with respect to increase/decrease of system resources with respect to schema design, Indexing, character set conversion, etc.
• Placing nagios alerts to monitor various system related and db related alerts and monitoring these alerts and performing troubleshooting when any alerts / warning arises.
• Responsible to create EC2 machines on AWS cloud and moving mysql and mariadb databases on them.
• Changing the EC2 instance types to lower or higher instance types according to decreasing or increasing requirement of the organization thus helping them to manage its cost properly.
• Responsible for complete security of the overall server by using proper access control at the system level as well as on DB level by using proper account management, opening only required ports via the iptables and EC2 console, implementing two factor authentication to use mutiple services of the servers, such as secure shell, secure ftp and others.

Jan 2015 – Jul 2015 · 6 mos · Noida Area, India

• Managing multiple production servers with MySQL 5.6 and mariadb 5.
• Reguarly upgrading DB servers to latest version of MySQL.
• Working with TokuDB Storage engines
• Configuration of multiple Replication topologies, handling and troubleshooting replication related errors, keeping all the slaves sync with master all the time.
• Working closely with developers for writing good applications.
• Analyzing and changing MySQL related configuration variables regularly and tune them according to data growth.
• Making MySQL highly available all the time.
• Moving to DR site in case of any disaster.
• Migration of DB servers
• Automation of backup scriptss.
• Monitoring of various database and system related alerts and responding to them for managing their overall health.
• Proper space management

May 2012 – Jan 2015 · 2 yrs 8 mos · moti nagar, new delhi

• Providing consulting to various corporate clients regarding administration and maintaining overall health of Oracle and MySQL databases.
• Managing Oracle and MySQL server over Linux and Windows platform.
• Providing training on various technologies of Oracle and MySQL server.

May 2011 – Apr 2012 · 11 mos · new delhi

• Providing consultancy to various corporate clients regarding managing the overall health of Oracle and MySQL databases.
• Delivering corporate training on Oracle 10g administration and MySQL administration.

Mar 2006 – Jul 2007 · 1 yr 4 mos

• Providing training on C,C++,Unix/Linux ,etc as well as providing training on various subject areas to complete the requirement for DOEACC O and A level.