Security Service

Ajinkya Abhay Deshpande

Contact: 952-***-****

Email: adgr03@r.postjobfree.com

Professional Objective

An experienced IT professional having database skills across MSSQL Server with more than 4 years and 9 months of professional experience and seeking a challenging career in the area of database administration. A committed team player, self motivated with the ability to communicate at all levels.

Professional Summary

•Having 4 Years and 9 months of Experience in SQL Server Database Administration.

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

•Expertise in backup/recovery, installation, configuration, troubleshooting.

•Implemented and Troubleshooting DR plan Log-Shipping, Database Mirroring, Replication.

•Handled various issues on Performance Tuning including Index optimization, Database and Server optimization.

•Worked on patching, upgrade and migration.

•Managing Security (Creating users, logins and roles, granting permissions).

•Experience in performance tuning and maintenance with outstanding troubleshooting capabilities.

•Have experience of ticketing tool Service Now (SNow)

Professional Experience

•Jr. DBA in Redwing Infotech, Pune from June’15 to July’16

•SQL DBA in Atidiv, Pune from August’16 to March’19.

•SQL DBA in Accenture, Pune from August'19 to June''20

Educational Qualification

•Completed Graduation from Pune University.

•Completed HSC from CBSE Board.

•Completed SSC from Garware Highschool, Pune (MSBSHSE)

Technical Skills

•Operating Systems : Windows server 2003/2008 /2012/ 2016

•SQL Versions : MS SQL Server 2012 / 2014 / 2016 / 2017

•SQL Server Tools : SSMS, SQL Profiler & DTA

Roles and Responsibilities

•Installation : SQL Server 2012, 2014, 2016 and 2017.

•Daily activities include monitoring Database, checking error logs and windows event viewer, checking the log file size, CPU usage issues caused by SQL and free space in the data drives.

•Monitoring the status of the tickets assigned to the group and myself.

•Expertise in backup/recovery, Performance Tuning, DR plan monitoring.

•Configuration Log-shipping, Mirroring, replication.

•Managing Security (Creating users, logins and roles, granting permissions).

•Creating Maintenance plans, monitoring, setting alerts and notifications for any issue.

•Experienced in resolving timeouts regularly.

•Have experience of ticketing tool Snow (Service Now).

•Handling blocking and Deadlock issues by troubleshooting accordingly.

•Monitoring/Maintaining Replication and Mirroring being used in servers.

•Keeping track of all critical databases & server related information in Excel sheet.

•Monitored SQL Server Logs, OS Logs for troubleshooting the Issue.

•Creation of index, dropping unused and duplicate indexes, identifying the Index Fragmentation, Managing Index Fragmentation, Managing Statistics.

•Replication [Configuring replication, on adock request adding or removing the articles]

•Also have worked on Migration and server upgrade.

•Experienced in In-place as well as side by side migration.

PERSONAL INFORMATION

•Name : Ajinkya Abhay Deshpande

•Permanent Address : M-16/467, MIG Colony, Ekatanagar, Gokhalenagar, Pune-16

•Mobile No : 952 - 727 - 6842

•Date of Birth : 15th February 1992.

•Sex : Male

•Languages Known : Marathi, English, Hindi.

•Marital status : Unmarried.

Yours Faithfully,

Ajinkya Abhay Deshpande

Contact this candidate