Summary
Overview
Work History
Education
Skills
Timeline
Generic
Vaibhav Wadatkar

Vaibhav Wadatkar

Pune

Summary

● Worked on SQL Database Administration of MS SQL Servers 2008/2012 /2014/2016/2017/2019.

● Having 6+ years of experience, which includes SQL server installation and troubleshooting, monitoring, configuring and managing.

● Expertise in backup & recovery, migration of database, upgrade, maintenance of SQL production database.

● Good experience and knowledge of high availability SQL Server solutions, including Log shipping, Database Mirroring, Always on, Replication.

● Handling Disk Space related issues and worked upon Disk Space optimization in the environment.

● Performed changes to move the data and log files on separate drive, this was useful in segregation the application data from SQL data adhering the best practices.

● Work as part of a team and provide 24×7 supports when required.

Overview

7
7
years of professional experience

Work History

Infosys

SQL DBA (Consultant)
Pune
04.2024 - Current
  • Work on tickets, service requests, and scheduled changes.
  • Attend daily calls, weekly CABs, and client ad-hoc calls.
  • Running and validating health checks and backup reports for around 225 servers and 1500+ databases, including production, non-prod, test, and stage servers
  • Handling backup and restore requests, ensuring thorough pre-checks and post-checks for SQL restoration
  • Managing database migrations, upgrades, and maintenance while prioritizing pre-checks and collaborating with backup, Windows, and storage teams
  • Addressing disk space issues and optimizing disk space by moving application-related files to separate drives
  • Conducting AG DR activities
  • Installing new SQL Servers
  • Applying service and security patches for compliance and performance optimization.

Persistent Systems

SQL DBA (Engineering Lead)
Pune
04.2022 - 04.2024
  • Managing daily DBA tasks: handling database tickets, service requests, and project tasks to ensure smooth operations
  • Running and validating health checks and backup reports for around 150 servers and 1000+ databases, including production, non-prod, test, and stage servers
  • Handling backup and restore requests, ensuring thorough pre-checks and post-checks for SQL restoration
  • Managing database migrations, upgrades, and maintenance while prioritizing pre-checks and collaborating with backup, Windows, and storage teams
  • Addressing disk space issues and optimizing disk space by moving application-related files to separate drives
  • Segregating data and log files to separate drives to adhere to best practices
  • Working on new SQL installation projects, validating pre-checks, and implementing best practices to optimize SQL Server performance
  • Applying service and security patches for compliance and performance optimization
  • Monitoring and resolving issues related to database locks, blockings, and deadlocks
  • Proficient in high availability SQL Server solutions, including Log Shipping, Database Mirroring, Always-On AG, and Replication
  • Regularly reviewing SQL Server error logs to identify and address potential issues
  • Analyzing trends in repetitive tickets to devise permanent solutions for enhanced efficiency
  • Escalating critical SQL issues to Microsoft for timely resolution and minimal disruption
  • Participating in CAB, DSR, and OPMC meetings to discuss and get approval for changes and activities for the upcoming week.

Capgemini

SQL DBA (Associate Consultant)
Mumbai
05.2017 - 04.2022
  • Checking backup status, SQL job failure status, and troubleshooting to ensure successful next schedules
  • Managing daily DBA tasks: handling database tickets, service requests, project tasks, and ad-hoc requests
  • Managing database migrations, upgrades, and maintenance while prioritizing pre-checks and collaborating with backup, Windows, and storage teams
  • Addressing disk space issues and optimizing disk space by moving application-related files to separate drives
  • Configuring standard backup policies according to the size of SQL databases for efficient data protection and recovery
  • Building and troubleshooting CMS (Central Management Server) to ensure smooth SQL Server management and administration
  • Regularly reviewing SQL Server error logs to identify and address potential issues
  • Applying service packs and security patches to maintain SQL Server health and address vulnerabilities
  • Checking daily backups (full, differential, and T-log) to ensure data integrity and availability
  • Engaging in innovative activities like configuring TEMPDB files and performing maintenance to optimize SQL database performance
  • Configuring standard backup policies according to the size of SQL databases for efficient data protection and recovery.

Education

B.E in EXTC -

P. R. Pote Patil College of Engineering
Amravati
08-2016

Skills

  • Domain: Banking, Insurance, Production
  • Database Platform: Microsoft SQL Server 2008/2012/2014/2016/2017/2019
  • Tools: SQL Server Management Studio,SQL Server Profiler,SQL Server Configuration Manager,Database Engine Tuning Advisor (DTA),Extended Events,Query Store,DB Mail
  • High Availability Solutions: Always On Availability Groups,Database Mirroring,Log Shipping,Replication
  • ITIL Tools: Tivoli integrated with BMC Remedy,Confluence,Jira,OpsGenie,Citrix,SolarWinds DPA,AWS S3,SNOW,PAM,VDI

Timeline

Infosys

SQL DBA (Consultant)
04.2024 - Current

Persistent Systems

SQL DBA (Engineering Lead)
04.2022 - 04.2024

Capgemini

SQL DBA (Associate Consultant)
05.2017 - 04.2022

B.E in EXTC -

P. R. Pote Patil College of Engineering

Similar Profiles

  • Ahmed Elhenawy

    Ahmed ElhenawyAhmed Elhenawy

    Consultant at ConsultantConsultant at Consultant

    View Profile
  • MAXIMOS TRIFYLLIS

    MAXIMOS TRIFYLLISMAXIMOS TRIFYLLIS

    Real Estate at ConsultantReal Estate at Consultant

    View Profile
  • ANNA KRAMER

    ANNA KRAMERANNA KRAMER

    Consultant at ConsultantConsultant at Consultant

    View Profile
Vaibhav Wadatkar