Sql Server Database Administrator

Michael Ade

Azure SQL Server Database Administrator Microsoft Azure DP 300 Certification in progress

**************@*****.*** 972-***-****

SQL Server DBA with 6+ years of experience in administering, and optimizing Microsoft SQL Server environments (2005-2022) across Production, Clustered, & Dev. systems. I am Skilled in query performance tuning, system health monitoring, backups, database provisioning, and leveraging built-in SQL Server tools and related IT technologies. I am experienced with database refreshes, Active Directory (Microsoft Entra ID), and Microsoft Azure. A strong communicator and self-starter adept at prioritizing and multitasking workloads and consistently met deadlines.

SKILLS

●Virtualization: using VMWare and Hyper-V

●SQL Server Integration Services - SSIS

●SQL Server Analysis Services – SSAS

●SQL Server Reporting Services – SSRS

●Automated HADR Solutions using PowerShell, supporting failover clusters, Always On Availability Groups, Replication, Mirroring, and log Shipping for mission-critical databases.

●Managed Azure SQL Managed Instance for secure, scalable, and optimized database performance in a cloud production environment.

●Database Optimization, purging, and Performance Tuning on 2005-2022 server versions.

●Automated monitoring solutions with Azure Monitor Alerts and locks to track data/cost utilization, prevent disasters, ensuring a proactive resolution of potential issues in the cloud environment.

●Migrated databases from On-prem to Azure cloud environments.

Critical Healthcare Connections, Dallas, TX

SQL Server Database Administrator. September 2021– July 2025

●Planned and executed SQL Server 2005-2022 installations, patches, upgrades, and migrations in virtualized environments, following best practices to ensure stability and minimal downtime.

●Developed and maintained database objects such as tables, stored procedures, functions, views and wrote TSQL scripts for queries and automation.

●Implemented robust backup, recovery, and capacity planning strategies aligned with RPO, RTO, and retention policies to ensure data availability and compliance.

●Automated routine database maintenance tasks by using a combination of PowerShell scripts and SQL Server agent jobs/Maintenance Plans for backups, index optimization, and creating alerts to ensure consistent performance and proactive monitoring.

●Security: Managed authentication and access control in Azure SQL using Microsoft Entra ID (IAM), Role Based Access Control (RBAC), and User/Group assignments; enforced least privilege permissions and implemented AE, TDE, and DDM to secure client’s sensitive data and compliance standards

●Implemented data security and access control using least-privilege permissions, Always Encrypted, TDE, and DDM to protect sensitive data and ensure compliance.

●Optimized SQL Server configurations and T-SQL queries to streamline healthcare data management and improve data retrieval efficiency leading to faster report generation and reduced query time.

●Conducted performance tuning and troubleshooting using KPIs, SSMS tools such as Profiler, Performance monitor, Extended Events, DMVs, and third-party tools to establish performance baselines, resolve system issues and maintain health. Provided 24/7 support, including maintenance, outage response, and database recovery.

●Configured High Availability and Disaster Recovery (HA/DR) solutions using Always On, Failover Cluster, Replication, and Log Shipping to ensure database uptime. and DR testing and database migrations across environments.

●Created and updated database documentation on standard procedures, schema changes and troubleshooted issues in non-production environments to support production stability.

●Analyzed and resolved real-time database issues including server configuration, hardware and software purchase decisions, query/index tuning, partitioning, database compression, and statistics updates to maximize performance.

United Healthcare Services (UHS), TX

MS SQL Database Administrator. June 2019 – September 2021

Used T-SQL and Dynamic Management View (DMVs) like sys.dm_exec_requests, sys.dm_os_wait_stats to perform root cause analysis and quickly identify performance bottlenecks.

Used Ola Hallengren’s stored procedure to automate backups, Index maintenance, integrity checks across over a hundred SQL instances.

Provided subject matter expertise (SME) during cross-functional projects, and disaster recovery testing, ensuring the use of best practices and technical guidance.

Resolved user-reported performance issues like slow running queries, full transaction logs, blockings, and other recurring complex issues, thus improved system efficiency and user satisfaction.

EDUCATION

University of Buea, Cameroon B.Sc. in Chemistry

University of Dallas, Texas MSc. in Science/Information Technology

CERTIFICATION/BADGES

Azure DP 300 in progress

Security+ - SY0-501

Contact this candidate