Akash Waghmare

• Working on the installation of MS SQL Server 2022, 2019, 2017, 2016, 2014, and 2012.
• Security: Implementation of SQL logins, roles, and authentication modes.
• Hands-on experience in performance tuning and maintenance, with outstanding troubleshooting capabilities.
• Hands-on experience in Unix/Linux command-line options.
• Monitoring and maintenance of production, test, and development environments.
• Troubleshooting and maintaining database high availability solutions in log shipping, mirroring, replication, always on, and clustering.
• Detect and troubleshoot SQL Server-related CPU, memory, I/O, and disk space.
• Daily activities include monitoring databases, checking error logs, log file size, and free space in the data drives, as well as the connectivity of the databases, and so on.
• Regular monitoring of servers, which includes backup job monitoring, and troubleshooting all the issues on a regular basis.
• Scheduling and maintaining routine jobs, alerts, and maintenance plans.
• Keeping track of all critical databases and server-related information in an Excel sheet.
• Monitoring SQL Server logs and OS logs for troubleshooting the issues.
• SQL Server Architecture.
• Troubleshooting database and space management issues to maintain the SQL Server to provide maximum availability.
• Backup and recovery of databases on a daily and weekly basis, and tracking the processes.
• Responsible for ensuring that storage, archiving, backup, and recovery procedures are functioning correctly, and transaction log files.
• Handling requests with the help of the ticketing tool, ServiceNow.
• Experienced in resolving blocking and deadlock issues by using SQL commands.
• Collaborated with the team for upgrades, migrations, and patching activities.

Worked on core problems related to payment processing, focusing on both framework development and business enablement.