About

Gaurav Tomar is a highly motivated and professional DBRE at PhonePe with over 8 years of experience in administration work in the software industry. He is an expert in database administration, modeling, development, installation, benchmarking, security, availability, maintenance, upgradation, migration, performance tuning, and production support of large-scale relational and NoSQL databases. Gaurav has a strong understanding of MySQL's underlying storage engines and has participated in application team discussions for initial design of new databases, making recommendations for the design and implementation of the new databases. He has effectively configured replication topology as part of an HA solution and has experience in installation, configuration/tuning, troubleshooting, and optimization of MongoDB servers in sharded or replica set topology. Gaurav has worked with automating database backup (Physical and Logical), recovery, and point in time recovery procedures and has expertise in snapshot, import/export, DB optimization. He has also migrated databases from physical data centers to the cloud (Azure). Gaurav has hands-on experience in writing shell scripts, setting up maintenance and monitoring scripts for error and severe error alerts, and capacity analysis. He is proficient in writing and optimizing SQL statements and has designed cross-database data synching shell scripts (Mongo to MySQL, Redis to MySQL, Solr to MySQL). Gaurav has knowledge of MySQL features, such as stored procedures, triggers, views, event scheduler, etc. He has been involved in client production support and maintenance tasks, including programming, debugging, and testing of existing applications that run in a production environment for purposes of remediation system errors. Gaurav has experience in fixing functional and technical issues, and he possesses strong motivational and leadership skills, which allow him to produce the best results in pressure situations. He can multitask, react quickly to shifting priorities, and meet deadlines. Gaurav is good in oral and written communication skills and can work in a team and contribute to growth. He is also good in decision-making and has effectively handled presentations convincingly with clients. Gaurav's tech stack includes SRE, MySQL, MongoDB, Redis, SQL, test, NoSQL, and Azure. He has relevant experience of 10.69 years and has worked with companies like Myntra and Jabong in the past. Gaurav holds a Bachelor of Technology (B.Tech.) degree in Electronics and Communication Engineering from IEC College of Engineering & Technology.