Radhamohan Karra

Background

About Radhamohan Karra

SQL Server Database Administration experience in production support environment(24x7). 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 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 Server’s migration from On-Premise SQL to AWS. SQL server Migration from Standard-Alone to Azure.