Akash Ambalal Patil

Pune

Summary

Having 6+ Years of Experience in SQL Server Database Administration.

Installation and configuration of MS SQL Server 2019,2017,2016, 2014, 2012, 2008 on remote systems.

Worked on Migration project

Handled troubleshooting production issues and on call support.

Log-Shipping, Database Mirroring, Replication, and
Always ON.

Hands-on experience in Performance Tuning like resolving locks deadlocks, handling performance issues like CPU, I/O, Memory pressure counters.

Worked on Patching.

Daily health check-up activities include monitoring databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases.

Experienced in resolving Blockings and Deadlock Issues by using SQL commands.

Worked on Index, Missing index, and Fragmentation.

Overview

years of professional experience

Work History

Sr System Engineer

ALTERA PVT LMT

- Current

Managed major incidents, problem tickets, and change requests to achieve timely resolutions, reducing business impact.
Utilized monitoring tools like AppDynamics, Grafana, and Splunk to identify and address performance bottlenecks proactively.
Monitored, investigated, and escalated application infrastructure and database issues, providing root cause analysis post-incident.
Applied technical skills to automate daily support functions, enhancing system stability and efficiency.
Gained experience with Azure cloud platform, deploying and managing applications in cloud environments.
Integrated business intelligence tools such as AppDynamics and Power BI into infrastructure and database improvement projects to enhance data visibility.
Leveraged SQL queries, stored procedures, and functions to generate performance reports for database instances.
Installed AppDynamics machine agent on client environments using PowerShell scripts.
Pro‑Active Alert Analysis: Identified common bottlenecks in the Database servers using App Dynamic Tool report and recommending changes to the development team to work on resolution in next release.
Recommended/Work Alert Strategies for different sites as per the time zone and reducing noise from the system.
Major Incident Analysis: Analyzing the Major incidents and finding the RCA to minimize the client impact if the issue re-occurs.
Working with client and different teams to come up with different disaster recovery strategies in case of application/infrastructure failure.
Identified common bottlenecks for multiple client servers through alerts, worked with development team for permanent resolution which resulted in performance improvement of servers and reduction in alerts by 25%.
Identified Stored procedure performance issues and worked with the Database engineers to provide a code fix which improved the overall performance of the application and the server during the peak hours by almost 10%.
Wrote an overall performance health checkup query for the SQL server which identifies issues with the database and alerts the user for active violations.
Worked with management and support teams to re‑design the incident escalation process and implemented different techniques to improve the response time of the teams. New process helped the teams to identify and escalate the issues to the appropriate queue.

Database Administrator

REDWING INFOTECH

Pune

06.2018 - 11.2021

Installation and configuration of SQL Server 2012, 2014, 2016, 2017 and 2019.
Performing Database maintenance activities like Backups, Restoring.
Monitored servers regularly, including backup job monitoring and troubleshooting issues.
Maintained database security by assigning specific responsibilities within the security framework.
Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
Handling blocking and Deadlock issues and troubleshooting accordingly.
DR: Log Shipping, Replication and Mirroring.
Keeping the track of all critical databases & server related information in Excel sheet.
Managed storage, archiving, backup and recovery procedures to ensure proper functioning of transaction log files.
Worked with team for Upgrade and Migration activity.
Configuring and deploying SSIS packages and SSRS reports.
Provided 24*7 Production support for the database and application issues.
Analyzed event logs to identify and investigate issues, implementing changes in production servers to enhance system performance.

Education

Master of Science - Computer Science

University of Pune

Skills

SQL: SSRS/SSAS/SSIS
Stored procedures
Database Performance Tuning
Application Performance Monitoring
Azure Cloud Platform
Logic Monitor

Open Grafana
App Dynamics
Troubleshooting and analysis
Infrastructure Improvement
Major Incident Handling

Profile

Dynamic and result oriented MSSQL DB with over 6 years of experience in database management and optimization. Skilled in implementing and maintaining complex database systems to ensure optimal performance and reliability. Proven ability to troubleshoot and resolve database issue efficiently, enhancing overall system functionality. Strong team play, adept at collaborating with cross-functional teams to achieve project goals and deliver high-quality solutions.

Languages

English
Marathi
Hindi

Personal Information

Date of Birth: 05/08/1996
Gender: Male
Nationality: Indian

Timeline