Kanumuri Rajasekhar

Summary:
Dedicated and detail-oriented SQL Server Database Administrator with 4 years of hands-on experience in production environments. Proven expertise in installation, configuration, maintenance, and performance tuning of Microsoft SQL Server (2008R2, 2012, 2016, 2017, 2019) across Windows platforms. Strong background in database security, backup strategies, disaster recovery solutions, and user access control. Effective at identifying and resolving performance issues, space management challenges, and system bottlenecks.

Key Skills & Responsibilities:

• Installed and configured MS SQL Server versions 2008R2 through 2019 on Windows servers.
• Provided daily production support and performed routine database maintenance and health checks.
• Applied SQL Server service packs, cumulative updates, and hotfixes.
• Resolved SQL blocking, deadlock, and performance issues using tools such as Activity Monitor, SQL Profiler, and DMVs.
• Performed root cause analysis for disk space issues and implemented long-term resolutions.
• Managed database migrations across versions: SQL Server 2008 → 2012, 2012 → 2016, and 2016 → 2017.
• Configured and maintained various backup and recovery strategies including full, differential, and transaction log backups.
• Monitored and troubleshot SQL Server Agent jobs; analyzed and resolved job failures.
• Conducted index maintenance: rebuild/reorganize indexes, update statistics, and check database integrity.
• Performed space management for data and log files; proactively addressed storage issues.
• Conducted weekly data refreshes from production to test environments.
• Managed user access and roles, enforced database security protocols.
• Tuned performance at server, database, index, and query levels.
• Installed and configured SQL Server failover clusters and added nodes for high availability.
• Monitored system performance using Performance Monitor and executed query optimizations.
• Implemented and managed log shipping, database mirroring, and Always On Availability Groups (AOAG) for disaster recovery.
• Effectively managed multiple tasks/projects, prioritizing based on business impact.
• Collaborated with cross-functional teams to support application development and ensure data integrity.