Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Tsion Bekele

Summary

Certified Azure Database Administrator/ SQL Server DBA with over 7 years of experience in database management, backup / recovery, implementing database modifications, and upgrading databases. Proficient in administering SQL Server v.2016, configuring Always On availability group, TDE to encrypt data, performing capacity planning, performance tuning, monitoring, troubleshooting, and optimizing databases Highly skilled at database maintenance, performance tuning and Optimizations; On-Prem to Cloud Migration, High Availability and Disaster Recovery Solutions I ma a passionate contributor to team success with records of empowering teams. A self-starter who is always motivated to learn, grow, and stay current.

Overview

6
6
years of professional experience
1
1
Certification

Work History

SQL Database Administrator II

NWH
Frisco, TX
04.2022 - Current
  • Have Over 7 years of experience in Administering SQL Server databases in production
    environments, ranging from 2012 to 2019 versions. Install and configure SQL Server 2016 database in standalone/cluster environment with availability groups. T-SQL scripts, RedGate
  • Azure Cloud professional with strong experience in migrating resources to Azure, Azure
    Administration, Azure Infrastructure Operations.
    Produced high-standard database solutions to meet stability, reliability. Bash and PowerShell
  • Create and deploy ETL packages to achieve various task using Azure Data factor (ADF). Automate Backups, refreshes, maintenance Jobs, Bulk inserts data migration, data extraction, transformation and loading from multiple data sources
  • Proactively monitored database performance using AWS CloudWatch and other monitoring tools, identifying and resolving performance bottlenecks, and optimizing query execution.
  • Designed and developed analytical data structures.
  • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed instances. Configured High Availability Solution; Always-On, Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modelling, High-Availability (HA) and Disaster Recovery (DR)).
  • Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Manage database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent. Stored Procedures,
  • Automated and reduce workflow with the help of store procedures, scripts, Redgate and Microsoft Integration services, that runs daily to reorganize, rebuild, update statistics, Backup.
  • Configured Transparent Data Encryption using AES256 Algorithm to make sure that all databases are fully encrypted and secure from Hackers and Malicious users,
  • Managed Servers and database level Security by Implementing the Triple As (AAA); Authentication, Authorization and Auditing. All User are Authenticated through the various security protocols, and are Authorize to resources, and audit all activities. Stored Procedures
  • Migrated VMs, SQL Databases from On-Prem to AZURE, configure Geo-replication for High availability, Azure Site Recover and manage database on Elastic pools and Manage instances.
  • Setup and manage Always-On High Availability for HA/DR, Log shipping to automate and Synchronize Backups to secondary server for Disaster recovery as an addition security for Mission Critical databases in our environment. Linux Administration, and Window's Server.
  • Create Data Models for new and modernized legacy Databases, implement database design following best practices to maximize performance and reduce data redundancy.
  • Experienced on migrating AWS database to Azure cloud VM.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Supported projects enabling delivery efficiencies and technical resolution.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.

SQL Database Administrator

VanDyke Energy
Houston, TX
08.2019 - 02.2022
  • Installed and upgrade SQL Server 2012 or greater and, applied security fixes. SQL Server
    Profiler, Query Store and Database Engine Tuning Advisor (DTA) for performance. Virtualization
  • Expertise in driving deployment of customers' workloads into Azure and increasing satisfaction of by providing deployment guidance and support. Performed Database Migration from On-Premises SQL environment to Azure Database
  • Create centralized management server for simultaneous queries and master server to push SQL Server Agent jobs to each server. Organize DBA meetings to brainstorm strategies
  • Set up user profiles and access levels for database segment to protect essential data, Creating, granting, and monitoring user access rights and privileges through roles and profiles.
  • Minimized downtime by optimizing and monitoring High Availability for SQL Server, applying Database Mirroring, Log Shipping, Traditional Failover Clustering, and Always-On.
  • Implemented backup strategy following company SLA; physical cold and hot, and logical using
  • Responsible for administering SQL Server databases through multiple product lifecycle environments, from development to critical production
  • Developed and managed enterprise-wide data analytics environments
  • Trained non-technical users and answered technical support questions
  • Scaled solutions and optimized processes by utilizing DBA knowledge to perform database architecture tasks
  • Collected, outlined, refined requirements, led design processes, and oversaw project progress
  • Used TDE to encrypt data at rest as well as in transit
  • Used TDE to perform real time I/O encryption and decryption IG the data and log filers to protect at rest
  • Used TDE to encrypt SQL server and azure SQL database data files at rest.
  • Headed the upgrading of Microsoft SQL server, failover clustering, log shipping, and replication
  • Utilized system monitoring / SQL server profiler to identify bottlenecks, discover slow running queries, performed backup / recovery databases, and implemented database modifications on production servers
  • Performed development of database including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs
  • Configured / administered Always on availability group with one primary and two secondaries
  • Designed / configure large - scale cloud - based migration solution, migrating applications to Azure, IaaS and PaaS with security integration
  • Experience new features implemented by azure to reproduce / troubleshot azure end - user issues and provide solutions to mitigate the issue

