Sql Server Database

Ijeoma Dafe

*********@*****.*** 404-***-****

Professional Summary

Core SQL Server Database Administrator with over 5 years of experience. My main experiences over the last 5 years are in the following areas:

Data Migration

Database Replication

Database Performance tuning

Backup and Recovery

High Availability Solutions

Disaster Recovering

Technical Skills

Experience with SQL Server 2005, 2008, 2008R2, 2012, 2014 on Windows Server 2003, 2008 and 2008r2

Experience in database Migration and database instance consolidation.

INSTALLATION SKILLS: MSSQL 2005/2008R2/2012/2014

LANGUAGES: T-SQL, SQL

Tools

SQL Server Enterprise Manager, SQL Server Management Studio, Red gate SQL Backup, SQL Profiler, SQL Loader

Work Experience

Synoptek IT Consulting March 2013 to Present

SQL Server Database Administrator

Configured Mirroring (High Safety, High Availability & High performance) in Development and Production environments

Installed SQL Server Failover clustering to meet client needs both for Development and Production environment

Applied patches on different nodes and administered each node

Experience working with Replications (transactional and snapshot)

Closed any outstanding change tickets

Performed Database refresh from production to Test Servers/Disaster Recovery.

Responsible for backup & recovery policies & perform necessary database backups.

Running Backups in different recovery models

Restoring backups including PITR (Point in time recovery)

In charge of weekly database health checks reporting, Performance monitoring & responding to client performance bottlenecks

Scheduling Maintenance Plans, Alerts, Notifications and creating Operators

Database Server performance monitoring and tracking.

Installed, configured, and administered Stand-alone Microsoft SQL Servers

Created and maintained clear documentation regarding all components of database administration.

Worked as a team member with other DBA's to ensure 24x7 day a week support of all clients corporate databases.

Experience in Setup and Administration of SQL Server Database Security environments using Profiles, Database Privileges, Permissions and Roles, Active Directory.

Forum Corporation September 2011 to February 2013

Jr. SQL Database Administrator

Identify and troubleshoot any Blockings or Deadlocks

Identify and troubleshoot any CPU or Memory spikes

Create trace files and validate any issues on the database in question

Under Data Architect supervision, perform various disaster recovery procedures

Perform and automate database backups and recovery

Configure log shipping, as well as schedule various jobs

Design and schedule various maintenance plans

Perform SQL Server 2008 R2 installations

Modified various production tables with DDL statements

Created various Views, Stored Procedures, and Triggers

Grant access and establish permissions to database

Used different replication methodologies to select and configure the settings while maintaining the stability of data stream.

Monitored and maintained database performance and identified/recommended areas that can be improved.

Established and enforced all database standards.

Analyzed all informational requirements of new or production systems and developed database specifications.

Reviewed the designed and deployment of data objects from development/staging to production.

Building database schemas, tables, procedures and managing permissions, Implementing policy based management, Installing and deploying databases

Monitoring, Automating tasks, Setting up high availability (log shipping, database mirroring etc.), Executing change control

EDUCATION

ENUGU STATE UNIVERSITY

Bachelors of Engineering – Computer Engineering July 1998

Contact this candidate