Server Administrator Database

Bamlak Befekadu

Tucker, Georgia

Email: ****************@*****.***

Phone: +1-470-***-****

PROFESSIONAL SUMMARY

5+ years’ experience in administration of MSSQL servers.

Hands on experience on Installing, Configuring, administering MSSQL Server in development, QA and production environments while ensuring their performance, availability, and internal/external security as production support database administrator.

Excellent experience with software installations and patches (including Service Packs, Cumulative Updates and Hot Fixes) using change and release management processes.

Solid understanding of user management and database security at different levels.

Perform database recovery from logs, hot & cold backups, Export/Imports, and Disaster Recovery.

Good knowledge of design and database modeling.

Solid experience in performance tuning, and troubleshooting using native tools like Query store, Perfmon Counter, Dynamic Management Views (DMV), Extended Event and Profiler or third-party tools.

Experienced in creating automated recurring or redundant database tasks.

Worked closely with System, Network, Security Engineers, Developers, Tasters on verification and implementation in database/SQL Server related activities.

Work as production support and troubleshot errors and incidents.

Create and update documents on server inventory, standard procedures, naming conventions and technology features.

Excellent communication, coordination, presentation, and analytical skills.

Work on 24X7 operational support, involved in an on-call rotation.

PROFESSIONAL EXPERIENCE

Client: Acrisure Dallas, Texas Jan 2021 to present

Role: MSSQL Server Administrator

Responsibilities:

Handle Production support and troubleshot errors and incidents.

Manage Installation, Configuration, Upgrades, Capacity Planning of SQL servers.

Conduct performance Tuning and troubleshooting as needed.

Designed and Managed database maintenance plans including backups, Index optimization and statistics.

Administer database security by creating server logins for Windows groups and assigning appropriate permission using database and server roles.

Configure and administering High Availability and Disaster Recovery Solutions such as: Log Shipping and AlwaysOn Availability Group

Handel maintenance of multiple environments (Development, Testing, and Production), including patching, backups, security, and space management.

Proactively monitor database for errors and respond quickly and effectively to troubleshoot and resolve on-going issues in all environments.

Manage space usage, Job failures, customer complaints in the daily routine works.

Use SQL Server Profiler, Event viewer, Query Store, Activity Monitor, and other local tools to troubleshoot and resolve performance issues.

Providing technical support and working with Network, security, and development teams.

Worked on and deployed SQL Server Integration Services (SSIS) packages.

Provided 24/7 production support on rotation base.

Client: Truist Bank May 2019 to Dec2020

Role: MSSQL Server Administrator

Responsibilities:

Performed database creation, decommissioning and database migrations from 2008 to 2016 Version.

Implemented database security and auditing features and periodic reviews.

Worked as production support DBA and ensure database stability and performance as well assist day to day activities. Conducts root cause analysis for repeated incidents.

Worked closely with application team to accommodate design and administrative needs, such as working on effective solutions for databases and deployment of changes to higher environments.

Designed documents and implemented effective utilization of resources for optimal performance and enforces database standards and user guidelines.

Coordinated and scheduled database downtime to perform database maintenance procedures like database patching, upgrades, migration.

Add and maintain users on the SQL Servers Databases; assigning access, ensuring security, and maintaining their configurations are within standards.

Formulate backup strategies based on client SLA as well as RTO and RPO as well as design and implement high availability and disaster recovery solution.

Automat routine database maintenance jobs like index defragmentation, statistics update, integrity checks, cleanup, monitoring …etc. jobs using SQL server agent.

Use tools like SQL profiler and performance monitor to identify bottlenecks in query performance.

EDUCATION AND OTHER SKILLS

University of District of Columbia, Bachelor of Science in Computer Science

General Assemble Full stack.

Administration Microsoft Azure SQL Solution

Contact this candidate