Lead SQL Server DBA

CTI Bank
Denver, CO
05.2018 - 07.2019
  • Managed SQL Server databases through multiple product lifecycle environments from development to critical production
  • Documented and analyzed processes and procedures and adhered to regulatory guidance
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Developed, implemented technical application support / information technology policies, procedures that advanced investment needs, outcomes, and performance measurements to balance continuous innovation with responsible risk-taking
  • Fostered behaviors that support the National Bank of Ethiopia guidelines / values by creating an atmosphere of cooperation, responsibility, and accountability to the bank
  • Analyzed, solved, and corrected issues in real-time and gave an end-to-end resolution
  • Monitored and evaluated database performance to streamline and improve consistency in service levels
  • Ensured all SQL Application servers were properly installed, configured, upgraded, and reducing downtime to zero
  • Upgraded Microsoft SQL server as well as performed failover clustering, log shipping, replication, using System Monitor and SQL Server Profile

SQL Database Administrator

Piedmont Healthcare Corporate
Atlanta, GA
12.2017 - 04.2018
  • Leveraged exceptional professionalism / field expertise to set up, maintain, support SQL server high availability & disaster recovery solutions such as always on availability groups, failover clustering, mirroring, log shipping, and replication
  • Designed and implemented database backup and restored policies and request procedures
  • Worked with developers to improve referential, domain, and column integrity using constraints
  • Implemented and tested point - in - time recovery restores of production databases on test servers
  • Implemented SQL server security auditing, hardening, and remediation
  • Wrote / coded logical and physical database descriptions, specifying identifiers of database to management systems
  • Automated routine maintenance tasks, including routine database refresh requests using SQL server agent, maintenance plans, and PowerShell scripts
  • Performed backup using backup compression and data compression in SQL server databases
  • Maintained and troubleshot SQL performance issues using cycling the SQL server error logs, activity monitor, DTA, BCC, DMVs, and SQL profiler
  • Completed SQL server upgrade and migration from earlier versions to SQL server 2012 / 2014 / 2016 / 2017
  • Applied SQL server performance tuning and query optimization and used SQL Profiler, DTA, Query Execution plan, and Indexing maintenance
  • Performed Database Migration from On-Premises SQL environment to Azure Database in cloud
  • Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows to improve performance and manage storage
  • Created optimal technical solutions to user needs with in-depth system analysis.

Education

Bachelor of Science - Computer Science

Dilla University
Ethiopia
01.2014

Skills

  • Installed SQL in standalone/Clustered
  • Azure AD connect & Federation services
  • Database Migration to Microsoft Azure
  • Log Shipping, Always-On High Availability
  • Performance Monitoring & Tuning
  • Performance Monitoring & Tuning
  • Expert in SQL server high availability & disaster recovery solutions
  • Experienced on AWS console
  • Configured (TDE) to Encrypt All databases
  • Managed Azure compute and services
  • ETL: SSIS, Azure Data Factory (ADF) SSRS
  • Experience on AWS cloud Watch

Certification

  • Microsoft Certified: MSSQL Server Database Administrator
  • Microsoft Certified: Azure Database Administrator Associate DP-300
  • Power BI and Dashboard training

Timeline

SQL Database Administrator II

NWH
04.2022 - Current

SQL Database Administrator

VanDyke Energy
08.2019 - 02.2022

Lead SQL Server DBA

CTI Bank
05.2018 - 07.2019

SQL Database Administrator

Piedmont Healthcare Corporate
12.2017 - 04.2018

Bachelor of Science - Computer Science

Dilla University

Similar Profiles

CREATE PROFILE
Tsion Bekele