Michael Wolde

Microsoft Certified DBA

Alexandria, Virginia

adm3zx@r.postjobfree.com

202-***-****

OBJECTIVE

I am Seeking a SQL server DBA position with new challenges and opportunities using MS SQL server 2008/2012/2014/2016/2017 and 2019. Hands on experienced in MS SQL Server Installations, Performance Tuning, Backup and Recovery, Query Optimization, AlwaysOn, Mirroring, Log shipping, SQL Clustering and Replications and Security of database Servers. Worked independently as well as in team-oriented environments. Establishing guidelines for a defined database architecture and database builds. Experience in supporting huge SQL Server databases trouble-shooting problems.

Profile Summary

5+ years of experience in SQL DBA working on all the aspects of Administering, Managing and Supporting MS SQL Server Databases 2016/2014/2012/2008R2/2008/2005 in Production, Development, and Testing environments.

Working on Security (Create Logins, Users and Roles).

Daily checking the tickets assigned and resolve the tickets depends on the Priority levels within the SLA.

Install and configure SQL Server on production and non - production environments.

Upgrading SQL Server 2008 to 2012/2014/2016 using Data Migration Assistant (DMA) using side by side approach and applying service packs and hot fixes.

Working Experience in Database Backup, Restoration, and Recovery Database Maintenance planning.

Experience in configuring and maintaining Replication, Log-Shipping, Mirroring, Clustering and AlwaysOn A.G. and troubleshooting the issues.

Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.

Database consistency checks and troubleshooting using DBCC, MDVs and wait stats.

Experience in Performance Tuning (Server level and Query level) and trouble shooting.

Providing 24x7 technical database support for SQL Database system CERTIFICATION

Microsoft Certified Professional (MCP) in Administrating Microsoft SQL Server 2012/2014 Databases.

EDUCATION

Bachelor Degree from Addis Ababa University, Ethiopia, 2006 Professional Experience:

CAPITAL ONE BANK, Alexandria, Virginia

January 2018 to now

Position: Mid Level DBA

Roles & responsibilities

Provided database administration and support on production and development SQL server

Administered the MS SQL Server security through Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures, dropping and locking the logins,

Monitored Daily backup jobs and automation of daily restores of development databases.

Monitored the Disk Space of all the Servers, perform daily system check and performance analys.

Carried out Troubleshooting SQL Server Problems related to SQL Server service, Concurrency

(blocks, locks, deadlocks, activity monitor), and SQL Agent job execution

Create and manage database objects, stored procedures, triggers, views and functions

Create scripts and various database objects per business requirement

Monitored and Troubleshoot Server performance and database activities of particular users using SQL Profiler, Performance Monitor, Extended Event, Trace flags, Activity Monitors, Store Procedures, DBCC, and DMVs.

Implemented SQL server high availability tools like Log shipping and used Failover clustering to minimize downtime.

Capturing the events using SQL profiler for poor performing queries, deadlocks and blocks and studying the execution plans and fine tuning the applications.

Examined maintenance and Correction of Transact SQL (T-SQL) Statements.

Responsible for developing, support, and maintenance of the ETL (Extract, Transform and Load) using SSIS.

Michael Wolde

Microsoft Certified DBA

Alexandria, Virginia

adm3zx@r.postjobfree.com

202-***-****

PEPCO, Washington DC,

November 2014– December 2017

Position: Junior SQL Database Administrator

Pepco is a unit of Exelon Corporation, the nation's leading energy provider, with approximately 10 million customers. Pepco provides safe and reliable energy service to approximately 883,000 customers in the District of Columbia and Maryland. My Responsibilities are:

• Install and configure SQL Server on production and non - production environments.

• Apply Service Packs and Cumulative Updates of SQL Servers.

• Upgrade and Migrate SQL Server from lower to higher versions.

• Design backup strategies to meet RPO objectives of clients and perform full, differential and transactional log backups and restore them whenever necessary.

• Perform daily monitoring and routine maintenance tasks including backups (full, differential and transaction log), integrity checks, clean up jobs, index and statistics maintenance.

• Identify and troubleshoot memory, I/O, disk space, CPU and other resource contentions.

• Control access to SQL Server and Databases by creating logins and group users with appropriate roles and permissions.

• Implement SQL server high availability solutions like Log shipping, Replication, Mirroring, Failover Clustering and AlwaysOn A.G. as well as carefully scheduled maintenance to minimize downtime.

• Troubleshooting SQL server service outage at they occur, including after hours and weekends, and implement the best way to resolve it.

• Solve concurrency problems of blocks, locks, deadlocks by viewing and tracking them using Activity Monitor, SSMS, enabling Trace Flags and other tools such as DMVs, Extended Events and Profiler

• 24/7 support of mission critical production databases on call rotational basis.

Contact this candidate