Mesfin Asfaw

Washington, DC *****

202-***-****

ado39a@r.postjobfree.com

Professional Summary:

Over five years of IT Experiences in SQL Server database administration, Design, Development and Support of Microsoft SQL Server 2014/2012/2008R2/2008/2005 in Development, Test and Production Environments on various business domains. Strong technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies.

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008/2005/2000.

Migration of SQL server 2000/ 2005/ 2008 /2012/2014 by using In-Place upgrade process and as well as side-by-side upgrade process and documented the Upgrade Process.

Experienced in maintaining and supporting Very Large Database (VLDB) more than 2TB which is taken Backup worked on Backup Strategy to reduce time and space as well as troubleshoot various problems.

Expertise in Database Backup and Recovery procedures by using Native and third-party tools.

Extensively used tools SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Experienced in using DMV, Stored Procedure and Performance Monitor/Profiler to resolve Dead locks/Long running queries.

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV's and DMF's, Re-indexing, Updating Statistics, and online indexing.

Expertise in creating and managing database objects, stored procedures, user defined functions, indexes (Clustered and non-clustered), view and triggers using T-SQL

Experienced in High Availability solution Always On, Log-Shipping, Mirroring, Clustering and Replication.

Good experience on physical storage configuration and optimization of SAN with different RAID levels.

Proficient on Business Intelligence Tools to Create SSRS Reports and SSIS packages.

Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.

Experience with logical and physical data modeling and database design using ERwin.

24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Operating Systems:

Windows Server2012/2008r2/2003,2000 Server/ Windows98/XP/7 Professional

Database Tools:

MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, Backup Server, SQL Agents, SQL Alerts, SQL Jobs, Power BI tools including SSIS & SSRS (ETL)

GUI Tools:

Visual Studio (VB), Visual Studio2005/2003

Languages:

T-SQL, XML, ASP and ASP.net

Databases:

SQL Server 2017/2016/2012/2008R2/2008/2005

Third Party Tools:

Red gate

Education & Certifications:

Bachelor of Science in Mechanical Engineering

Certifications:

MCSA: 70-765

CompTIA Security Plus

Work History

Crown Captive Insurance Co. Jan 2019 - Present

SQL Server Database Administrator

Washington, DC

Responsibilities:

Installed, configured, monitored, troubleshooting, and administered of SQL Server, 2014/2016/2017

Installed necessary Service packs and cumulative updates for various SQL Servers.

Working on Migrating SQL Server Databases from 2012 and 2014 to higher versions.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Created the backup and restore strategy for production and development environments.

Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery.

Defining SQL Server standards for HA based on Applications requirements.

Administered, Configured and Lead on Always On, Log Shipping and Replication.

Managed security on Production, Test and Development environments.

Wrote stored procedures for Automation of Jobs and Administrative purposes.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Progress Computer Services Mar 2017 – Dec 2018

SQL Server Database Administrator

Fairfax, VA

Responsibilities:

Installed, configured, and managed SQL Server 2014/2012/2008R2/2008 in development, test, and production environment.

Installed, configured, and maintained Fail-Over Cluster.

Implemented & Administered SQL Server High Availability and Disaster Recovery strategies.

Managed database backups and disaster recovery restored databases from backup and performed point-in-Time recovery.

Upgraded database from SQL Server 2008 to SQL SERVER 2014 using side by side and In-place method.

Monitored server actively and solve problem as needed.

Performed patching applied SP and Hot fixes on SQL SERVER 2008/2008R2/2012

Scheduled jobs to automate different database related activities including backup, Index de-fragmentation, re-indexing, update index statistics, history cleanup and notify operator tasks.

Applied DMV and DMF for finding out long running queries and other related activities.

Transamerica Jan 2016 – Feb 2017

SQL Server Database Administrator

Baltimore, MD

Responsibilities:

Installed, configured, and managed SQL Server 2012/2008R2/2008 in development, test, and production environment.

Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.

Configured Log Shipping as standby database from production database for reporting purposes.

Designed and implemented comprehensive Backup plane and disaster recovery strategies Implemented.

Rebuilding the indexes at regular intervals for better performance.

Troubleshoot performance problems and fine tuning of databases.

Monitored database status including CPU, memory, I/O, space, and dead locks

SQL Server tuning techniques to optimize the SQL queries and stored procedures.

24 X 7 Production Database on Call Support.

Contact this candidate