Summary
Overview
Work History
Education
Skills
Work Preference
Timeline
PRASHANT JADHAV

PRASHANT JADHAV

Pune

Summary

Senior Database Administrator with almost 6 years of experience mainly in MongoDB, MySQL and level 1 PostgreSQL. Extensive experience with good working knowledge of banking and healthcare, troubleshooting and implementing database solutions in Prod/Dev/Stg env and experience in designing high availability and disaster recovery solutions. Quickly learn, adapt and adapt to new environments and technologies.

Overview

6
6
years of professional experience

Work History

Senior Lead DBA

LENTRA AI PUNE
07.2023 - Current
  • Led a team of database administrators in managing MongoDB and MySQL database environments, ensuring high availability, scalability, and performance
  • Designed and implemented database solutions to meet the organization's requirements, including database schema design, indexing strategies, and query optimization
  • Implemented and maintained database security policies and procedures, including access controls, and auditing, to ensure data integrity and compliance with regulatory requirements
  • Oversaw database backups, disaster recovery planning, and performance monitoring to minimize downtime and ensure data availability
  • Provided technical guidance and mentorship to junior database administrators, fostering their professional development and enhancing the team's capabilities
  • Collaborated with Application developers, system administrators, and other stakeholders to troubleshoot database-related issues and optimize application performance
  • Evaluated new technologies and tools to enhance database management capabilities and drive continuous improvement initiatives.

Senior DBA

LENTRA AI PUNE
08.2022 - 07.2023
  • Replication cluster separation, data purging, Database upgrade and patch upgradation
  • Extended assistance for the application's release and Preparation of documentation for activities such as SOP and POA
  • Data extraction as per the client request and data Archival
  • Provided on-call support and responded to database-related incidents, ensuring timely resolution and minimal impact on business operations
  • MongoDB Replication, DR Failover, switchover and switchback
  • Managed MongoDB database clusters in a high-availability, distributed environment, ensuring optimal performance and reliability
  • Developed and implemented backup and recovery strategies, including automated backups, and disaster recovery procedures, to safeguard critical data
  • Monitored database performance and capacity utilization, identifying and resolving performance bottlenecks and scaling database resources as needed
  • Worked closely with development teams to optimize database queries, indexes, and data models to improve application performance and efficiency.

Database Administrator

TECHBERRY INFOTECH PVT LTD
MUMBAI
11.2019 - 08.2022
  • Managed MySQL,MongoDB and PostgreSQL databases, including installation, configuration, backup, and recovery, to support the organization's business applications
  • Monitored database performance and tuned database parameters to optimize query execution and resource utilization
  • Provided technical support and troubleshooting assistance to resolve database-related issues and ensure uninterrupted service availability
  • 24×7 handling client site technically and operations wise in executing work related to database management
  • Knowledge of JIRA ticketing system for UAT/DB Prod updates and modifications
  • Producing documentation for activities such as SOP and POA.

TECHNICAL ASSOCIATE

CLOVER INFOTECH PVT LTD
MUMBAI
02.2019 - 11.2019
  • Installation & configuration of MySQL server and daily monitoring reports
  • Backup & Restoration of MySQL Databases
  • Configure alert script i.e., backup alert, replication alert, max connection alert, low space alert
  • Purging activity for MySQL as well as MongoDB
  • Experience with Configuration of MySQL Replication setup (Master to Slave replication
  • Master to Master Replication, chain Replication)
  • DR drill activity configured reverse replication
  • Database optimization
  • Provide 24
  • 7 client support.

Application support Engineer

Creative IT Inida
MUMBAI
08.2018 - 02.2019
  • Installation of MS SQL and application
  • Backup and restore
  • Provide product training to customer
  • Solving customer queries remotely
  • Patch update, Database creation for new clients
  • Monitoring of all DB servers as well as application server.

Education

BE - undefined

University of Mumbai
August 2017

Skills

  • SKILL SET
  • Database: MongoDB, MySQL and L1 PostgreSQL
  • Tools:
  • Workbench, Putty,Zabbix,Ops manager,JIRA
  • OS: Linux ,Windows
  • HIGHLIGHTS
  • Database migration from on prim to AWS EC2
  • Logical database separation and unwanted database deletion after data
  • Separtation
  • Database Design and Optimization
  • High Availability and Disaster Recovery
  • Performance Tuning and Monitoring
  • Scripting and Automation
  • Team Leadership and Mentoring
  • Problem-solving and Troubleshooting
  • Database Schemas
  • Database Locking
  • Patch Management
  • Database Optimization
  • Database Analysis
  • Data Conversion and Migration
  • Database Cloning
  • Linux Operating System
  • Database Modification
  • User Management

Work Preference

Work Type

Full Time

Timeline

Senior Lead DBA - LENTRA AI PUNE
07.2023 - Current
Senior DBA - LENTRA AI PUNE
08.2022 - 07.2023
Database Administrator - TECHBERRY INFOTECH PVT LTD
11.2019 - 08.2022
TECHNICAL ASSOCIATE - CLOVER INFOTECH PVT LTD
02.2019 - 11.2019
Application support Engineer - Creative IT Inida
08.2018 - 02.2019
University of Mumbai - BE,
PRASHANT JADHAV