Sql Server Database Administrator

RONALD MENSAH-BONSU

**** ****** **** **. ***: 404-***-**** Email: *********@*****.***

DATABASE ADMINISTRATOR

Database administrator (DBA) with experience in T-SQL, configuration, Maintenance, Implementation, Disaster

recovery solutions and supporting next-generation database solutions in SQL Server environments. Proficient in

SQL Server 2005, 2008, 2008R2 & 2012,Windows Administration and Microsoft Office Suite. Also have

excellent communication skills with demonstrated ability to make informed decisions quickly. Very analytical

with keen attention to detail.

DBA skills include:

• •

SQL Server 2005, 2008,2008R2 & 2012 Data Migration, Mirroring & Clustering

• •

High Availability Solutions Store Procedures & Indexing

• • SQL tracing & profiling

Performance Tuning & Capacity Monitoring

• •

Data Security & Integrity Reporting & Analysis services

• •

Job Scheduling & automation Backups and Recovery

Professional Experience

Dove Technology, Duluth, GA - May 2008 – Oct 2013

Database Administrator

• Maintenance of data security and integrity through user authentication and authorization.

• Usage of Dynamic Management Views and Functions in locating bottlenecks and tuning performances

• Configured and managed Windows Server (2008r2) as it relates to MS SQL installation and mission

critical system

• Development, maintenance and implementation of disaster recovery solutions as well as high availability

solutions such as mirroring, Log Shipping, Replication and cluttering

• Ensured that DB monitoring and tuning is regularly accomplished

• Extensive use of T-SQL in writing stored procedures, triggers and functions

• Monitored and made recommendations for performance improvement in hosted databases.

• Involved in trouble shooting and fine-turning of database for its performance and concurrency

• Rebuilding, Reorganizing and Monitoring indexes at regular interval for better performance

• Managed multiple servers and populated tables in multiple databases across different instances servers

• Creation and altering of databases, tables, views and indexes.

• Extensively worked on Dynamic Management views in SQL Server 2005

• Installed and configured SQL Server Clustering on Microsoft clustering services (MSCS) from Hardware

inventory to test environment.

Best Net Company Limited, Accra, Ghana – October 2005 – January 2008

Junior Database Administrator

• Worked extensively on clustering and server consolidation, troubleshooting production issues and raising

high availability

• Configured and administered database mirroring and log shipping

• Retrieved and merged from multiple sources

• Performed backup and restore

• Created databases, file groups, schemas and partitioned table

• Performance monitoring and Tuning

• Maintained data security and integrity

Education & Training

University of Cape Coast

Bachelor of Commences, Major in Accounting – June 2004

DBA Workshops: T-SQL, Intro to SQL Server 2005, SQL Server 2008 R2

Contact this candidate