M Rajasekhar E- Mail : Rajasekharm097@gmail.

com

Mobile: +91- 9966268094

Profile Summary

• Around 4 years of experience as a MS SQL Server DBA in a Production Environment as a SQL Server
DBA and supporting L1 Support and currently working with Sanvan Software Pvt Ltd India
Bangalore. Primarily working with SQL Server 2022,2019,2017,2016,2014,2012 versions.
• Applying SQL Server patches and security patches.
• Creating and administering the SQL Server Databases like data and log file placements and
managing the growth parameters and database options.
• Verifying and resolving the SQL Server Blocking issues and finding and fixing the root cause
• Resolving the Disk space issues and finding the root cause and permanent fixes.
• Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans.
• Restoring the Databases from Production to test environment and vice versa.
• Experience in User Management activities like adding the user and managing the permissions.
• Experience in Creating and scheduling the jobs and troubleshooting the failed jobs.
• Good Experience in Performance tuning activities like verifying the slow running queries.
Fragmentation and Reindexing the fragmented indexes.
• Experience in tools like Performance Monitor, Profiler, Import and Export wizard and Copy
database wizard.
• Experience in usage of DBCC commands and DMVs for troubleshooting.
• Configuring, monitoring and troubleshooting the TRANSACTION REPLICATION and DR activities.
• Configuring and maintaining and troubleshooting the Database mirroring and also experience in
Mirroring DR activities.
• Configuring and maintaining and troubleshooting the Database Log Shipping and also experience
in Mirroring DR activities.
• Experience with upgrades from SQL Server 2012 to 2016 and 2016 to 2019 and Experience in SQL
Server migration activities.
Educational Details

Completed B.Sc. Computer Science from Sri Krishnadevaraya University in Anantapur 2019.
TECHNICAL SKILLS
 Operating Systems : Windows Family 2008/2012/2016/2019/2022.
Languages : T-SQL
RDBMS : MS SQL Server 2012,2014,2016,2017/2019/2022.
SQL Server Tools : Enterprise Manager, Query Analyzer, SSMS, Profiler and DTA.
Other Tools : SSMS, Service Now, Remedy, JIRA
Professional Summary

▪ Currently working as a DBA in Software Engineer , Bangalore from NOV 2020 to DEC 2024.

Professional Experience

Project 1:

Client : TCS

Team Size : 9
Environment : Sql Server 2008, 2008 R2 and 2012,2016, 2017.
Role : Data Base Administrator.
Duration : Jun 2022 to Dec 2024.

Description: Tenet Healthcare Corporation is a multinational investor-owned healthcare services company based
in Dallas, Texas. Through its brands, subsidiaries, joint ventures, and partnerships, as of June 2015 Tenet operates
nine facilities in the United Kingdom and over 400 outpatient centers in 16 states. Also in the US, Tenet operates
19 "short-stay" surgical hospitals and 83 general acute-care hospitals in 14 states primarily in California, Florida,
Michigan and Texas.

Roles and Responsibilities:

• Installation & Configuration of SQL Server 2008/2008 R2, 2012,2014,2016,2017

• Maintaining of over 90+ servers.
• Continuously monitoring and updating the Backup & Recovery strategy and also monitoring
scheduled jobs of backup and restore procedure for database.
• Performing the DB checklist and Critical server checklist.
• Configuring the backups for all the db's and working for failure backups.
• Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for
various categories of User Support.
• Identifying/resolving fragmentation resulting in improved performance.
• Troubleshooting transaction logs and Temp db when full
• Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication.
• Monitoring SQL Server alerts at regular intervals
• Monitoring SQL Server agent jobs/maintenance plans
• Provided 7 x 24 Production support for the database and application issues.
• Co-coordinating with Development, Test and Support teams for server wide issues.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn
new technologies and undertake challenging tasks.
Project 2:

Client : Horizon Blue Cross Blue Shield

Team Size : 7
Environment : Sql Server 2008/2008 R2, 2012,2014,2016,2017.
Role : Data Base Administrator.
Duration : Nov -2020 to May- 2022

Description: Products and services are provided by Horizon Blue Cross Blue Shield of New Jersey, Horizon
Insurance Company, Horizon Healthcare of New Jersey, Braven Health, and/or Horizon Healthcare Dental, Inc.,
Since 2004, we have aimed to make New Jersey healthier by supporting nonprofit organizations that expand
access to health care. Communications may be issued by Horizon Blue Cross Blue Shield of New Jersey in its
capacity as administrator of programs and provider relations for all its companies.

Roles and Responsibilities:

• Installation & Configuration of SQL Server 2008, 2008 R2 and 2012, 2016, 2017 on Local System and
Remote System.
• Maintaining of over 70+ servers.
• Continuously monitoring and updating the Backup & Recovery strategy and monitoring scheduled
jobs of backup and restore procedure for database.
• Having experience on database backup and restorations.
• Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for
various categories of User Support.
• Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication
Monitoring SQL Server agent jobs/maintenance plans.
• Provided 7 x 24 Production support for the database issues.
• Working with Transaction replication installation and maintenance.
• Performing the failover and failback activities.

Personal Details

• Marital Status : Un Married

• Gender : Male

• DOB : 25-04-1997

DECLARATION :
I hereby declare that the information given above is correct to the best of my knowledge.

(M RAJASEKHAR)