About Me

 To work in a responsible position applying my knowledge and skills as an SQL SERVER DBA and skilfully accomplish projects involving Database management with an extensive use of SQL SERVER technology.

Profile Summary  �...ing Database management with an extensive use of SQL SERVER technology.

Profile Summary                                                                                                                             

• 4+ years of experience as a Database Administrator in production environments.
• Managing databases with sizes up to 2 TB.
• Work experience in 24x7 Production support for SQL Server 

2008R2/2012/2014

• Installing and Configuring the SQL Server 2008R2 and 2012.
• Applying SQL Server patches and hot fixes.
• Verifying and resolving the SQL Server Blocking issues and Finding and fixing the root cause.
• Resolving the Disk space issues, 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 and identifying missing indexes and also usage of statistics.
• Experienced in Creating Database Objects like Tables, Views and Indexes.
• Experience in usage of DBCC commands and DMV’s for troubleshooting.
• Executing the deploying the scripts in prod environment and test servers.
• Configuring, monitoring and troubleshooting the REPLICATION and DR activities.
• Performing the Failover and Failback operations in the cluster environment and troubleshooting activities.
• Performing the Failover activity in Always On environment and troubleshoot the always On activities.
• Configuring and Maintaining and troubleshooting the Database mirroring activities.
• Configuring and Maintaining and troubleshooting the Database Log Shipping activities.
• Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently.
• Experience in migration and upgrade process from SQL 2005 to 2008 and from 2008R2 to 2012.