Kibret S.

acong4@r.postjobfree.com

Annandale, VA

571-***-****

Career Objectives:

I am looking for a position with new challenges and opportunities to build

upon my extensive knowledge and experience in MS SQL Server. My goal is to

develop innovative and effective database solutions that will meet the

technical objectives of the company and support the implementation of the

company's mission. As a result, I want to obtain a challenging technology

position in an organization that enables me to excel and offers me an

advancement opportunity with increasing related task knowledge.

Areas of EXPERIENCE:

Installation & configuration SQL Server & Database Database Consistency check

Database Administration Security Management Applying Patches, Service

Backup/Recovery & Disaster Creating Schemas, Tables, Pack & Hot Fixes

Recovery Solution Indexes and Views Programming - T-SQL, Stored

Database Point-in-time recovery Creating Jobs & Alerts Procedure, Functions,

Creating Linked Server and Triggers

High Availability Solutions, Writing Distributed Query Creating and Deploying SSIS

Mirroring, Log Shipping, Performance Turing and Query packages

Replication Optimization Report development,

Database Migration Tracing Long Running Queries deployment, & security

Database Upgrade and Deadlocks management using SSRS

-

Technical Skills:

SQL Server Administration:

Technical Skills:

SQL Server Administration:

> SQL Server 2012, 2008 & R2, 2005 and 2000

> Database Mirroring, Log Shipping, Replication and Clustering

Management

> SQL Server Management Studio, Enterprise Manager, BI, SQL Server

Integration Services (SSIS), SQL Server Reporting Services

(SSRS), SQL Server Profiler/Trace, Database Tuning Advisor,

Upgrade Advisor, Query Analyzer, Activity Monitor, SQL Server

Migration Assistant, SQL Trace, DBCC, DMV, BCP.

Operating Systems:

> Windows Server 2008/R2, 2003/R2, 2000, VMWare

> Hardware/Storage: RAID, LAN, SAN

> Data Modeling: ERin Data Modeler, SQL Server Data Dia

Professional Experience

[pic]

Cox Communications

SQL Server Database Administrator 09/2013 to present

Responsibilities

. Installed, Configured, and Managed SQL Server 2012, 2008, and 2005 in

development, test, and production environment, on stand alone and

clustered servers

. Applied Service Packs and Hot Fixes on SQL Server 2000, 2005, 2008

R2,2012

. Managed security, created and managed logins, users and roles

. Scheduled jobs to automate different database related activities

including backup, monitoring database health, disk space, backup

verification, updating statistics

. Strong working experience in creating and modifying tables, index (

cluster/non-cluster), constraints (unique/check), views

. Strong knowledge and working experience in database backup and

disaster recovery

. Restored database from backup and with point-in-time recovery

. Installed, configured and maintained database mirroring, log shipping

and replication

. Configured log shipping as standby database from production database

for reporting purposes

. Installed, configured and maintained database mirroring using

automatic fail-over option in SQL Server 2008R2, 2008 and 2005

. Configured and maintained replications (Transactional)

. Export & Import data from Flat file, CSV file to/from SQL Server

Database using SSIS (SQL Server Integration Services), BCP (Bulk Copy

Program)

. Export & Import data from/to databases like Oracle, MySQL, and Access

to/from SQL Server

. Migrated database from MS Access 2003/2000 into MS SQL Server 2008

R2, and from SQL Server 2005 to SQL Server 2008

. Upgraded database from SQL Server 2000 to 2005, and SQL Server 2005 to

SQL Server 2008

. Upgraded MS Access 2000/97 databases into MS SQL Server 2000, 2005,

and 2008

. Experienced on database monitoring and performance tuning

. Created clustered indexes and Non-Clustered Indexes to enhance

performance of database

. Performed defragmentation and rebuilding of indexes periodically on

the production tables

. Monitored SQL Server error log and space usage.

. Used DBCC commands to check database conditions, indexes rebuilding

and other database performance optimization methoExperienced in using

performance monitor, SQL profiler and optimizing the queries, tracing

long running queries and deadlocks, and using execution plans and

traces.

. Monitored server activity and solved problems as needed

. Used third party tools such as Idera and Spotlight to monitor SQL

server performance

. Assisted database developers to optimize SQL queries and Stored

Procedures

Star Wood Hotels and Resorts

(Sheraton Hotels and Resorts)

SQL Server Database Administrator 09/2009-

07/2013

Responsibilities:

Installed, Configured, and Managed SQL Server 2008 & 2005 in

development, test, and production environment

. Creating and maintaining various databases on production/development

servers .

. Configured Log shipping from Production to Disaster Recovery server.

. Involved in development of automated daily, weekly and monthly system

maintenance tasks such as database backup, integrity verification,

replication verification, and indexing updates.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Identified, tested and resolved database performance issues to ensure

data optimization.

. Used tools like SQL Server profiler, Performance Monitor to identify

bottlenecks.

. Involved in installing SQL Server 2008/2008 R2 on Development,

Production.

. Troubleshooting high availability scenarios involving Clustering,

Database Mirroring, Log Shipping and Replication.

Strong knowledge and working experience in Database Backup, Restore and

Point-in-Time Recovery

. Migrated databases and database objects between multiple servers across

production, QA and development platforms.

. Involved in Performance Tuning, Indexing, Query Optimization.

. Involved in Resolving locking and blocking issues.

. Created database objects like tables, views, indexes, stored-procedures,

triggers, cursors using T- SQL

. Creation of Jobs, Schedules, Alerts using SQL Server Agent and

Notifications using SQL Mail.

. Involved in Setting up Log shipping and database mirroring.

. Created and managed the Database Users, Login and Security.

. Monitoring Event viewer, SQL Error logs and Log File Viewer for Software

and hardware related errors.

Strong working experience in creating, modifying tables, Index

(Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored

Procedures, Trigger

Export & Import data from/to databases like Oracle, MySQL, and Access

to/from SQL Server

Information and Technology Inc .

Desk Support

6 /2008 to 8/2009

. Provided computer help desk support via telephone communications with

end-users.

. Performed diagnostics and troubleshooting of system issues, documented

help desk tickets/resolutions and maintained equipment inventory

lists.

. Performed set-up, break-down, and transport of agency equipment on an

as-needed basis.

. Performed desktop support to over 475 employees in person and by

telephone.

. Trouble shot network connectivity, network printing and user access

issues.

. Played a key role in ensuring a proficient workforce and significantly

reducing system downtime.

. Built and maintained computer systems and performed memory upgrades

Certificates:

> MCITP (Microsoft Certification IT Professional) Design and

optimization of SQL Server 2008

> MCTPS ( Microsoft certified Technology Specialist)- SQL Server

2008, Implementation and Maintenance

Education:

> Bachelor of Science

References: - available upon request

[pic][pic]

Contact this candidate