Sql Server Service

*

DEEPAK G

Email : adb52b@r.postjobfree.com

Mobile : +91-703*******

EXECUTIVE SUMMARY

A professional with technical skills across different versions of MS SQL Server from 2012 to 2016. Having overall five years of extensive work experience in managing large-scale databases in development, Test and production support environment on windows platforms. CAREER SUMMARY

− Extensive DBA experience in supporting SQL Servers on a 24x7 production environment.

− Experience in Installation and configuring SQL Server 2016, 2014 & 2012 along with applying Service packs and Hot Fixes.

− Worked on upgrading SQL Server from version 2014 to 2016 along with Data Migration Management.

− Experience in Database backup and disaster recovery procedures.

− SQL Server Performance monitoring and tuning.

− Creating Server and Database users, roles and assigning permissions.

− Experience in working with SolarWinds Monitoring tool.

− Hands on Experience in working with Always On-HA DR Solution.

− Knowledge on Replication, Log Shipping, Clustering and Mirroring.

− Involved in critical DB Deployment and deployed SSIS Packages in SQL server.

− Worked on PowerShell script to automate the SQL HC Reports.

− Involved in Document preparation for procedures.

− Worked on Site Hosting for .Net Applications.

− Creating/Renewing SSL Certificates for .Net Applications on the servers.

− Knowledge on Load Balancing concepts on managing application traffic using internal tool called Album.

− Involved in CICD Implementation on our Environment.

− Hands on experience in working with Jenkins automation server.

− Maintaining Windows servers and solving issues related to it.

− Performing monthly Windows Patching and ensure security Compliance. TECHINICAL SKILLS

Platforms: Windows 2008/2012 R2 Server

Technology: SQL Server database administration

Databases: SQL Server 2012/2014/2016

Language: T-SQL

Web Servers: IIS 7/8

CICD: Jenkins

2

ORGANIZATIONAL EXPERIENCE:

Company: Cognizant Technology Solutions

Current Role: Tech Lead

Duration: Oct 2014 to till Date

PROJECT EXPERIENCE:

Client: Comcast (Sep 2016 to till Date)

Industry: Communications.

Responsibilities:

− Provide 24*7 Production support as well as on call support for SQL server Databases.

− Installation and configuring SQL Server 2016, 2014 & 2012 along with applying Service packs and Hot Fixes.

− Involved in upgrading SQL Server from version 2014 to 2016 and Data Migration management.

− Migrating Logins and fixing the orphaned users.

− Database backup and restore for development/testing.

− SQL Server Performance monitoring and tuning.

− Creating Server and Database users, roles and assigning permissions.

− Maintaining HADR solution such as SQL Server Always On and troubleshooting issues related to it.

− SQL server/database changes through standard/emergency release deployments.

− Pre and Post work for Rebooting production SQL Servers.

− Resolving Disk Space, CPU and Memory Alerts for SQL Servers.

− Involved in hosting .Net Applications using IIS.

− Creating/Renewing SSL Certificates for .Net Applications on the servers.

− Involved in implementing CICD workflow using Jenkins.

− Worked on installing and configuring Jenkins automation server.

− Worked on creating Jenkins jobs for continuous deployment.

− Monitoring and Solving issues related to Windows Servers.

− Performing monthly Windows Patching and ensure security Compliance. Client: Mylan (Oct 2014 to Sep 2016)

Industry: Health Sciences

Responsibilities:

− Handling incidents and changes (Incident Management & Change management) in Service Now.

− Recovering the databases from backup in disasters using NetBackup tool. 3

− Creating Maintenance Plans for taking planned backups, updating statistics, Rebuilding & Reorganizing Indexes.

− Implementation of SQL Logins, Roles and Authentication Modes as a part of security policies for various categories of user support.

− Monitoring and troubleshooting of failed and long running MS SQL Server jobs.

− Applying Hot fixes and Service packs.

− Involved in database refresh from production to development and test systems.

− Involved in Document preparation for procedures. CERTIFICATIONS

− Administering a SQL Database Infrastructure (Exam 70-764) ACADEMIC PROFILE

− Bachelor of Engineering (Mechanical) from Adhiyamaan College of Engineering with CGPA of 8.38 (2009-2013)

− HSC from Don Bosco Matriculation Hr. Sec School with 75.83% -2009

− SSLC from Don Bosco Matriculation Hr. Sec School with 76.27% -2007 PERSONAL DETAILS

Date of Birth : 14 Dec 1991

Permanent Address : 145, Sri Ragavendira Nagar, Tirupattur, Vellore Dt, Tamil Nadu Contact Number : +91 - 703*******

Email Id : adb52b@r.postjobfree.com

Sincerely,

(Deepak G)

Contact this candidate