Database Admin

* ***** ******** ********** ** a SQL Server Administrator, with vast experience in supporting Database applications. Extensive Knowledge in Migration, Disaster Recovery, Performance Tuning,

Backup and Recovery, Database Security, High Availability Solutions, Database Upgrades patches, Reporting

TECHNICAL SKILLS:

DBMS: SQL 2005, SQL 2008, Database Administration, Data Modeling, Replication, Enterprise Environments, Tuning, SQL Profiler, Clustering, SQL Server Integration Services and SQL Server Reporting Services.

Operating systems: Windows ME/NT/2000/2003/2008/Xp/Vista/7; Os/2

EXPERIENCE:

MS SQL Server DBA Full-Time August 2005 to April 2008

ShopRite Holdings Ghana, West Africa

MS SQL Server DBA Full-Time April 2008 to July 2009

ShopRite Holdings Nigeria, West Africa

The Shoprite Group of Companies, Africa's largest food retailer, operates 1225 corporate and 280 franchise outlets in 16 countries across Africa and the Indian Ocean Islands. With the head office in South Africa, ShopRite holding operates world-class supermarkets in Angola, Botswana, Ghana, Lesotho, Madagascar, Malawi, Mauritius, Mozambique, Namibia, Nigeria, Swaziland, Tanzania, Uganda, Zambia and Zimbabwe.

Shoprite Holdings Ltd comprises the following entities: the Shoprite Checkers supermarket group, which consists of 403 Shoprite supermarkets; 154 Checkers supermarkets; 26 Checkers Hypers; 212 Usave stores; 20 distribution centers supplying group stores with groceries, non-foods and perishable lines; 231 OK Furniture outlets; 17 OK Power Express stores; 50 House & Home stores; and 132 Hungry Lion fast food outlets. Through its OK Franchise Division, the Group procures and distributes stock to 30 OK MiniMark convenience stores; 17 OK Foods supermarkets; 81 OK Grocer stores; 27 Megasave wholesale stores; 32 OK Value stores and 72 Sentra stores and buying partners.

In this role, my duties are as follows:

• Installed SQL Server on Windows 2000 Server.

• Involved in the Analysis and Design

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

• Responsible for General Database Administration, Query Performance tuning.

• Backup recovery schedules, Backup scripts.

• Data Migration from legacy Applications.

• Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complains.

• Ensuring the continuous availability, capacity, security and performance of all our databases..

• Planning and coordinating upgrades with other groups e.g. operations, developers and the business users.

• Assisting developers - providing test/development environments, setting standards regarding coding and design, ensuring change release procedures are adhered to, providing performance tuning advice and troubleshooting.

• Performance monitoring and database tuning

• Solving operational problems as soon as possible with minimal interruptions to service.

• Root cause analysis / investigation of problem resolution to safeguard against future occurrence.

EXPERIENCE:

MS SQL Server DBA Full-Time August 2009 to Present

Pacific Systems MCDonough,Ga

• Installed SQL Server 2005/2008/2008r2 on Windows 2003/2008 Server.

• Applied patches and service packs to keep the database at current patch level.

• Responsible for configuration of Microsoft Server/Client Products and implementation.

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. Involved in Analysis and Design Documentation, User requirements and maintained good documentation.

• Supported production and development databases.

• Developed and Maintained Complex Stored Procedures.

• Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.

• Managed 87 databases at the headquarters running on 8 servers

• Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs.

Education:

BEULAH HEIGHTS UNIVERSITY, ATLANTA GEORGIA

Master of Arts 2007- 2009 -Dean’s List

AMERICAN INTERCONTINENTAL UNIVERSITY, DUNWOODY, GEORGIA. 2003-2004

BIT (Information Technology) 2003-2004 - -Dean’s List

UNIVERSITY OF LAGOS, LAGOS-NIGERIA

BSc. Business Administration 1981-1984 - University Of Lagos, Lagos-Nigeria

Contact this candidate