*/*/*** *

*

Lemlem T. Kidane

Tel 202-***-****

**** ******* *******

Burtonsville MD 20866

Professional Summary

A SQL Server database administrator with 5+ years of extensive experience in SQL Server database administration including

● SQL Server upgrades and database migrations.

● Installation, configuration, upgrade, and patching of SQL Server 2016, 2014, 2012, and 2008R2 hosted by Windows 2016 and 2012(R2) in virtual environments.

● Hands-on experience in database design and development, data conversion, normalization and data modelling using ER diagram.

● Configuration of high availability and disaster recovery solutions including always on availability groups, SQL Server failover clustering, database mirroring, log-shipping, and replication.

● SQL Server administration in Production, Stage, Quality Assurance (QA), and Development environments.

● Development of databases objects such as objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements, and constraints.

● Working experience in database backup, restore and point-in-time recovery.

● Server resources configurations for SQL Server 2016/2014/2012/2008/R2.

● Enforcing robust SQL Server security policy, creating user logins with appropriate roles, monitoring user accounts, creating groups and granting the required privileges to users and roles.

● Maintenance plans and other processes automation using SQL Server agent.

● Configuring linked servers for distributed query.

● Patching service packs and latest security updates.

● Disaster recovery planning.

● Performance tuning and optimization.

● Deployment and administration of SSIS packages and SSRS reports.

● Extensive use of SSMS, SQL Server configuration manager, and Maintenance Plan tool.

● TSQL SSMS Profiler Extended Events DMVs SentryOne Database Engine Tuning Advisor.

● Excellent interpersonal communication, problem solving, documentation, analytical skills and good team player.

● Provide a 24/7 stand-by support.

Professional Experience

SQL Server Database Administrator Dec. 2016 – Current Howard Community College

Columbia, MD

Responsibilities

● Installed and configured and administered SQL Server 2016, 2014 Enterprise Ed.

● Migrated over 60+ databases from SQL 2012 to SQL 2016.

● Configured Always on availability groups and transactional replication.

● Routinely monitored the health and performance of SQL Servers using splunk real-time monitoring tool.

● Developed a detailed disaster recovery strategy for critical databases. 2/5/201 8

2

● Reviewed SQL Server error log and Windows Event Viewer as a starting point for troubleshooting issues.

● Helped application developers improve query performance by modifying and creating indexes.

● Worked collaboratively with developers and system engineers to resolve problems with applications and database systems.

● Performed new database and code deployments.

● Managed very large sized (750+ GB) transactional and reporting databases.

● Regularly fixed job failure issues, deadlocks, and other performance bottlenecks.

● Extensively performed performance tuning using SQL Server profiler, DMV/DMFs, query execution plan, perfmon and database engine tuning advisor.

● Written stored procedures, triggers, views tables, and user defined functions,

● Managed SQL Server security including implementation of SQL logins, users, roles, and authentication modes.

● Established strong server and database level security using server and database level auditing for critical objects.

● Done on call troubleshooting after SQL Server outage.

● Configured linked servers for distributed query across production SQL Servers.

● Performed side-by-side SQL Server upgrade from SQL Server 2008R2 to SQL 2014 and SQL 2014/2012 to SQL 2016.

● Configured, automated, and managed maintenance plan jobs such as database backups, integrity checks, update statistics and index rebuild/reorg using Ola-Hallengren script.

● Installed and configured SSIS and SSRS services in dedicated servers.

● Troubleshoot SQL server performance and database issues by extensively using SQL profiler trace, Windows performance monitor, extended events, activity monitors, and dynamic management views.

● Tuned slow running T-SQL queries by looking at execution plans and use of database engine tuning advisor.

● Resolved high CPU usage issues in SQL server by optimizing query by creating indexes for the query.

● Recovered database to the point of failure after corruption.

● Refreshed lower database environments on an on-demand basis.

● Developed and deployed T-SQL stored procedures, views, triggers, indexes.

● Collected baseline performance metrics of SQL Servers using Windows performance monitoring.

● Investigated and addressed sudden SQL Server Service shutdowns and node failovers.

● Provided 24/7/365 standby support.

Jr. SQL Server Database Administrator Dec. 2014 – Nov. 2016 National Foundation for Cancer Research

Rockville, MD

Responsibilities:

● Installed, configured and administered various versions of SQL Server including 2014, 2012, 2008(R2) and 2005 in Production, Staging, and Development environments.

● Configured failover clustering, mirroring, replication and log-shipping in production environments.

● Undertook a rolling in-place upgrade of clustered SQL Server instance from SQL 2012 to 2016.

● Successfully migrated 100+ databases from SQL 2005 and 2008R2 to SQL Server 2012, 2014, and 2016.

● Installing, configuring SQL Server services: SSAS, SSIS, SSRS 2/5/201 8

3

● Involved in and contributed to database design efforts including requirements gathering, developing conceptual and logical designs and review of design code.

● Written several administrative and web-called stored procedures, functions, views and ad- hoc TSQL queries.

● Diagnosed job errors and implemented solutions to solve failures.

● Configured maintenance tasks using the Ola-Hallengren script.

● Regularly conducted SQL code reviews and provided feedbacks to developers.

● Applied patches including service packs and cumulative updates.

● Refreshed staging and development environments with production databases regularly.

● Actively monitored and troubleshot performance issues using SentryOne monitoring tool.

● Used SQL Server error log and Windows Event Viewer for better understanding of critical server failure issues.

● Created and managed SQL logins and granted permissions to database users.

● Created indexes, views, stored procedures, and triggers.

● Monitored and managed use of disk space, memory, and CPU.

● Resolved tempdb and log file space issues several times.

● Addressed query performance issues due to index fragmentation and sub-optimal MaxDoP.

● Resolved blocking chains that impacted application performance by identifying and tuning the culprit query.

● Provided 24/7/365 standby support.

Education

BS in Information Technology and Computer Science (2008) Sheba University, Ethiopia

Contact this candidate