Abhilash Naik
Database Reliability Engineer
Pune,Maharashtra
Summary
Database Reliability Engineer with 4+ years of hands-on experience administering MongoDB replica sets, PostgreSQL streaming replication, and MySQL across production, staging, and DR environments on AWS and on-premises. Proven record of zero-downtime upgrades, automated backup pipelines to S3, and performance tuning through index optimization and execution plan analysis. Proficient with observability tooling (Prometheus, Grafana, PMM, New Relic) and infrastructure automation (Terraform, Ansible, Docker, Kubernetes). Banking domain background providing strong understanding of data security, RBAC compliance, and audit requirements.
Overview
9
9
years of professional experience
Work History
DBA Consultant
Digital Convergence Technologies Inc.
10.2025 - Current
- Administered and maintained MongoDB, MySQL, and PostgreSQL across production, staging, and DR environments; managed replica sets, MySQL replication, and PostgreSQL streaming + logical replication.
- Resolved replication lag and failover incidents; planned and executed zero-downtime database version upgrades and migrations.
- Designed and operated backup/recovery pipelines using XtraBackup, PBM, pg_dump, pg_basebackup, mongodump, and S3-compatible storage.
- Performed deep performance tuning via query analysis, index optimization, execution plan review, and resource utilization profiling using PMM, New Relic, Prometheus/Grafana, mongostat, mongotop, htop, iostat, vmstat.
- Managed database security: user provisioning, role definitions, privileges, and access controls across all database platforms.
- Collaborated with application and DevOps teams on schema design, query optimization, and release support; automated routine DBA tasks via shell scripts and cron jobs.
- Delivered 24/7 production support: triaged and resolved high CPU, memory pressure, disk I/O bottlenecks, lock contention, and long-running queries; produced operational runbooks and incident documentation.
- Conducted capacity planning, storage forecasting, and performance baselining to support infrastructure scaling decisions.
Database Administrator (PDA)
Venwiz Technologies
07.2021 - 08.2025
- Administered MongoDB and PostgreSQL replica sets with secure RBAC, TLS authentication, and access control aligned to security best practices.
- Deployed standalone MongoDB servers and replica sets on AWS Cloud and on-premises; managed full lifecycle from provisioning to upgrades and patch application.
- Built and maintained data backup and recovery workflows using mongodump, mongorestore, PBM, and pg_basebackup, ensuring business continuity.
- Monitored database health and performance with Prometheus and Grafana dashboards; implemented query optimization to reduce latency across production workloads.
- Utilized MongoDB utilities (mongoimport, mongoexport, mongodump, mongorestore, mongotop, mongostat) for migrations, data management, and capacity reporting.
Operation Engineer
CMS Infosys Ltd.
02.2019 - 05.2020
- Executed secure server-to-server data transfers via WinSCP; applied encryption protocols for data privacy during processing and archiving.
- Resolved data handling issues and ensured error-free transactions in production environments.
Customer Service Associate
Quess Corp Ltd.
07.2018 - 01.2019
- Handled banking customer queries on loans, payments, and credit cards using Finacle CRM; managed service requests and maintained client communication logs.
Graduate Engineer Trainee
Demech Chemical Private Ltd.
11.2016 - 09.2017
Education
Bachelor of Engineering - Production Engineering
01.2016
Diploma - Mechanical Engineering
01.2013
Skills
- MongoDB
- PostgreSQL
- MySQL
- Oracle DB
- RDS
- Replica Set Management
- Replication Lag & Failover
- Version Upgrades
- Security Patching
- Query Optimization
- Index Analysis
- Execution Plans
- RBAC & Access Control
- Backup & Recovery
- Capacity Planning
- MQL
- SQL
- Shell Scripting
- Bash
- Python
- Prometheus
- Grafana
- PMM
- New Relic
- Site24x7
- MongoDB Compass
- Mongostat
- Mongotop
- Htop
- Iostat
- Vmstat
- AWS
- EC2
- S3
- EBS
- DynamoDB
- Linode
- Terraform
- Ansible
- Packer
- Docker
- Kubernetes
- Jenkins
- Git
- GitHub
- Jira
- Slack
- Linux
- Mongodump/restore
- PBM
- Xtrabackup for MySQL
- Running backups
Languages
English
Hindi
Marathi
Credley
Credley
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
- CKA Training - Jan 2026 to March 2026
Timeline
DBA Consultant - Digital Convergence Technologies Inc.
10.2025 - Current
Database Administrator (PDA) - Venwiz Technologies
07.2021 - 08.2025
Operation Engineer - CMS Infosys Ltd.
02.2019 - 05.2020
Customer Service Associate - Quess Corp Ltd.
07.2018 - 01.2019
Graduate Engineer Trainee - Demech Chemical Private Ltd.
11.2016 - 09.2017
Savitribai Phule Pune University - Bachelor of Engineering, Production Engineering
MSBTE - Diploma, Mechanical Engineering