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