SAMSON A. OBEMBE Snellville, Georgia

(MCSA certified) 404-***-****

acf4lm@r.postjobfree.com

DATABASE ADMINISTRATOR

Professional Summary:

• 2+ years experience as a SQL Database Administrator in production environment with very large

mission critical databases.

• A Microsoft Certified Solutions Associate in SQL Server 2012.

• A database professional with strong experience in SQL Server 2012, SQL Server 2008 R2, 2008 and

2005.

• A creative thinker with strong analytical skills, critical thinking and problem-solving capacities.

• A diligent learner and team player with strong work ethics who meets targets and works with minimum

supervision.

• Excellent people skills.

Areas of Strength:

• SQL Server Database Administration

• SQL Server Installation and Implementation

• Performance Tuning, Optimization and Troubleshooting

• Capacity Planning, Monitoring and Implementation

• Disaster Recovery

• Backup & Restore

• Database Security

• Replication, Mirroring and Log Shipping

• AlwaysOn High Availability Group

• Data Migration

• ETL, SSIS

• Knowledge of Clustering

• Knowledge of T-SQL.

Professional Experience

Join Group Consulting, Atlanta Apr 2013 - Sept 2014

SQL Database Administrator

Responsibilities:

• Database administration including installation, configuration, upgrades, capacity planning,

performance tuning, backup and recovery, index maintenance in a very large high-transaction

and fast pace environment.

• Configured High Availability of database servers using Database mirroring, replications, Log

Shipping and Clustering

• Managed the production and development databases including performance tuning, capacity

planning, database security configuration, and database continuity.

• Designed and implemented SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012

databases for mission-critical business.

• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.

• Setup database maintenance plan to reorganize indexes, re-indexing and update the index

statistics on the production databases.

• Used system monitor to find the bottlenecks in CPU, disks I/O and memory devices and improved

the database server performance.

• Setup backup and restoration jobs for development and QA environments.

• Used DBCC commands to troubleshoot issues related database consistency.

• Used index tuning wizard to redesign and created indexes for better performance

• Modified stored procedures, queries, triggers, views, indexes, and functions to handle business

rules.

Samson Obembe Resume – Page 2 of 2

• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract

Transform Loading (ETL) tools of SQL Server to populate data from various data sources,

creating packages for different data loading operations for application.

• Knowledge in configuring and supporting SSIS for SQL Server 2005, 2008 R2 and 2012.

• Troubleshooting of databases and custom application issues.

• Created reports that ran daily for jobs running in SQL Server Agent.

• Good knowledge with monitoring and troubleshooting in 24x7 operations.

• Third party tools used: Clear Trace and Red Gate

Environment: SQL Servers 2005, 2008, 2008R2 and 2012, Window Servers 2003, 2008 and 2012, T-

SQL, SQL Trace, Red Gate, MS Visio, MySQL, Oracle, Clustering, AlwaysOn High Availability Group.

Pacific Institute of Technology July 2012 – February 2013

Georgia

SQL Server Instructor/Database Administrator

Responsibilities:

• Database administration including installation, configuration, upgrades, capacity planning,

performance tuning, backup and recovery, index maintenance of SQL Server 2000, SQL Server

2005, SQL Server 2008 and SQL Server 2008R2 for clients and students.

• Setup database maintenance plan to reorganize indexes, re-indexing and update the index

statistics on the production databases and laboratory databases.

• Tuning databases and optimizing performance.

• Code review and code deployments in test and production environments

• Setup backup and restoration jobs for OLTP and OLAP databases.

• Used DBCC commands to troubleshoot issues related database consistency.

• Used index tuning wizard to redesign and created indexes for better performance.

• Estimating of table sizes and record sizes.

• Troubleshooting Problems by using SQL server profiler, Activity Monitor and Extended Events.

• Solved critical production problems and performed point in time recovery plans.

Environment: SQL Servers 2000, 2005 and 2008, Window Servers 2000, 2003 2008 and 2008R2,

T-SQL, MySQL, MS Office.

EDUCATION

• Pacific Institute of Technology, Morrow, Georgia.

Information Technology/Database Administration

.

• University of Ilorin, Nigeria.

Bachelor of Science (Sociology)

• University of Ilorin, Nigeria.

Associate/Diploma in Accounting and Data Processing

• Professional Association for SQL Server.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate