Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Software
Timeline
Generic

Betelhem Tesfay

Springfield,VA

Summary

Microsoft Certified SQL Server DBA with 9+ years of IT experience designing, coding, testing, and supporting next-generation database solutions in SQL Server. Proven expertise installing, configuring, administering, and maintaining mission-critical databases across SQL Server 2008–2016, including AWS RDS/EC2. Skilled in in-place and side-by-side upgrades, orphan user remediation, robust security and permissions (server and database roles), HA/DR, performance tuning, backups, health checks, SSRS, and AWS deployment with ITIL-aligned change management. Strong communicator and proactive team player.

Overview

9
9
years of professional experience
1
1
Certification

Work History

SQL Server Database Administrator

Mobivity
09.2023 - Current
  • Installing, configuring, administering and securing production and non-production servers (clustered and non-clustered).
  • Upgrading SQL Server 2017 to SQL Server 2019.
  • Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2017 Always On availability group in AWS.
  • Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods.
  • Experts in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh.
  • Managed and Involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.
  • Managed and Implemented Ola Hallengren's Industries best SQL server maintenance plan and created schedule for all environments.
  • Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance.
  • Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
  • Monitor database growth activities & Troubleshoot Transaction Log Issue.
  • Created and configured mirroring for Disaster Recovery
  • Providing weekly status information on all projects to Project Manager
  • Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN
  • Reporting on a weekly basis to the project manager.
  • Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
  • Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler
  • Installation of Service packs to all environments.
  • Used log shipping for synchronization of databases.
  • Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server 2014, Oracle database
  • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)
  • Experience in migrating SQL Server 2012 and 2014 to SQL Server 2016 with AlwaysOn Availability
  • Good understanding in database and data warehousing concepts (OLTP & OLAP).
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
  • Worked on BCP for a data uploading module and created SSIS packages for data transfer & transform across locations and multiple data sources as per requirement.
  • Created new tables, stored procedures and triggers using T-SQL.
  • Refactored and Fine-tuned the queries and Stored procedures in T-SQL.
  • Performing DB backups, DB refresh, DB restores, clean-up, statistics update
  • Installed and configured MS SQL Servers in Virtual Environments using VMWARE.
  • Analyze the Execution plans and recommend/implement a better execution plan.
  • Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
  • Experience supporting AWS DB in production and Development environment
  • Environment: Windows 2016-2019, SQL Server 2017-2019, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN.

SQL Server Database Administrator

Union Bank
03.2018 - 09.2023
  • Installed and configured various editions and versions of SQL Server Server in standalone, and clustered nodes
  • Installed, and Configured SQL Server Fail-Over Cluster for SQL Server, 2014,2017 and 2019.
  • Applied service packs, hotfixes and cumulative updates
  • Upgraded SQL Server 2014 Database into SQL Server 2017 and 2019
  • Created and maintained logins, Users, Roles and managed security of the database.
  • Implemented Disaster recovery plan by performing routine backups and restore
  • TakingFull, Diferential and Transactional log backups and setting automated jobs.
  • Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
  • Performed data Extracting, Transforming and Loading (ETL) from diferent data sources.
  • Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance
  • Created triggers, views and stored procedures
  • Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts Operators Notifications and configured database Mail.
  • Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
  • Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
  • Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.
  • Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
  • Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.
  • Experience in contacting Microsoft and other vendors for product and technical support.
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.
  • Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).
  • Environment: Windows 2016-2019, SQL Server 2014-2019, IDERA SQL diagnostic Manager, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.

SQL Server Database Administrator

Bank of America
06.2016 - 01.2018
  • Installed and configured SQL server 2014 and 2017.
  • Installed and configured window server 2012R2 and 2016.
  • Created and updated databases, tables, stored procedures, triggers, functions, and views.
  • Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.
  • Prepared documentation for disaster recovery plan.
  • Involved in installing failover clustering on multiple nodes.
  • Implemented database mirroring and log shipping
  • Planned backup strategies, scheduled backups, and performed restore operations.
  • Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.
  • Worked on creating, reorganizing, and rebuilding indexes.
  • Worked on database space management, performance monitoring, and alert management.
  • Planned the location of files and increased the size and number of files.
  • Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.
  • Monitored and troubleshoot database and server performance at system-wide scale and eectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks.
  • Transferred data between several servers using BCP and DTS.
  • Generated reports extensively using SSRS.
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.
  • Environment: Windows 2012R2-2016, SQL Server 2014-2017, SSMS, Profiler, Extended Events, Perfmon, RAID

Education

Bachelor of Science - Computational Science

Washington State University
Pullman, WA
05.2016

Skills

  • Windows 2008-2012R2, SQL Server 2008-2019,
  • T-SQL
  • AWS-RDS, AWS-EC2
  • IDERA SQL diagnose Manager
  • Log shipping
  • Data compression
  • SQL server analysis services
  • SQL server reporting services
  • SQL server agent
  • Query optimization
  • Index maintenance
  • Performance tuning
  • Backup and recovery
  • Disaster recovery
  • Database mirroring
  • Relational databases
  • Database administration
  • Database management
  • Running backups
  • Data migration
  • Patch management
  • Database backup

Accomplishments

    Demonstrated strong capabilities as a DBA, delivering measurable improvements in system performance, uptime, and data integrity through proactive monitoring, tuning, and automation.

Certification

  • Certified MS SQL Database Administrator
  • AWS Certified
  • Oracle DBA
  • PostgresQL
  • MongoDB

Software

SQL Server Management Studio (SSMS)

Azure Data Studio

SQL Monitor (Redgate)

SQL Server native backup/restore (Maintenance Plans, SQL Server Agent jobs)

Commvault

Timeline

SQL Server Database Administrator

Mobivity
09.2023 - Current

SQL Server Database Administrator

Union Bank
03.2018 - 09.2023

SQL Server Database Administrator

Bank of America
06.2016 - 01.2018

Bachelor of Science - Computational Science

Washington State University

Similar Profiles

CREATE PROFILE