Hemanth Anusuri

Background

About Hemanth Anusuri

10 of years’ experience as MS SQL DBA working on Servers in Production, Staging, QA, and Development environments. •Hands on experience with Installation, configuring, applying Service Packs and patches, maintenance and performing upgrades of MS SQL Servers 2008, 2008 R2, 2012, 2014, 2016 and 2017 •Hands on experience with security administration, configuring permissions and assigning roles to users. •Backup and recovery methods (Full, Diff & Translog) using Management Studio and Query Analyzer. •Hands on Experience with Log shipping and Mirroring and Replication (High Availability) •Used DDL and DML to write stored procedures and perform data manipulation tasks •Trouble shooting the space management issues. •Experience in working with Windows servers •Performed database health checks using SQL profiler, perfmon counters, DMV’S and DBCC commands •Experience in figuring out the bottlenecks in the system using various counters in performance monitor •Hands on experience of SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server Surface Area Configuration, Database Engine Tuning Advisor and Integration Services(MSSQL Tools) •Hands on experience with Automating SQL Server, Job scheduling, alerts and automation, database mail. •Ensured that all the databases are available 24x7 in production environment •Good interpersonal and technical skills to hire eligible consultants for US direct clients. •Hands-on experience with Recruiting tools like MaxHire. •Worked as Recruiter for both IT and Clinical companies