Azure Manager

Kiflu S. Tiruneh

Database Administrator

Cell +240-***-**** E-mail: ***********@*****.***

Silver Spring, MD

Professional summary

A certified and result-oriented Database and Microsoft Azure Administrator with 6+ years of demonstrated experience in infrastructure analysis, production support, and development of database architecture. Performed system wide root causes analysis and tuned SQL server, OS, and network performance issues. Installed and configured various versions and editions of SQL servers with HA/DR solutions. Excellent in communication, presentation, analytical, problem- solving skill, and worked well with all levels of stake holders. As a self-motivated responsible person, I aim to get a challenging position as a Database Administrator in a team-oriented environment to exploit and excel my technical and interpersonal skills. Work experiances

Responsibilities:

• Configured and managed various HA/ DR solutions in a multi-subnet environment including AlwaysOn availability groups and replication.

• Installed, configured, patched, and managed SQL Server 2012, 2014, 2016 and 2019 both in lower and production environments.

• Migrated Databases from on-premises to Microsoft Azure IaaS and PaaS services.

• Experience in implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Features.

• Created virtual networking (security rules associate with NSG to a subnet or network interface)

• Optimized & tuned stored procedures and long-running queries using various built-in tools like execution plan, profiler, DTA, Perfmon and DMVs/DMFs SQL Server database/Azure Administrator

NARTech, Inc. Bethesda, MD Sep. 2017- to date

• Automated various database maintenance tasks and set up alerts for failure notification.

• Refresh databases from On-premises to Azure PaaS services for testing.

• Worked on logical and physical data base modeling with ERWIN tools.

• Created resource groups, networks and storages using Azure PowerShell. Environment: MS SQL Server 2012,2014,2016, SSIS, SSRS, Windows Server 2012, lite speed, red gate, DMA, DMS

Responsibilities:

• Upgraded and configured SQL Server 2012 from SQL Server 2008/R2 on Windows Server 2012 and applied service packs and security fixes.

• Installed, configured, and updated SQL server 2012,2008R2.

• Performed Export and Import of databases from Flat file, excel Access, Oracle and MySQL to SQL Server Database using DTS, SSIS, and BCP

• Set up Failover Clustering and log shipping in SQL server 2012 (Active/Passive)

• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

• Monitored SQL Server instance and host machine activities using SQL server log, Windows event viewer.

• Regularly Check and update databases recoverability in a lower environment

• Attended 24 X 7 Production Database on Call Support

• Participated in Database design process using Agile data modeling software. Environment: MS SQL Server 2008R2, and 2012, SSIS, SSRS, Windows Server 2008 and 2012

SQL Database Administrator

XA System, LLC Fairfax, VA Jan.2016 – June.2017

Major duties and responsibilities:

• Installed, configured, and managed SQL server 2005 and 2008.

• Applied service packs (SPs), critical updates and hot fixes on SQL server 2005/2008.

• Monitored SQL server instance and host machine activities using SQL server log, error log, Windows event viewer.

• Used Dynamic Management Views (DMV) for monitoring the performance of the server.

• Backing up (FULL, LOG and DIFF) and restoring user and system databases.

• Created roles and grant permissions to users upon proper approval from the business.

• Configured Log shipping from Production to Disaster Recovery server

• Recovered corrupt and deleted/dropped databases\table from backups. Environment: MS SQL Server 2005, SQL Server 2008, SSIS, Windows Server 2003, Window 7, RAID, PowerShell.

Technical Experience

Operating System: Windows Server 2003, 2008/R2, and 2012 Native tools: T- SQL, PowerShell, SQL Profiler, SSMS, SSIS, SSRS Third party tools: Lite speed, Idera Diagnostic Manager Migration tools: DMS, DMA for Azure cloud environment Automation: PowerShell/Azure RM, Linked server, runbook in Microsoft Azure

[[[

Education

BSc in Computer science St. Mary’s University (July.2013) Certifications

Microsoft Solution Associate certified (MCSA) Microsoft Microsoft Azure Administrator Associate Microsoft

Membership

Member of PASS – Professional Association for SQL Server. Member PASS DC – Washington DC SQL Users Group.

Jr. Database Administrator

Dashen Bank - Addis Ababa- Ethiopia Jan.2014 -Aug.2015

Contact this candidate