Sql Server Database Administrator

Blessing Onokpasah

*** ******** **, **********, ** 30005

717-***-**** *****************@*****.***

Professional Summary

Microsoft Certified SQL Server Database Administrator with over 6 years of experience in managing and optimizing large-scale databases across production, test, and development environments. Expert in database installation, upgrade, and patching, with a strong focus on performance tuning, high availability, disaster recovery solutions, and database security. Adept at schema design, SQL query tuning, and providing guidance to application developers. Proven track record in leading database migrations, implementing replication setups, and proactively recommending system improvements.

Key Skills

Database Administration: MS SQL Server

(2019/2017/2016/2014/2012/2008R2/2008/2005), Oracle, Sybase

High Availability & Disaster Recovery (HADR): Always On, Clustering, Database Mirroring, Log Shipping, Replication

Performance Tuning: Query Optimization, Index Optimization, SQL Query Tuning, Database Health Checks

ETL & Reporting: SSIS, SSRS, Power BI, Tableau

Database Security: Transparent Data Encryption (TDE), Dynamic Data Masking, User Management

Installation, Upgrade & Patching: Expertise in Oracle, Sybase, and SQL Server platforms

Monitoring & Troubleshooting: SQL Profiler, Query Store, Extended Events, DTA, SolarWinds

Professional Experience

SQL Server Database Administrator (Production DBA) Comet Network, Atlanta, GA

December 2017 – Present

Database Management: Managed over 500 databases across global data centers, ensuring 99.9% uptime and optimal performance.

Migration & Scalability: Led the migration of SQL data from on-premises to Azure SQL Database, increasing scalability by 40%.

High Availability: Implemented and maintained High Availability and Disaster Recovery solutions, reducing downtime by 30%.

ETL Development: Developed high-performance ETL packages using SSIS, improving data processing eƯiciency by 25%.

24/7 Support: Provided continuous support for 180+ SQL Server databases in clustered environments, achieving a 95% issue resolution rate within the first 24 hours.

Query Optimization: Optimized SQL queries, resulting in a 20% reduction in query execution time and improved system responsiveness.

Reporting: Configured and deployed SSRS reports, enhancing business intelligence capabilities by 15%.

SQL Server Database Administrator

JOS A Bank, Hampstead, MD

March 2015 – November 2017

Database Design & Administration: Designed and administered SQL Server environments from 2005 to 2014, improving system reliability by 35%.

Performance Tuning: Enhanced query performance through SQL indexing and optimization tools, reducing average query execution time by 25%.

Automation: Automated 60% of routine administrative tasks, reducing manual workload and improving operational eƯiciency.

Disaster Recovery: Implemented disaster recovery strategies, minimizing potential data loss by 95% and ensuring business continuity.

Security Management: Managed security protocols by assigning logins, roles, and permissions, safeguarding sensitive data and reducing unauthorized access incidents by 20%.

Data Integration: Supported and maintained SSIS, SSRS, and Power BI, facilitating data-driven decision-making and improving report generation speed by 30%.

Education & Certifications

Bachelor of Chemistry

University of Maiduguri, Maiduguri, Nigeria

Business Administration Certification

Harrisburg Community College

Certificate of Completion in SQL Server Database Administration Omibia Training Centre, Upper Marlboro, MD, USA, 2016 References

Available upon request

Contact this candidate