Sumit Malik — VP of Engineering
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.
Stackforce AI infers this person is a Database Architect specializing in Fintech and Cloud Infrastructure.
Location: New Delhi, Delhi, India
Experience: 14 yrs 3 mos
Skills
- Database Administration
- Database Optimization
Career Highlights
- 14+ years of database architecture experience.
- Expert in AWS, Google Cloud, and Microsoft Azure.
- Proficient in high availability and replication solutions.
Work Experience
BharatPe
Head of Databases (1 yr 11 mos)
Principal Database Architect (2 yrs 3 mos)
Paytm
Tech Lead Database Engineer (2 yrs 10 mos)
TechTree IT Systems Pvt. Ltd.
Senior Database Engineer (3 yrs 10 mos)
Database Engineer (1 yr 9 mos)
IRCTC
Database Administrator (1 yr 7 mos)
Education
Bachelor of Technology - BTech at Maharshi Dayanand University