3.2 years of experience as a SQL Server Administrator currently working withExpedieneSolution Limited, oida across wide range of industries in a production environment in 24*7 environments
1.2YearsofexperienceasaSQLDevelopercurrentlyworkingwithExpedieneSolutionLimited, Noida.
Managing around 20 servers and130 databases and supporting a max size of 150 GB.
Installing and Configuring the SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016,2017and 2019.
Applying SQL Server patches and hotfixes to stand-alone and cluster servers.
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 and fixing the orphan users.