Summary
Overview
Work History
Education
Skills
Websites
Certification
Language Competencies
Open Source Contributions
Hobbies and Interests
Timeline
Generic
Mannoj Kumar Saravanan

Mannoj Kumar Saravanan

Bangalore

Summary

With over 17years of experience as an SRE, being a part of open source excites me in solving problems & letting innovative thoughts go beyond pen and paper.

Overview

18
18
years of professional experience
1
1
Certification

Work History

SRE-3

Phonepe
Bangalore
12.2022 - Current
  • Responsible for Elasticsearch, Pinot and Mysql Ecosystem at Phonepe
  • SME of Elasticsearch 6000 Nodes in 10 Clusters, data ~14PB.
  • Architected and Automated ES upgrader module.
  • Implemented effective rebalance and sizing strategies for performance
  • Introduced Data Tiered architecture (Hot/Warm/Cold)
  • Arrow - Created Python API project for Elasticsearch Postman, enables auditing for changes.

Principal Engineer

Dream11
Mumbai
04.2021 - 12.2022
  • Lead the roadmap for the DataSRE team.
  • Design and implement Disaster Recovery.
  • Architect and Developed Chaos and Resiliency Platform for Dream11 micro services.

SRE

Phonepe
Bangalore
10.2017 - 04.2021
  • Responsible for Reliability of Mariadb, Elasticsearch and Aerospike that are on critical paths in Phonepe Payment systems.
  • Implemented Circular Replication for Cross-Datacenter Replication in MariaDB-Galera.
  • Figured out how to demote a node from a MariaDB-Galera and add it as a replica to the cluster group and automated.
  • Incorporated RSU with LVS for MariaDB-Galera. For HA and Schema Changes.
  • Automated partition level backup for weekly archival.
  • Written Salt states for Galera, Elasticsearch and Aerospike to Install, Configure and Monitor.
  • Maintaining 120Node ES Cluster and Auto-Restart nodes that are stuck in Old GC. Collate Graphs to Monitor Elasticsearch health.
  • Implemented XDR (Cross Datacenter) in Aerospike Systems.
  • Helped intern team to achieve Galera Family Inventory and Automation on Authorisation with Audit.

Design DBaaS

GovTech
Singapore
10.2016 - 08.2017
  • Company Overview: (Contract: Compo2000)
  • Write Ansible APIs to Install, configure, replicate, clone, Full/Incremental/Transactional and OnDemand Backups and Restores and other administrative tasks.
  • Tweaked High Availability modules to adhere to Govtech Infrastructure and merge with Govtech PaaS Intra/Inter Site with the help of a small group of energetic application and infra team.
  • Automated Docker Images to be pushed to Docker Registry that is updated in DockerHub.
  • (Contract: Compo2000)

DBA Lead

Olacabs
Bangalore
08.2014 - 10.2016
  • Joined Olacabs as a first DBA and had been a part of Ola journey from 10K bookings to 10 Million bookings per day.
  • Responsible for maintaining Mysql and NoSQL DB stores serving at a peak of 150K RPM traffic ensuring 20ms response time.
  • Brought down 80% hot CPU of Mysql Master server to 20%.
  • Disaster recovery on data was recovered within minutes and the business recovered.
  • Suggested and carried out application level re-arch in Database.
  • Figured an SQL injection on Prod and actioned immediately without any data leak or disaster.
  • Fixed application issues on Isolation, Deadlocks and Query tuning.
  • Write Chef CookBooks for Mysql, Mongo and Aerospike.
  • Supported Mongo, Elasticsearch, Aerospike, Cassandra, Scylla to maintain its availability for downstream and driver path devices.

Lead Mysql DBA

Colt
Bangalore
05.2013 - 08.2016
  • DBA for applications supporting Telecom Operators in Europe.
  • Implemented Automatic Failover using VIP and Heartbeat Protocol.
  • Reported RCA for any service unavailability and proposed long term solution for it.
  • Implemented Postgresql Replication and authentication rules.

DBA

Symbiotic
Chennai
02.2012 - 05.2013
  • Mysql DBA for applications supporting Telecom Operators Du, Airtel, Reliance.
  • Migrated DB servers from 5.0.77 to 5.5.28.
  • Introduced Percona-Xtrabackup and Automated DB backups for full and incremental and rotate regularly to SAN that is mirrored and taped.
  • Created Slave of 2TB Mysql Instance without locking or disruptions to Applications.

Systems Engineer

Dell-PerotSystems
Singapore
03.2010 - 02.2012
  • Support Engineer for UBS Wealth Management and Investment Banking applications.
  • Worked as a System Engineer on MQ, Tibco EMS, Websphere/Tomcat/Apache services, IIS Wintel, OrcaNG, IDM, Tibco RV for Prod and Non-prods upon requests and critical incidents.
  • Automated basic troubleshooting for DB, Messaging and Web/App servers via Netcool/Webtop Reduced Efforts of 3FTE on manual tasks.

Systems Engineer

iGATE
Bangalore
11.2007 - 03.2010
  • DBA for Jetstar Airways and NBCU.
  • Worked as a DBA for Mysql and Oracle.
  • Upgraded Oracle 8i, 9i databases to Oracle 10g.
  • Implemented RMAN and Dataguard.
  • Automated DB scripts to monitor Oracle Databases and can be incorporated in any DB infrastructure in iGATE.

Education

Bachelor of Computer Applications -

Madras University
Chennai
04-2007

Skills

  • MySQL and MariaDB
  • PostgreSQL and Oracle
  • Cassandra and MongoDB
  • Elasticsearch and Redis
  • Kafka and RabbitMQ
  • Python and Shell scripting
  • Ansible and Salt automation
  • Git version control
  • Data backup solutions
  • Monitoring tools (New Relic, Nagios, Datadog)
  • Containerization (Docker, KVM, VMware)
  • Cloud services (AWS)
  • Operating systems (Ubuntu, RHEL, CentOS, Windows)
  • Big data technologies (Hadoop, HBase)

Certification

OCA-I Oracle

Language Competencies

native language, fluent (speaking, reading, writing)

Open Source Contributions

  • Https://dba.stackexchange.com/users/10079/mannoj
  • Https://medium.com/@mannojkumarvv
  • Https://discuss.aerospike.com/u/mannoj/summary
  • Https://discuss.elastic.co/u/mannoj87/summary

Hobbies and Interests

  • Tennis - Intermediate
  • Table Tennis - Intermediate
  • Badminton - Intermediate
  • Cricket - Intermediate
  • Ultimate Frisbee - Intermediate

Timeline

SRE-3

Phonepe
12.2022 - Current

Principal Engineer

Dream11
04.2021 - 12.2022

SRE

Phonepe
10.2017 - 04.2021

Design DBaaS

GovTech
10.2016 - 08.2017

DBA Lead

Olacabs
08.2014 - 10.2016

Lead Mysql DBA

Colt
05.2013 - 08.2016

DBA

Symbiotic
02.2012 - 05.2013

Systems Engineer

Dell-PerotSystems
03.2010 - 02.2012

Systems Engineer

iGATE
11.2007 - 03.2010

Bachelor of Computer Applications -

Madras University

Similar Profiles

CREATE PROFILE
Mannoj Kumar Saravanan