Sql Server Disaster Recovery

AZIZ RUTABINGWA

Mesa, AZ ***** 817-***-**** ********@*****.***

PROFESSIONAL SUMMARY

Results-driven SQL Server Database Administrator with over 5 years of experience in managing, optimizing, and securing enterprise-scale databases. Adept at designing and implementing high-availability and disaster recovery solutions to ensure 99.99% uptime for mission-critical applications. Expertise in database performance tuning, query optimization, with a deep commitment to ensuring database integrity, performance, and security in dynamic and complex environments. Proven track record of leading migrations to newer versions of SQL following the SDLC. Recognized for strong leadership skills, mentoring junior DBAs, and collaborating with cross-functional teams to align database solutions with business goals. SKILLS

SQL Indexes

Backup and Restoration Procedures

Agile Methodology

Root Cause Analysis

Database Analysis

Technical Application Support

Disaster Recovery Procedures

Encryption

Implementing Security Measures

WORK HISTORY

SQL SERVER DBA May 2023 - Current

LINTOC CARE – MESA, AZ

Proficient in SQL Server versions (2012-2022), with expertise in database design, optimization, and administration. Install, configure, and maintain databases across development, testing, and production environments.

Extensive experience in high availability solutions, including Always on Availability Groups, database mirroring, replication, and log shipping.

Strong knowledge of performance tuning, including query optimization, indexing strategies, and use of SQL Profiler, Extended Events, and Dynamic Management Views

(DMVs).

Skilled in implementing and maintaining disaster recovery solutions using SQL Server Backup/Restore, Database Snapshots, and utilized RDBMS tools and utilities to monitor, tune and optimize system performance.

Managed and optimized databases exceeding 10 TB in size, ensuring peak performance and availability for mission-critical applications.

Architected and deployed enterprise-wide database solutions for high availability and disaster recovery, achieving 99.99% uptime.

Developed and implemented robust database security protocols, including role-based access control (RBAC), data encryption (TDE), and auditing mechanisms.

Automated repetitive tasks such as backup verification, index maintenance, and alert generation, increasing DBA team productivity by 25%.

Conducted database health checks and audits, identifying and resolving critical issues to enhance system stability and reliability.

Acted as the primary point of contact for escalations, resolving critical database issues within strict SLAs.

Partnered with development teams to design scalable databases and optimize complex queries, enhancing application performance.

SQL SERVER DBA 10/2020- 03/2023

PLS Financial – Chicago, IL

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Diagnose and resolve database-related issues and provide technical support to developers and other stakeholders.

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Monitor database performance, identify bottlenecks, and implement performance optimization strategies

Implement and manage database security measures, including access controls, encryption, and vulnerability assessments and remediation

Develop and implement backup and recovery plans to ensure data integrity and availability

Assist in the design and implementation of database schemas, tables, procedures, and permissions.

Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication

Maintain comprehensive documentation of database configurations, processes, and procedures

Ensure databases comply with industry standards and regulations and develop scripts and tools to automate routine database maintenance tasks

Work closely with development, IT, and business teams to support database-related initiatives and projects

Analyze and develop disaster recovery strategies, support disaster recovery testing, and ensure robust disaster recovery plans are in place to minimize downtime and data loss in the event of a disaster

EDUCATION

BSc in Data Science (in Progress)

Arizona State University

Microsoft Azure AZ 900 (in Progress)

Contact this candidate