ICT Engineer (Sr. Database Administrator)
Ericsson Global India Ltd.
Total years of experience :10 years, 10 Months
• Installation, Configuration, upgradation, Migration, Backup, Restore of MySQL and Mongo instances.
• Identified bug in mongo version 3.2.0 which is taken care by upgrading it to 3.2.19.
• Mixed Replication Setup (Asynchronous - Master-Slave, Master-Master, Master-Repeater-Slave)
• Implementation of Higher Availability- Synchronous replication (NDB Cluster, Galera Cluster)
• Service automation, Capacity planning, Performance Analysis, DB Profiling, Query Optimization for MySQL and MongoDB:
• Design the backup and recovery process using MySQL enterprise backup tool. Have implemented the partial enterprise backup using table transport option (tts) along with incremental backup.
• Implemented Proxy partial replication slave by using the blackhole engine feature in MySQL.
• Redesigned solution: mongo DB single shard cluster converted in to replica set.
• Automated ELK stack (Elastic-search, Logstats, Kibana) installation and configuration process using bash shell script with robust and re-usable code with proper check and validation.
• Automated installation and configuration process of pgCluster (PostgreSQL + RepMgr + Keepalived) with proper checks and validation.
DevOps Achievement:
• Developed a tool to collect mongoDB metrics and real time stats. Below listed technologies are being used.
o DASHBOARD: Grafana (graphs are being plotted using its intelligence)
o DATASOURCE: Elastic Search (Backend Data source for Grafana)
o DATA PIPELINE: Bash Script (Extract data from MongoDB, Transform and Load to Elasticsearch)
• Automated Mongo DB backup process. Compressing on the fly and placing it remotely.
• Created Zamanda Backup copy verification utility using bash script which will bring MySQL instance using ZRM-TAR copy and generate a comparison report with master. (One of my major automation)
• Demonized the process to track the Unix user malicious activities and sending alert in controlled fashion.
• Created a demon to track malicious queries and process-list fluctuation in all MySQL instances. Malicious queries are being considered on few params like query without 'where' clause, query with '*' etc.
• Automated the deployment Mongo DB instances as cluster, replica set and standalone.
DBA Achievements:
• Installation and configuration of MySQL and Mongo instances (shard and replica set)
• Huge experience in switch over/Failover (promoting relay-slave or slave as master)
• Performed upgrade of MySQL instances from 5.6 to 5.7 and 5.5 to 5.7
• Performance Analysis, DB Profiling, Query Optimization for MySQL and MongoDB
• Managed table partitions and shard the data of native MySQL instance
• Mixed Failover (Replication) setup (Asynchronous - Master-Slave, Master-Master, Circular Master)
• Performed MongoDB rolling upgrade from 2.6 to 3.2 version
• Configuring Backups (ZRM backup, Xtrabackup)
• Performance Benchmarking (Percona Toolkit)
• Played Key role in Tb’s of data migration between datacenter over the internet
• Have implemented Mongo DB monitoring template for Zabbix
• Having good experience in MMAPv1 and Wired Tiger MongoDB engines
• Performed Conversion of Native MySQL to Galera Cluster
DBA Achievements: (2 yr. 2 month)
• Supported huge server farm with 3000+ MySQL/800+ Mongo instances, with uptime 99.9%
• Install, Upgrade, Configuration of NDB Cluster, Galera Cluster for various OLTP workloads
• Multi version MySQL installation over heterogeneous platforms (variant of Linux, UNIX)
• Setup Comprehensive DR (Disaster Recovery) plan and High Availability with replication solutions
• Performance tuning, Query optimizations, Benchmarking, technical documentation, Knowledge base articles for end users, upgrades, operational guidelines (SLA/SLO), IAM (Identity Mgmt.), Security
• MySQL replication setup for large workload requirement using Load balancer and/or relay slave (40 instances in a single topology with repeater concept)
• Huge experience in switch over (promoting relay-slave or slave as master)
• MongoDB administration for large replica set and sharded environment (Installation, Upgrade, Configuration, Migration, set up replica Set with Arbiter/hidden Secondary for DR/Fault Tolerance)
• Proficiency in various data management tools like McAfee database security auditing tool
• On call experience in a critical production environment on multiple database technologies (MySQL/MongoDB/Vertica/Oracle/PostgreSQL)
Software Engineer Achievement (Java/J2EE Developer: 3 month):
• Developed and implemented the MVC Architectural Pattern using Struts Framework, JSP and Servlets.
• Implemented server-side tasks using Servlets and XML.
• Integrated Spring DAO for data access using with Hibernate.
• Written Test Cases and closely worked with test team to identify bugs in application.
B.Tech In Electorincs and Communication