Sumit Malik

Background

About Sumit Malik

Database Architect | DBA with more than 10+ Years of experience in all type of databases from Relational to No SQL. Working on AWS Aurora | MySQL | AWS RDS | Postgres | Mongo DB | MariaDB | MS SQL Server | NO SQL and Managing Google Cloud & AWS Cloud Services. Experience on design & architecting the Database environment using any framework. Installation, configuration & implementation of all the databases including MySQL AWS Aurora | AWS RDS | Postgres | MariaDB | Mongo DB | MS SQL Server databases and related products. Expertise in High Availability database solutions. MySQL using MySQL Orchestrator (https://github.com/github/orchestrator), Master-Slave replication depends on the application needs. Database performance tuning and optimisation which include both database tuning and hardware configuration and capacity planning. Define the database monitoring, monitoring thresholds, alerts, validate the notifications and maintain the documents for the future reference. Database version upgrades and maintain MySQL patches up to date in comply with infuse rules. Configure and maintain database high scaling solutions like RDS Proxy | ProxySQL | Haproxy | Maxscale. Expertise in various database data Archival strategy and Backup Solutions like MySQL dump, Percona XtraBackup, pt archiver, Mydumper, Myloader, Cold Backup, LVM snapshot, MySQL Enterprise backup and Recovery. Configure and maintain various database Replication solutions like Master-Master, Master-Slave, Multi source Replication & GTID based Replication. Work with engineering team to understand the database requirements and guide them the best practice and optimize the queries to get the better performance. Experienced working with various database tools like Percona Toolkit, Proxysql, Haproxy, gh-ost, pt-archiver, pt-checksum, MySQL Orchestrator, pt-online schema change, PMM & Tungsten Replicator. Working experience on various monitoring tools like: Zabbix, Datadog, AWS Cloud Watch, New Relic, Prometheus, Vivid cortex, PMM & Nagios. Writing backend processes using MySQL/MariaDB, Python and SHELL scripts. Work with application stake holders to understand the production requirements and purpose the effective database solutions. Adhere to the incident and change process, prepare the document and perform the peer review for all the planned production tasks.