YONAS TAFESSE

Phone: 404-***-****

Email: ada1nj@r.postjobfree.com

Career Objective & Summary

I am seeking a position as SQL Server Database Administrator. I have over 6 years of experience with SQL Server. My core experiences are in the areas Data Migration, Database Performance tuning, Backup and Recovery, Database Security, Database maintenance, Indexing, SSRS, Integration Services (SSIS), database development, SQL server Azure, AlwaysOn availability groups, replication, database mirroring and log shipping. Employment History

OAK Manna SQL Server database Administrator May 2013- Present

Assisting with capacity planning and storage space management

Analyzed the physical model and employed best practices in creating a complete schema including tables, relationships, stored procedures, and views, clustered and non- clustered indexes.

Developing and writing TSQL, Views, Stored Procedures, Functions.

Monitored and maintained database performance using System monitor, event viewer, SQL profiler, database tuning adviser.

Performance Tuning using SQL Profiler and Database Engine tuning advisor.

Experience with monitoring and troubleshooting 24x7 operations.

Implemented Security Management policy including creating and managing roles, users, logins and granting rights.

Performing Data Import and Export Operations using SSIS.

Developed Backup strategies and Recovery solutions.

Provided 24 x 7 business critical production server environments support (on-call).

Creating and Implementing Databases, Tables, Schemas, Indexes, and Constraints.

Provided database Development support including query analysis and optimization.

Migration of On premises databases to SQL Server Azure.

Installed and configured SQL server 2008R2,2012 and 2014 in various environments

Configured and monitored transaction Log shipping

Set up replication

Ethiopian Community Tutoring students SQL Database (Volunteer) February 2012- Present

Creating tables, insert in to, update, and delete.

Assisting with setting up network, printers, trained users in computer use.

Installing, upgrading and configuring the SQL Database environment by creating multiple database storage, structures, objects, backup, recovery, monitoring, and optimizing database performance.

Education and Certificates

Bachelor of Degree in Computer Information System (CSIS): Database Liberty University School of Business

Associate of Applied Science in Computer Information System Georgia Piedmont Technical College

Dove Technology, Database Administration