Sumit Malik

VP of Engineering

New Delhi, Delhi, India14 yrs 3 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 14+ years of database architecture experience.
  • Expert in AWS, Google Cloud, and Microsoft Azure.
  • Proficient in high availability and replication solutions.
Stackforce AI infers this person is a Database Architect specializing in Fintech and Cloud Infrastructure.

Contact

Skills

Core Skills

Database AdministrationDatabase Optimization

Other Skills

AWS AuroraAWS RDSBackupBackup SolutionsConfigurationData ArchitectureData MigrationDatabase designDatabase monitoringDatabase performance tuningDatabase toolsDatabasesDisaster RecoveryGitHubHAProxy

About

Database Architect | DBA with more than 14+ Years of experience in all type of databases from Relational to No SQL. Working on Amazon DynamoDB | AWS Aurora | MySQL | AWS RDS | Postgres | Mongo DB | MariaDB | MS SQL Server | NO SQL and Managing Google Cloud , Microsoft Azure & AWS Cloud Services. Hands-on experience on AWS, Google Cloud, Microsoft Azure, and Oracle Cloud Infrastructure. Experience on design & architecting the Database environment using any framework. Installation, configuration & implementation of all the databases including MySQL | Amazon DynamoDB | AWS Aurora | AWS RDS | Postgres | MariaDB | Mongo DB | MS SQL Server databases and related products. 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 patches up to date in comply with infuse rules. Expertise in various database data Archival strategy and Backup Solutions like AWS snapshot, 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. Configure and maintain database high scaling solutions like RDS Proxy | ProxySQL | Haproxy | Maxscale. Expertise in High Availability database solutions. MySQL using MySQL Orchestrator (https://github.com/github/orchestrator), Master-Slave replication depends on the application needs. 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 etc Writing backend processes using 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.

Experience

Bharatpe

2 roles

Head of Databases

Promoted

Apr 2024Present · 1 yr 11 mos

Principal Database Architect

Dec 2021Mar 2024 · 2 yrs 3 mos

Paytm

Tech Lead Database Engineer

Feb 2019Dec 2021 · 2 yrs 10 mos · Noida, Uttar Pradesh, India

  • Installation, configuration & implementation of all the databases including MySQL | AWS Aurora | AWS RDS | Postgres | MariaDB | Mongo DB and related products.
  • 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 patches up to date in comply with infuse rules.
  • Expertise in various database data Archival strategy and Backup Solutions like AWS snapshot, 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.
  • Configure and maintain database high scaling solutions like RDS Proxy | ProxySQL | Haproxy | Maxscale.
  • Expertise in High Availability database solutions. MySQL using MySQL Orchestrator (https://github.com/github/orchestrator), Master-Slave replication depends on the application needs.
  • 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 etc
  • Writing backend processes using 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.
MySQLAWS AuroraAWS RDSPostgresMariaDBMongo DB+12

Techtree it systems pvt. ltd.

2 roles

Senior Database Engineer

Promoted

Apr 2015Feb 2019 · 3 yrs 10 mos

  • Provide 24*7 support to the clients for various MySQL database related issues
  • Responsible for installation, Configuration & Implementation of MySQL databases
  • Performed new databases design, configuration, backup, recovery, tunning and MySQL
  • upgradation.
  • Monitoring Memory usage, Innodb status, checking the status of backup jobs
  • Backing up databases using Mysqldump, XtraBackup, Cold backup, LVM snapshots, and MySQL
  • Enterprise backup .
  • Configure and Maintaining MySQL Server Database Master-Master, Master-Slave &
  • GTID Replication
  • Creating MySQL objects like Database, logins, database objects like tables, Users, Indexes
  • Installation & Maintaining MySQL multiple instances on the same server.
MySQLBackupRecoveryReplicationDatabase designConfiguration+2

Database Engineer

Jun 2013Mar 2015 · 1 yr 9 mos

Irctc

Database Administrator

Oct 2011May 2013 · 1 yr 7 mos · Delhi, India

  • Responsible for installation, Configuration & Implementation of Oracle & MS SQL server 2008 R2/2012 databases with their latest service packs
  • Monitoring SQL Server Log shipping and Replication
  • Monitoring free space in Data Drive, Log Drive, Backup Drive
  • Monitoring Database size, Job scheduling, log file, recycle error log
  • Defining database backup and restore strategies
  • Troubleshooting of user problems regarding Database and Applications.

Education

Maharshi Dayanand University

Bachelor of Technology - BTech — Computer Science

Jul 2006Jul 2010

Stackforce found 100+ more professionals with Database Administration & Database Optimization

Explore similar profiles based on matching skills and experience