Yogesh Jagdale
Mumbai
Summary
Experienced and results-driven Database Administrator (DBA) with nine years of expertise in database management, migration, and optimization. Specializing in Oracle and MS SQL database migration, performance tuning, backup/recovery, and troubleshooting.
Proficient in ensuring database integrity, security, and scalability for mission-critical applications across various platforms. Adept at providing high-level strategic solutions to enhance database performance and reliability.
Multi-tasking consultant, well-known for successfully taking projects from beginning stages to completion. Polished and professional, offering proficiency in database migration from on-premises to cloud.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Consultant
T-systems ICT India Pvt ltd
Pune
09.2021 - Current
- Understanding the architecture and design of on-premises databases before designing a database migration action plan.
- Analyze on-premise transactional database environments, such as Oracle, SQL Server, and PostgreSQL, and evaluate and plan migrations to AWS/Azure.
- Design, implement, and manage high-availability and disaster recovery solutions (Always On Availability Groups, Oracle Data Guard).
- Perform database tuning and optimization for both MS SQL and Oracle databases, resulting in an increase in query performance.
- Database minor/major version upgrade for relational databases on on-premises/AWS RDS.
- Collaborate with development teams to design and optimize database schemas, ensuring they meet application requirements and best practices.
- Perform database maintenance tasks such as rebuilding indexes and gathering statistics to improve database performance.
- Perform user management and maintain database security (create and maintain users, roles, and assign privileges).
- Regularly review and update backup and recovery procedures, performing periodic disaster recovery drills.
- Database migration to the AWS and Azure cloud using AWS SCT, DMAF, Azure Database Migration Assistant tool, Azure Data Studio, and DMS services.
Senior Cloud Engineer
Blazeclan Technologies Pvt Ltd
Pune
02.2019 - 09.2021
- Review existing systems and make recommendations for database improvements.
- Work with a cloud architect to generate assessments, and develop and implement actionable recommendations based on results and reviews.
- Extensively working with cloud-based database environments, preferably AWS or Azure cloud.
- Perform a database refresh from Prod to all Non-prod environments using datapump as per the client's requirement.
- Proposed database changes to ease plan maintenance activities, such as gathering stats, index rebuilding, fragmentation, job creation, and scheduling for production databases.
- Generate execution plan for slow, resource-consuming queries, and provide detailed analysis for missing indexes to improve the query cost.
- Conducted database backups and restorations using native tools (SQL Server Backup, RMAN), and managed disaster recovery procedures for both MS SQL Server and Oracle environments.
- Monitored and resolved issues related to database connectivity, performance, and security vulnerabilities.
- Estimate the growth of the database size by detailed analysis of the company's future policies and generating reports for management to act in advance.
Database Administrator
IT Source Technologies Pvt ltd
Mumbai
10.2018 - 02.2019
- Provide resources and skill sets to support DBA functions for applications.
- 24/7 production database administration support.
- Generating AWR and ASH reports, weekly DB growth report, archival generation report, and daily and weekly performance report for the database server.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Built databases and table structures for web applications.
- Database Management - Backup, Recovery, Configuration of Database, Tablespace Administration, User Management, and Index Management.
- Daily health check-up of the production database.
Junior Database Trainee
Argus Technologies Pvt ltd
Mumbai
07.2016 - 05.2017
- Installation, creation of the database as per the project requirements.
- Create objects as per the application user's requirements.
- Check for blocking sessions on production databases.
- Perform database administration tasks, like user management and tablespace management.
- Check the alert log for database errors.
- Release deployment to all environments.
- Supported routine database maintenance tasks, including backups, restores, and data integrity checks.
- Assisted in troubleshooting issues such as deadlocks, slow-running queries, and replication failures.
Education
Bachelor of Engineering - Mumbai
Thadomal Shahani Engineering College
Mumbai06.2015
Skills
- Cloud database technologies (AWS RDS, Azure SQL Database)
- Database migration (Oracle and MS SQL)
- Database administration (Oracle, MS SQL)
- Backup and recovery strategies
- High availability and disaster recovery (HA/DR)
- Performance tuning
- Database security management
- AWS SCT, DMA, Azure Data Studio
Certification
- AWS Solution Architect Associate
- ITIL Foundation 4
- Microsoft AZ-900
Languages
- English
- Hindi
- Marathi
Personal Information
Title: Senior Database Consultant
Languages
Marathi
First Language
Hindi
Proficient (C2)
C2
English
Proficient (C2)
C2
Timeline
Senior Consultant
T-systems ICT India Pvt ltd
09.2021 - Current
Senior Cloud Engineer
Blazeclan Technologies Pvt Ltd
02.2019 - 09.2021
Database Administrator
IT Source Technologies Pvt ltd
10.2018 - 02.2019
Junior Database Trainee
Argus Technologies Pvt ltd
07.2016 - 05.2017
Bachelor of Engineering - Mumbai
Thadomal Shahani Engineering College