Vinay Kumar Perumandla Email & Phone Number

 SQL Server Database Administration experience in production support environment(24x7). Cetified:70-764-Administering a SQL Database. Experience in Installation and Configuration in different versions like SQL Server 2005 and 2008 and 2008R2, 2012, 2014, 2016, 2017 and 2019. Resolving the Disk space issues and finding the root cause and permanent fixes. Verifying and resolving the SQL Server Blocking issues and Finding & fixing the root cause. Applying SQL Server patches on Standard alone and HA+DR Servers. Resolving MSI an MSP issue with in Maintenance window. Performing security activities. Experience with Migration & upgrades  Good experience with implementing High Availability of database servers using Replication, Log Shipping, Database Mirroring, Cluster and Always-on-availability. Good Experience in configuring, Monitoring and trouble shooting of Log Shipping, Database Mirroring, Cluster and Always-On-Availability Groups. Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans. Checking Fragmentation and Resolving Fragmentation issues. Expertise in Database backup, Restore, Recovery and Disaster Recovery Plans. Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. Working on Automation tasks like Database Health Check Report, Backup failure report, Disk-space report, service status report, SCOM Alerts Report, Monthly DB capacity Report, SQL Server Inventory, Logins Report, SOX Audit Report, Import tables from SQL 2000 to SQL 2008R2. Experience in DR Drill activity. Good understanding with Analysis Services, Reporting Services, and SSIS. Experience on Incident, problem and change management Process in ITIL Enabled CDC and TDE  Closing the tickets with in the SLA time and Monitoring the SLA. Making documentation which we are implementing new tasks in our environment. SOP document for Server and database level parameters as required for project Troubleshooting connectivity issues raised by application users Service pack, CU and security update patching on cluster and non-cluster servers Troubleshoot the poor query execution by checking the deadlocks and various database level configurations such as indexes and update stats SQL server Migration from Standard-Alone to Azure.

Listed skills include Microsoft Sql Server, Sql Server Management Studio, and Microsoft Office.

• 

  Jawaharlal Nehru Technological University

  Computers And Science