Pavan Utla

Highly skilled and detail-oriented SQL Server Database Administrator (DBA) with around 8+ years of experience managing, optimizing, and securing large-scale, mission-critical database environments. Extensive expertise across SQL Server 2008–2022, including database design, performance tuning, backup and recovery strategies, security management, and implementation of high availability and disaster recovery solutions. Proven experience supporting 250+ production and pre-production instances in both standalone and clustered environments, utilizing Log Shipping, Mirroring, Replication, and Always On Availability Groups.

Adept at providing 24/7 on-call support, troubleshooting complex issues under pressure, and consistently delivering secure, reliable, and high-performance database systems that support critical enterprise applications.

SQL Server Database Administrator - Alpha House Technologies

(2024-09)

Client: Rand Mutual Assurance (RMA)

• Monitoring and handling issues related to performance issues, CPU, memory, disk space, Tempdb, Log file full, logins, permissions, blockings, backup failures, job failures and configured maintenance jobs.
• Managed a large SQL Server environment, performing routine database maintenance tasks, including backups, restores, and indexing.
• Taking care of regular change activities, database refreshes, high availability and disaster recovery(HADR) issues.
• Monitoring Clusters and handling high availability and disaster recovery issue, troubleshooting Clustering Issues, performing failovers.
• Comparing the tables and schemas using SQL compare.

SQL Server Database Administrator - Wipro Technologies

(2023-02 - 2024-07)

Client: CITI Bank

• Administer over 250+ SQL Servers, ensuring optimal performance, availability, and security.
• Work on Service now incident related to disk space, log file full, data file full, temp db full, logins, job failures, blockings, LRQs, CPU Utilization, Memory utilization, High availability, performance issues and user requests on priority basis.
• Taking care of regular change activities, db refreshes, high availability and disaster recovery(HADR) issues and performing COB drill activities as per the change and attending client and user calls.
• Monitoring Clusters and handling high availability and disaster recovery issue, troubleshooting Clustering Issues, performing failovers.
• Provided 24/7 support for production databases, troubleshooting issues and performing root-cause analysis to prevent future incidents.

Senior Consultant - Cognizant Technology

(2020-12 - 2022-04)

Clients: Close Brothers Group Bank & Oxford University Press

• Worked on remedy tickets on the priority basis and regular change activities.
• Worked on backup tool Rubrik for backups and restores using PowerShell.
• Monitoring Clusters and handling high availability and disaster recovery issues, troubleshooting Clustering Issues, performing failovers.
• Monitoring servers for disk utilization, Memory utilization and CPU utilization.
• Monitoring and handling disks space issues, job failures, logins, blockings, Tempdb and Log file full issues.
• Configured HADR in Azure for migration of infra applications from on-Premises SQL server 2017 to SQL server 2019 Azure VM’s.
• Configured and monitored regular maintenance Jobs for Periodical backups, database integrity checks, Index optimization and update stats.
• Monitoring the servers for disk utilization, Memory utilization, CPU utilization, disk space, Tempdb, Log file and blocking issues.

Senior Consultant - Saksoft Limited

(2019-07 - 2020-07)

Client: Colt

• Worked on tickets 24x7 on the priority basis with in the timeline of SLA.
• Monitoring Clusters and handling high availability and disaster recovery issue, troubleshooting Clustering Issues, performing failovers.
• Ensuring successful and periodical Backup, Restoration and responsible for daily, weekly and monthly maintenance activities.
• Upgrading SQL server software to new versions, applying service packs, hot fixes and cumulative updates.
• Monitoring and handling CPU, memory, disk space, Tempdb, Log file full, logins, permissions, blockings, backup failures and job failures.

Consultant - Excelencia

(2016-05 - 2019-07)

Client: Nitirety & Digikey

• Worked on tickets 24x7 on the priority basis within the timeline of SLA.
• Implemented Polybase feature in SQL server 2016 to interact with Hadoop.
• Monitoring Clusters and handling high availability and disaster recovery issue, troubleshooting Clustering Issues, performing failovers.
• Monitoring and handling CPU, memory, disk space issues, Tempdb, Log file full issues, logins, blockings, backup failures and job failures.
• Providing 24x7 on call support, coordinating with team and attending client meetings on regular basis.
• Monitoring alerts through Spotlight Tool, SQL Mail and error logs.
• Configured the jobs for DBA regular activities Backups, Index optimize, update statistics and Integrity checks by using Olahallengren Scripts.

Master of Computer Applications (MCA)

Bachelor of Science - Computer Science & Electronics