Harinath R.

Experience on installing, configuring, managing, monitoring and troubleshooting various SQL server versions in standalone and cluster environment. Moving System and User databases from one location to another location. Experience in applying necessary SQL server service packs and CUs / Hotfixes. Backing up Databases: Experience in preventing data loss by taking necessary backups using suitable backup method and proper backup strategy along with performance considerations. Verifying and resolving the SQL Server Blocking and deadlock issues and finding and fixing the root cause. Managing Security: creating logins, assigning logins to users, assigning roles, assigning permissions to users and roles; dropping & unlocking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Hands on experience in implementing the High availability techniques like log shipping, mirroring, fail-over clustering and always on. Maintained and configured Transactional Replication. Regularly monitored jobs and maintenance plans, application patch management and general health of servers and databases. Good experience in Migration of SQL Server 2008 to SQL Server 2014 & SQL Server 2012 using in place and side- by-side approach. Handson experience in con figuring the Always On and adding & removing databases. Configured active / passive clustering and failover and maintenance 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. Experienced in using PowerShell to automate SQL Server administration tasks.