Sql Server Maintenance

K BOOPATHI

Contact :+** - 887*******

Email :*************@*****.***

SQL SERVER DBA

To take up a challenging career and grows with honesty, loyalty, good relationship and best performance and translate my knowledge, skills coupled with experience to convert organizational goals in to reality. PROFILE

IT Professional with 3 years of experience in SQL Server Administration

Experience in installation, maintenance of different versions of SQL Servers 2016,2014,2012, 2008R2,2008

Experience in Implementing SQL Server Security and Object permissions like maintaining Database Authentication Modes, Creation of Users, Configuring Permissions, and assigning Roles to the Users

Proficient in moving the SQL system and user Database files from one drive to other Locations.

Good knowledge on Replication like snapshot and transactional

Extensive Experience in Backup Plans and implementing various types of Backups using Database Maintenance Plan

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and Deadlocks

Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation

Responsible for troubleshooting all SQL Server databases issues on Production, QA, and DEV environments

24 X 7 Production Database on Call Support

EDUCATIONAL DETAILS:

Bachelor of Technologies from VSB Engineering college in 2016. PROFESSIONAL EXPERIENCE:

SQL DBA at Sensiple Software solutions Pvt Ltd from November 2016 to till date. TECHNICAL SKILLS & EXPOSURES:

Operating Systems Windows XP/2007/2008/2010. Windows Server 2008/2008 R2/2012. Databases MS SQL Server 2008/2008 R2/2012/2014/2016. SQL Server Key Portions Backup, Restore, Logshipping, Indexing, Mirroring, Always-On, Replication, Clustering

Tools Nagios, Kace, Active Directory, Blackberry, Active Batch Scheduling and Deployment Programming

PROJECT DEATIALS:

Company Name : Sensiple Software solutions

Client Name : Alternate Investment and Hedge fund company Joining Date : February 2018

Worked Up to : Till date

Designation Held : SQL Database Administrator

My responsibilities include:

SQL Server 2012, 2008R2, 2008 installations slip stream installation, Applying service packs and Cumulative updates.

Solved space issues like Temp DB full and log file full.

Handling Data Refresh activities as requested by Application teams.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Configured Database Mail in SQL Server 2012/2008 R2/2008.

Creation and Scheduling of Maintenance Plans of Database and Log backups and Index Maintenance jobs.

Identifying issues with the database and resolving them

Interacting with client on daily basis for status reporting purposes.

On-Call responsibilities for Production database systems.

Troubleshooting backup failures

Environment: MS SQL Server 2014/2012/2008R2 /2008 PROJECT DEATIALS:

Company Name : Sensiple Software solutions

Client Name : Language Line Solutions

Joining Date : February 2017

Worked Up to : February 2018

Designation Held : SQL Database Administrator

My responsibilities include:

Resolving all DB related external and internal Production & non-Production incident within SLA.

Monitoring Disk Space of all the Servers and freezing up space as per SQL Server.

Troubleshooting connectivity issue raised by Application users.

Checking daily backups full, differential and T-Log within first few hours of failure.

Installing and Configuration of SQL Server R2, 2012 and 2014.

Creating and Scheduling Maintenance related jobs to automated tasks. Personal Skills:

Good communication skills.

Positive thinking.

Interested in Teamwork.

Willingness to learn new skills.

Declaration:

I hereby declare that the above furnished details are true to the best of my knowledge and belief.

[K.Boopathi]

Contact this candidate