Revanth Mudha
MS SQL Server Database Administrator
Hyderabad,TS
Summary
Results-driven Senior SQL Server DBA with 10.3 years of experience in database administration, performance tuning, and high-availability solutions across on-premises and cloud (Azure & AWS) environments. Expertise in Always On Availability Groups, replication, backup and recovery, and automation using PowerShell and T-SQL. Proven ability to optimize performance, troubleshoot complex issues, and ensure reliability and scalability of mission-critical systems.
Overview
10
10
years of professional experience
3
3
Languages
Work History
SQL Server Database Administrator
PDI Software India Pvt. Ltd.
11.2024 - Current
- Architect and manage SQL Server 2019/2022 Enterprise infrastructure across hybrid (Azure + AWS) environments.
- Designed and implemented cross-cloud Disaster Recovery using Distributed AGs and Always On Availability Groups.
- Performed advanced performance tuning, analyzing execution plans and DMVs to reduce CPU and I/O bottlenecks, enhancing application responsiveness.
- Automated backup, restore, index maintenance, and integrity checks through PowerShell scripts for consistency and reliability.
- Configured and scheduled effective index maintenance and statistics update plans.
- Resolved database blocking and deadlock issues by root cause analysis and applying long-term fixes.
- Handled Change Data Capture (CDC) configuration and maintenance for critical business databases.
- Mitigated parameter-sniffing issues using plan guides and forced execution plans for consistent query performance.
- Installed, configured, and optimized SSRS instances for high-performance enterprise reporting.
- Migrated on-premises workloads to Azure SQL Managed Instance, optimizing cost, availability, and scalability.
- Standardized deployments using Liquibase, improving reliability and traceability of production changes.
- Authored SOPs, DR Runbooks, and operational documentation for DBA teams to ensure procedural compliance.
- Developed custom scripts for automating routine tasks, increasing productivity and reducing manual intervention.
- Optimized database performance by implementing index tuning strategies and query optimization techniques.
- Assisted in capacity planning by analyzing growth trends and forecasting future storage needs, facilitating timely infrastructure investments.
- Trained junior staff members on SQL Server administration tasks, fostering continued professional development within the team.
- Reviewed SQL code for optimization opportunities, leading to more efficient processing times across various applications.
- Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
- Implemented regular performance monitoring and tuning strategies, proactively addressing potential bottlenecks before they impacted end users.
- Conducted regular audits of user access rights, promoting compliance with company policies and industry best practices regarding data privacy.
SQL Server Administrator
Kaseya Software India Pvt. Ltd.
07.2021 - 11.2022
- Administered and monitored 4000+ SQL Server instances ensuring 99.9% availability and optimal performance.
- Automated index and statistics maintenance, reducing manual intervention and improving job efficiency.
- Resolved TempDB contention, blocking, and deadlock issues by analyzing waits and optimizing configuration settings.
- Designed SQL Agent job frameworks for backup, compliance reporting, and performance alerting.
- Partnered with development teams to refactor high-cost stored procedures, improving query performance.
Senior SQL Server DBA
Sonata Software Ltd.
06.2017 - 07.2021
- Conducted root cause analysis for performance incidents using Extended Events, Activity Monitor, and Query Store insights.
- Developed custom PowerShell monitoring scripts for index fragmentation, backup verification, and job failure notifications.
- Implemented backup compression, encryption, and point-in-time recovery strategies validated through DR drills.
- Collaborated with architects and developers to design scalable, multi-terabyte database solutions and optimize schema designs.
- Performed regular index rebuilds, statistics updates, and query tuning to ensure maximum efficiency of transactional systems.
- Configured security audits, encryption, and access management policies in compliance with organizational standards.
- Led patching and cumulative update cycles with rollback and downtime minimization strategies.
SQL Developer / Junior DBA
CR Infotech Pvt. Ltd.
12.2015 - 06.2017
- Installed and configured SQL Server instances based on application and business requirements.
- Developed stored procedures, triggers, and views for ERP systems, ensuring efficient query execution and performance.
- Managed SQL Server migrations and version upgrades (SQL 2012,2014) with minimal downtime.
- Created, deployed, and scheduled SQL Server Agent jobs aligned with business and developer requirements.
- Created and managed logins, roles, and permissions adhering to least-privilege access standards.
Education
Master of Computer Applications (MCA) -
GPA: 80%
Master of Technology - Computer Science
12-2015
GPA: 60%
Skills
Databases: Microsoft SQL Server (2008R2–2022), Azure SQL, Managed Instance
Declaration
I hereby declare that the information provided above is true and accurate to the best of my knowledge. Place: Hyderabad Signature: Revanth Mudha
Timeline
SQL Server Database Administrator - PDI Software India Pvt. Ltd.
11.2024 - Current
SQL Server Administrator - Kaseya Software India Pvt. Ltd.
07.2021 - 11.2022
Senior SQL Server DBA - Sonata Software Ltd.
06.2017 - 07.2021
SQL Developer / Junior DBA - CR Infotech Pvt. Ltd.
12.2015 - 06.2017
Sri Venkateswara University - Master of Computer Applications (MCA),
JNT University - Master of Technology, Computer Science