Sidhartha Kumar Singh

Director of Engineering

Bengaluru, Karnataka, India15 yrs experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 13 years of experience in database architecture.
Expertise in MySQL, MariaDB, and PostgreSQL server management.
Proficient in database optimization and high availability solutions.

Stackforce AI infers this person is a Database Architect with extensive experience in high-availability database solutions.

Contact

Skills

Other Skills

Amazon Web Services (AWS)Analytical SkillsApache KafkaBenchmarkingCCentOSCloud ComputingCloud SecurityCluster AnalysisComputer ScienceCore JavaData ServicesDatabase AdministrationDatabasesDistributed Systems

About

DBE/Data Modeler/Architect with 13+ Year Experience in Database Modeling, Designing Development, Maintenance, Setting and Managing Replication, Backup and Restore, Database Migration, Optimization, Synchronization of replicated database, Performance and Monitoring, High Availability. Installation and configuration of MySQL, Maria DB and Postgresql Servers. Upgrading versions of MySQL servers to MariaDB. Expertise in TokuDb. Security Management, Resource Usage . Technical support to clients and application development teams. Experience in designing solutions with Cassandra and its maintenance. Expertise in Scaling Database Solutions. Knowledge on various Backup and recovery tools for MySQL ( including Xtrabackup ) MySQL replication and Architecture Design for HA solutions. Table Maintenance, Index management and optimization . Re-writing the queries for a faster response based on optimizer and algorithms. Automating though jobs through shell scripting. Benchmarking the MySQL for various performance testing. Compared optimizer between MySQL and MariaDB Worked on all flavors of Linux. Amazon EC2 and RDS. Had indepth knowledge on Percona Tools kits, Xtrabackups. SPECIALTIES: Core MySQL and InnoDB. Database design, Development and Administration, Database High Availability.

Experience

15 yrs

Total Experience

3 yrs 9 mos

Average Tenure

4 yrs 6 mos

Current Experience

Meesho

Senior Engineering Manager

Oct 2021 – Present · 4 yrs 6 mos · Bengaluru, Karnataka, India

Grab

2 roles

Engineering Manager at Grab (DBRE/SRE)

Sep 2019 – Sep 2021 · 2 yrs

Lead Database Administrator

Sep 2018 – Sep 2019 · 1 yr

Paytm

3 roles

Technical Lead

May 2018 – Aug 2018 · 3 mos · Noida Area, India

Senior Database Engineer

Promoted

Jul 2016 – Apr 2018 · 1 yr 9 mos · Noida Area, India

Database Engineer

Jun 2014 – Jun 2016 · 2 yrs · Noida Area, India

Monitor database operations.
Installation of monitoring tool, setting of different alert level to different parameters (System, Memory and Hard disk).
Setting up alert and level for MySQL (uptime, Users, Replication information, Alert based on different query )
Setting up alert and level for Application (Port/Binary running)
Estimate MySQL database capacities; develop methods for monitoring database capacity and usage.
Develop and support MySQL database replication (Active-Passive, Active-Active(MMM))
Develop and optimize physical design of MySQL database systems
Tune and optimize the performance of all the staging and production database instances.
Establish mechanisms for data backup/restore of relational databases; provide restoration services as needed
Plan and execute disaster recovery.Develop stored procedures, Functions and triggers in support of application development.
Participate in application development projects and be responsible for the database architecture and design.
Develop application-specific fault-tolerant distributed database mechanisms .
Synchronization of replicated database.
Benchmarking of database and servers.
On-call support(24/7) to users.
Database security(User creation, Update, Drop).

One97 communications limited

Software Engineer

Nov 2010 – May 2014 · 3 yrs 6 mos · Noida

Having experience of running multiple mysql instance on single machine.
Excellent in writing optimize MYSQL queries .
Strong ability in maintaining high quality standards.
Configuration level knowledge of database.
Worked in Mysql Cluster and Replication environment.
Strong Knowledge of monitoring tools like Monyog,Newrelic and Percona-tool-kit. .
Strong with Relational Database Management Systems- MySQL.
Highly motivated, multi talented, energetic, self-starter with good analytical interpersonal skills.
Excellent in communication skill.