Sql Server Ms

Daniel Djobissi Mboda

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

443-***-****

SQL Server Database Administrator

Over 5+ years of hands-on experience as a MS SQL Server Database Administrator with experience on 24x7 production and mission critical database support. I possess strong analytical and problem solving skills, self-motivated, results-driven, team player with good verbal and writing communication skills. I have worked on MS SQL Server 2008, MS SQL Server 2008R2, MS SQL Server 2012 and MS SQL Server 2014 versions involving database administration, production support, installation, configuration, maintenance, upgrades, migration, backup and recovery, performance tuning, failover clusters and mirroring, replication, space management and security.

Skills Summary

Experience in all the phases of SDLC.

Experience in Installing, Configuring and Maintaining MS SQL Server 2008, MS SQL Server 2008R2, MS SQL Server 2012 and MS SQL Server 2014.

Performance Monitoring using SQL Profiler and Windows System Monitor.

Configured log-shipping between the servers as part of Disaster Recovery setup.

Experience in distributing and partitioning data.

Experience in Importing and Exporting data.

Experience in Monitoring SQL Server and Optimizing Performance.

Experience in Failover Clusters and Database Mirroring, as well as Log Shipping and Replication.

Experience with Change management process for production and non-production changes.

Worked on Database Administration on MS SQL Server 2008, MS SQL Server 2008R2, MS SQL Server 2012 and MS SQL Server 2014.

Strong experience in working on Very Large Databases (VLDB) over 800 GB for OLTP and over 2TB for OLAP databases.

Implement import and export of databases.

Experience in trouble shooting and resolving database issues.

Technical Skills

Operating Systems

Windows Server 2008, Windows Server 2008R2, Windows Server 2012, Windows Server 2012R2

RDBMS

MS SQL Server 2008, MS SQL Server 2008R2, MS SQL Server 2012, MS SQL Server 2014

Languages

SQL, T-SQL

Tools & Utilities

SQL Server Management Studio, SQL Server Profiler, Database Engine Tuning Advisor, Command Prompt, SQL Server Data tools.

Education

Bachelors’ degree in Geography

Professional Experience

Universal Service Administrative Company - Washington DC

June 2013 – Present

SQL Server Database Administrator

Responsibilities:

Installed, Configured, and Administered MS SQL Server 2008R2, MS SQL Server 2012 and MS SQL Server 2014.

Installed and Configured various SQL Server versions on various Windows Servers.

Installed SQL Server 2012 on Standalone and Cluster environments.

Involved in MS SQL Server 2008R2 to MS SQL Server 2012 to SQL Server 2014 migrations.

Modified current database by adding tables and relationships to support online system.

Monitor SQL Servers for space, memory & CPU issues.

Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.

Created and managed SQL Server login, database users and Roles.

Scheduled jobs for backup, and created alerts for error reporting.

Data migration.

Implement import and export databases

Upgraded MS SQL Server 2008R2 to MS SQL Server 2012 to MS SQL Server 2014.

Processed user requests received through tickets.

Rebuilt the indexes when necessary for better performance.

Effectively implemented Point in Time restoration.

Participated in different testing and debugging for the system.

Documented all processes involved in maintaining the database for future reference.

Performed backup and restorations of databases.

Ensuring all maintenance jobs are running fine with no issues.

Performance tuning of queries and stored procedures using SQL Profiler and Index Tuning Wizard.

excellent Knowledge on ETL and proper use of SQL Server Data tools/Visual Studio 2010.

Experience working with Microsoft office for many years.

Environment: MS SQL Server 2008, MS SQL Server 2008R2, MS SQL Server 2012, MS SQL Server 2014, Windows Server 2008, Windows Server 2008R2, Windows Server 2012, Windows Server 2012R2, SSMS, SQL Profiler.

Contact this candidate