Having 4.5 years of Experience in SQL Server Database Administrator production support in Microsoft SQL Server 20005/2008, 2008R2, 2012, 2014 & 2016 and 2 years in java developer total 6.5 years of IT experience.
Installing, and configuring Microsoft SQL Server 2005/2008/2008R2/2012/2014 & 2016.
Applying Service Packs andHotfixes in different versions 2005, 2008/R2, 2012, 2014 & 2016.
Supporting a total of 400 servers in 270 Servers production, Test, and Development Environment.
Implementing high availability solutions using the following techniques Replication, Log Shipping, Database Mirroring, Failover Clustering and AlwaysON in SQL Server 2012
Resolving the Disk space issues and finding the root cause and implemented permanent fixes.
Verifying and resolving the SQL Server Blocking issues and Finding the root cause
Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.
Creation & administration of all database objects, including tables, indexes, views, stored procedures.
Working Experience on Migration activity from SQL Server 2008 to /2012/2014.
Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.
Experience in implementing SQL Server security and Object permissions like maintaining the creation of users, configuring permissions, and assigning roles to users.
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 Server Tuning, Query Tuning through SQLServer Profiler, and DETA.
Experience in SQL Server 2012 AlwaysON Configuration, troubleshooting, and failover.
Worked closely with management, development team, and users.
Work as part of a team and provide 24 x7 supports when required