Staff Engineer-Dbaas/DBRE/DBops/App DBA/SRE

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Bangalore Urban, Karnataka, India

Bangalore

Bangalore


Bangalore
Bachelor of Engineering (BE), Information Technology
RGPV Bhopal
Join Shubham and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal BossStaff Engineer-Dbaas/DBRE/DBops/App DBA/SRE
I am a Staff Database Reliability Engineer (DBRE) with 14+ years of experience in designing, operating, and scaling large-scale MySQL and PostgreSQL , Percona Mariadb Enterprise mysql and galera innodb cluster based database environments across On-Prem, AWS RDS, and Aurora. I focus on delivering high performance, cost-efficient, reliable, and highly available data platforms that enable business growth at scale.I lead and mentor a team of DBREs, driving technical direction, incident reviews, automation-first engineering, and continuous performance improvement. My work has consistently resulted in reduced latency, optimized query performance, increased system reliability, and significant cost savings across production workloads. Core Strengths & Focus Areas: Performance Engineering (Server tuning, Schema design, Query optimization)High Availability & Fault Tolerant Architectures (Aurora, Multi-AZ, Replication topologies)Cost Optimization across RDS, Aurora, Storage & Compute footprintsReliability Engineering practices (SLOs, Observability, Capacity planning, Incident response)End-to-end ownership of MySQL/PostgreSQL/Aurora ecosystemsTechnical leadership and mentoring of DBRE/DBA teams Key Experience Highlights: Designed and managed large, high throughput OLTP and analytics platforms on AWS RDS/Aurora.Executed zero-downtime upgrades, major version migrations, and replication cutovers.Implemented ProxySQL / HAProxy / MaxScale based routing for resilient architecture.Built backup and recovery strategies using XtraBackup, MariaBackup, mysqldump/pgdump, maintaining strong RPO/RTO guarantees.Extensive hands-on experience with Percona Toolkit, online schema changes, performance diagnostics, slow query analysis & workload benchmarking.Automated routine operations, monitoring, and scaling workflows via shell scripting & AWS Lambda.Experience with MongoDB, ClickHouse, ScyllaDB, Solr, ElasticSearch, and core Linux admin. I bring a problem-solving mindset, strong ownership, and the ability to collaborate with engineering, product, and SRE teams to ensure reliability, performance, and business continuity at scale.
Greater Bengaluru Area
Staff Engineer at Freshworks, Jan 2025 - Present · 1 yr 9 mos, Bengaluru, Karnataka, India
Lead Database Reliability Engineer at Freshworks, Jun 2022 - Dec 2024 · 2 yrs 7 mos, Bengaluru, Karnataka, India, Responsible for availability reliability and performance of Freshworks Databases stack. Managing Mysql Postgres rds /aurora databases in freshworks.Also works on scylladb mongo db and cassandra, clickhouse nosql type modern edge databases .
Senior Consultant at Infosys Ltd, Feb 2021 - Jun 2022 · 1 yr 5 mos, Bangalore Urban, Karnataka, India, Determined areas for improvement for Production databases and implemented processes to alleviate problems. Managing 10 plus database administrators team and providing L3 level support to them. Identified database issues through careful collaboration with key stakeholders. Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions. End to End Database Administration Activities and providing support and solutions for Issues/Problems. Performing Performance tuning, Query Optimization, Capacity Planning, Performance and Utilization Monitoring and schema, Index Optimization for environment running in Mysql 8.x databases. Currently Managing 45TB plus Mysql environment in sharded cluster set. Performed Standard Administration task in variety of Mysql environments Upgrades, deployments disaster recovery configurations.
Senior Database Administrator at Friday Media Group, Jan 2020 - Feb 2021 · 1 yr 2 mos, Bangalore, --Doing performance audit on Friday Media Group MySQL/Mongo and MSSQL infrastructure to identify the performance bottlenecks, suboptimal OS/MySQL configuration and queries need optimization. Optimizing slow queries and recommending the optimal configuration for OS, MySQL, Replication, High Availability, Backups, Galera Cluster etc. -- Doing Solr Search Platform Administration and performance audit. --- Troubleshooting performance related issues and providing recommendations to optimize MySQL server performance. Working closely with developers and answering their queries in real time via team meetings and JIRA tickets. -- Implementation of HA Solution such as Mongo replica-set with shards and 3 node Galera cluster setup for FMG databases. -- Database upgrade planning and Performing Major and Minor MySQL server version upgrade. --Working on Routine consulting cases to answer IT/DEV queries related to MySQL Performance, Galera Cluster, Backup, Replication, HA etc via email. --Maintaining documentation and sending summary of work done to In-line Managers and Operations Managers. -- Research on Opensource tools and Technologies and Implementation within FMG.
Database Administrator at Friday Media Group, Jan 2018 - Dec 2019 · 2 yrs, Bangalore, --Ensure availability of RDBMS such as (Mysql-Percona/Mariadb/ MSSQL and NoSQL Mongodb databases implemented across the Friday Media Group on on primise and cloud environments. --Ensure availability and performence of Friday Media Group Search Platform within Apache SOlr Master/Slave and Solr-cloud setup. --Ensure that all automated and scheduled tasks complete successfully --Implement, document and monitor appropriate backup and restore verification procedures --Proactively monitor database and Solr Search servers for faults and decreases in performance, highlighting query or database inefficiencies to product owners, development and operations staff as necessary --Make recommendation of software patches and upgrades as they become available --Ensure that data integrity and security is maintained at all times --Translate user requirements into an appropriate report or data export/feed as required --Produce and maintain documentation about databases and disaster recovery procedures --Administer changes to production and development database servers and databases as required --Monitor and produce reporting on data growth in line with group data strategy. --Implement data archive scripts as required in line with group data strategy --Be an escalation point for IT in troubleshooting database server issues and Database Technology implementations.
Senior Database Administrator at UNICEL Technologies Pvt. Ltd (An Mgage India Company), Nov 2014 - Dec 2017 · 3 yrs 2 mos, --Responsible for RDBMS database administration for Mysql and Postgres databases Servers across Production/Stage/DEV/QA environments. --Responsible for NOSQL Mongodb administration across Production/Stage/DEV/QA environments. --Writing queries for Reports/Charts generation used for various ETL activities. --Real time database server monitoring and reviewing server logs. --Optimizing and tuning of ineffecient queries and Re-writing the queries for a faster response based on optimizer and algorithms. --Writing bash scripts to monitor the database server and automate various tasks --Tuning and optimizing the performance of Datbase server and queries. --Processing database related requests which includes, Tables sync, Table creation & alteration, query creation, data restoration from backup, data import from csv etc. --Performing maintenance for INNODB/MyISAM tables. --Partition Managament for INNODB/MyISAM tables. --Installation and configuration of MySQL/PostgreSQL and MongoDB datbase servers. --Establish and maintain sound backup and recovery policies and procedures. --Working on various Backup and recovery tools for MySQL ( including Xtrabackup ) --Take care of the Database design and implementation. --MySQL replication and Architecture Design for HA solutions. --Table Maintenance, Index management and optimization . --Automating database management though shell/Perl scripting. --Benchmarking the MySQL/Postgres servers for various performance testing. --Implement and maintain database security (create and maintain users and roles, assign privileges). --Datbase Migration Activities with Pentaho ETL across Varisous RDBMS. --Setup and maintain documentation and standards. --Plan growth and changes (capacity planning). --Work as part of a team and provide 7×24 Production supports. --Do general technical trouble shooting and give consultation to development/operation and IT teams.
Senior Engineer (IT Application and Systems Support) at UNICEL Technologies Pvt. Ltd (An Mgage India Company), Jul 2011 - Oct 2014 · 3 yrs 4 mos, Bangalore, 1.Team handling and providing Tier-2 /Tier-3 technical support for clients on Bulk Messaging Services and Products for issues and requests with in specified SLA. 2. Fetching and Maintaining different logs Reports from different DB servers depending on request from clients. 3.Designing comprehensive SQL queries to retrieve data from different DB servers. 4.Functional testing support to technology team for new patches. 5.Maintenance of some scripts of Perl, for the testing purpose and to generate some automated report. 6.Fetching, inserting, updating data from server as per client’s requirement, using mysql, pgsql and Phpadmin & mysqladmin tool. 7.Troubleshooting SMPP and HTTP connectivity issue. 8.Managing the SMSC servers to ensure its up and running. 9.Monitoring, troubleshooting, maintaining applications, Through dashboards and na-gios systems. 10.Export/Import of Tables, Users and Databases. 11.Troubleshooting issues on permissions, SSH, FTP, HTTP, HTTPS, SMTP,POP3. 12.Analyze various Kennal logs during communication test with SMSC(Simple messages switching center ) also Testing logs for different component like Reader ,consumer,producer in MT(Messages Termination) as well as Reader and Processor logs testing in Email2SMS. 13. SMPP Gateway setup for Message Processing. 14.To work on CRM and to ensure proper documentation of total cases created. 15.Communicate and work closely with Technology team members to follow-up and troubleshoot the client issues for Product and Services. 16.Communicate and work closely with team members to assist and troubleshoot. 17.Direct SMSC Vender/Operator Communication (Verbal and Written) for Domestic and International message Processing as aggregate. 18.Handling ON-Call escalations in and after working hours. 19.The account management, Creating the accounts for the clients from the back end and through ERP tool. 20.Providing On-call Demo on Services to New Clients and Helping sales team in Understanding Product Functionality.
Bachelor of Engineering (BE), Information Technology, RGPV Bhopal