Sql Server Disaster Recovery

Ridwan Olatoyinbo

*********@*****.*** Santa Clarita, CA 818-***-****

Professional Summary

Experienced Database Professional with over 8 years of expertise managing mission-critical databases both on-premises and in the cloud (Azure). Skilled in SQL Server installation, configuration, security, performance tuning, and troubleshooting. Proven ability in high availability, disaster recovery strategies, database backup and recovery, and query optimization. Adept at using industry-standard tools to resolve performance issues and ensure smooth database operations.

Skills

SQL Server Installation & Configuration

Database Design & Architecture

SQL Query Writing & Optimization

Backup & Recovery

Performance Tuning & Optimization

Security Management

High Availability & Disaster Recovery (HA/DR)

Automation & Scripting

Troubleshooting & Problem-Solving

Database Monitoring & Maintenance

Tools: SQL Server Management Studio (SSMS), SQL Sentry, Redgate Areas of Expertise

SQL Server Versions: 2019, 2016, 2014, 2012, 2008 R2

Cloud Platforms: Azure, AWS

Reporting & BI: SSRS, Power BI, Tableau

Operating Systems: Windows Server (2019, 2016, 2012 R2, 2008), Linux

Virtualization: VMware

Security: Transparent Data Encryption (TDE), Dynamic Data Masking (DDM)

Monitoring Tools: SolarWinds, SQL Sentry, Brent Ozar Toolkit

Additional: SharePoint, Project Management, Data Migration, Communication, Time Management, Critical Thinking, Strategic Planning, Process Improvement, Analytical Skills

Projects

Upgraded and migrated SQL Server instances from 2012 to 2019.

Migrated virtual machines (VMs) from on-premises infrastructure to the cloud. Work Experience

ModajPro

Database Administrator

February 2018 – Present

Managed over 500 databases, including very large databases (VLDB), across multiple data centers.

Collaborated with Business Analysts, client teams, and developers for capacity planning and SQL Server upgrades.

Migrated SQL Server databases from on-premises to Azure SQL Database.

Designed and implemented High Availability (HA) and Disaster Recovery (DR) solutions and performed large-scale migrations from SQL Server 2005 to 2012 R2, 2014, and 2016.

Performed physical and logical data modeling for databases of various sizes.

Provided 24x7 production support for over 180 SQL Server instances in clustered environments.

Configured log shipping and transactional replication with multiple updatable subscriptions for DR solutions.

Executed database refreshes from production to development and staging environments.

Scheduled backups and restores; maintained security with logins, users, roles, and permissions.

Conducted database consistency checks (DBCC), index tuning, and monitored error logs.

Delivered on-call support and resolved critical SQL Server issues in line with SLAs.

Managed read-only reporting and disaster recovery databases.

Utilized PerfMon, SQL Profiler, and NetMon for performance auditing and network throughput monitoring.

Data Track Consult

SQL Server Database Administrator

March 2015 – January 2018

Designed, developed, and administered SQL Server 2014 environments.

Conducted SQL Server health checks and performance tuning using indexes and optimization tools such as SQL Profiler, DMVs, and Windows Performance Monitor.

Installed, configured, and upgraded SQL Server instances.

Automated administrative tasks via SQL Server Agent jobs, alerts, and database mail notifications.

Maintained server security through role and permission management.

Implemented disaster recovery strategies including clustering, Always On, log shipping, mirroring, and replication.

Monitored production databases to ensure optimal response times and proactively generated reports.

Created and maintained SQL objects including tables, views, stored procedures, constraints, and user-defined functions.

Managed SSIS, SSRS, and Power BI installation and maintenance. Education & Training

Master of Science, Bakersfield State University — May 2021

Certificate of Completion: Artificial Intelligence and Machine Learning in Business — March 2023

Professional Attributes

Critical Thinking & Problem Solving

Communication &Collaboration

Multitasking & Time Management

Strategic Planning & Execution

Continuous Learning & Development

Analytical Thinking & Process Improvement

References

Available upon request.

Contact this candidate