Sql Server Disaster Recovery

Page *

Merlin Ayemele T

SQL Server Database Administrator

*************@*****.*** 480-***-**** LinkedIn Profile Professional Summary

Experienced SQL Server Database Administrator with over 5 years of experience in database performance tuning, troubleshooting, security, backup, and disaster recovery. Proven ability to implement high-availability and disaster recovery solutions, optimize database performance, and ensure data integrity in high-pressure environments. Adept at collaborating with cross-functional teams and providing 24/7 support to ensure system uptime and efficiency. U.S. citizen

Skill Areas: Backup & Recovery High Availability & Disaster Recovery Performance Tuning & Optimization

Database Security Azure SQL Database Database Design Azure Monitoring Tools Collaboration & Leadership 24/7 Production Support Technical Documentation Bilingual English & French CAREER HIGHLIGHTS AND ACHIEVEMENTS

● Implemented high-availability (HA) and disaster recovery (DR) solutions using Log Shipping, Replication, and Always On Availability Groups, improving system redundancy and uptime by 99%.

● Successfully optimized database performance, reducing query execution times by 45% through performance tuning and index management.

● Developed and implemented comprehensive backup and restoration strategies, ensuring 100% data protection and disaster recovery readiness.

● Automated backup and restore processes using Azure Automation and PowerShell, ensuring adherence to business continuity policies.

● Led multiple database migration projects, including SQL Server 2016 migrations, with zero data loss and minimal downtime.

● Migrated 20+ databases from on-premises to Azure SQL Managed Instance, reducing infrastructure cost by 40%.

● Streamlined security protocols, enhancing data encryption, access control, and compliance with corporate and regulatory standards.

PROFESSIONAL EXPERIENCE

TECHNICAL SUPPORT SQL SERVER

MICROSOFT GOODYEAR, AZ

MAY 2023 – PRESENT

Implemented robust backup and restoration strategies to safeguard critical business data and ensure disaster recovery readiness.

Designed and implemented Azure SQL Database solution, enabling business-critical applications to achieve 99.99 uptime.

Optimized database performance through query tuning, resource management, and performance monitoring.

Managed high-availability and disaster recovery solutions, including Log Shipping, Replication, and Always On Availability Groups.

Provided support to end users and development teams on database-related issues, maintaining documentation and user manuals.

Monitored and troubleshot database performance using Azure Monitor, Application Insights, and Log analytics Workspaces.

Enforced security policies to protect sensitive data and ensure compliance with regulatory standards. Merlin Ayemele T

*************@*****.***

Page 2

SQL SERVER DATABASE ADMINISTRATOR

IES COMMUNICATIONS, LLC TEMPE, AZ

MAY 2022 – MAY 2023

Planned and implemented security measures to prevent unauthorized access to databases, safeguarding information assets.

Migrated on-premises SQL Server databases to Azure SQL Database managed Instance using Data Migration Assistance (DMA) and Azure Database Migration Service (DMS).

Managed database upgrades and ensured performance optimization through continuous monitoring and troubleshooting.

Implemented security measures, including Role-Based Access Control (RBAC), Transparent Data Encryption

(TDE), and Always Encrypted.

Led cross-functional teams, including developers and network engineers, to support application development and system integration.

Conducted routine database maintenance tasks such as backups, integrity checks, and security audits. SQL SERVER DATA ADMINISTRATOR

GOOGLE, @ SITEPRO SOLUTION SCOTTSDALE, AZ

OCT 2021 – MAY 2022

Conducted performance tuning and query optimization, achieving significant performance improvements in large- scale databases.

Performed capacity planning and performance monitoring to ensure optimal database operations.

Provided 24/7 production support, resolving critical issues in real-time to ensure system availability.

Developed high availability and disaster recovery plans for critical databases, ensuring business continuity.

Utilized monitoring tools like SQL Profiler, Extended Events, and SolarWinds to track and enhance database performance.

Configured Elastics Pools to optimize cost for multiples databases with varying workloads. SQL SERVER DATABASE ADMINISTRATOR

EMMARIE BEHAVIORAL HOME CARE PHOENIX, AZ

NOV 2018 – OCT 2020

Managed day-to-day SQL Server administration, including backup, restore, security, and database integrity checks.

Designed and optimized database structures such as tables, triggers, and stored procedures to enhance application performance.

Implemented performance tuning strategies using SQL Server built-in tools and third-party solutions.

Conducted regular security audits and vulnerability assessments to ensure database compliance with GDPR and HIPPA.

Configured Active Geo-Replication for business continuity and disaster recovery scenarios. TECHNICAL DATABASE SERVER SUPPORT

RINGOVER FRANCE

SEPT 2016 – OCT 2018

Provided technical support for network and database environments, ensuring high availability and minimal downtime.

Monitored and optimized server performance, handling updates, server deployment, and troubleshooting network issues.

Developed T-SQL script for data manipulation, performance improvement, and automation.

Upgraded and migrated from SQL Server 2008 to 2016 (in place or side by side) and applied security update.

Provided 24/7 technical support, resolving critical issues for both onshore and offshore teams in record time. Merlin Ayemele T

*************@*****.***

Page 3

EDUCATION AND CERTIFICATION

Education:

● Bachelor of Engineering, Computer Systems – Advanced School of Telecommunications, France, Nov 2011

● Associate of Computer Science: Maintenance Technology Certifications:

● Microsoft Technology Associate (MTA) – Windows Server Administration Fundamentals

● Cisco CCNA, Security+, Network+ Certified & Azure fundamental Az-900

● Microsoft Break & Fix and Deployment

● Administering Microsoft Azure SQL solution: DP-300 (In progress) Skills & Proficiencies:

:

● Backup & Recovery: Expertise in designing and implementing robust backup and disaster recovery strategies.

● High Availability & Disaster Recovery: Proficient in Log Shipping, Replication, Always On Availability Groups.

● Performance Tuning & Optimization: Skilled in query optimization, index management, and troubleshooting slow queries.

● Provisioning Azure SQL database: Preparing Azure SQL Database for disaster recovery, managing database space, provisioning logical SQL server and an elastic pool, security in Azure SQL database,

● Database Security: Implementing access control, encryption, and auditing for compliance with security standards, TDE,

● Migration to SQL Server solutions in Azure: Migration service Options, Migration services, Security and resilience during migration, Migrating data to managed instance.

● Database Design: Experience in designing tables, views, stored procedures, functions, and triggers.

● Monitoring Tools: Proficient with SQL Profiler, Extended Events, Query Store, SolarWinds, and IDERA. Dynatrace, Red gate, Azure Monitor, SSMS.

● Cloud Plateforms: Azure, AWS (Basic Knowledge).

● Integration service (SSIS) and Reporting Services (SSRS).

● Collaboration & Leadership: Ability to lead cross-functional teams and provide technical support to diverse teams.

● 24/7 Production Support: Expertise in providing real-time database support and troubleshooting.

● Technical Documentation: Strong skills in creating and maintaining technical documentation and user guides.

● Languages: Fluent in English and French.

Contact this candidate