Database Administrator Data Entry

ALEMAYEHU TESFAYE

945-***-**** · *********.********@*******.***

https://www.linkedin.com/in/alemayehu-tesfaye-/

DATABASE ADMINISTRATOR

Seasoned Database Administrator with 4 years of hands-on experience in managing mission-critical Microsoft SQL Server environments. Proven expertise in all aspects of the database lifecycle, including installation, configuration, administration, optimization, and disaster recovery. Skilled in migrating scripts to production, developing custom stored procedures and ETL solutions using SSIS, and implementing reporting tools like SSRS and Power BI to meet evolving business needs. Committed to leveraging this diverse technical skillset to excel in a database management and development role.

Database Administration • Database Design / Maintenance • Solutions

Script Automation • Big Data • Project Management • Analysis

Languages: Python, SQL, React, PowerShell, Power BI

Databases: MS SQL, MySQL

Tools: SQL Server Management Studio (SSMS), MySQL Workbench, GitHub, PowerShell ISE, Azure Data Studio, Visual Studio Code

Platforms: Windows, Azure, Linux

Big Data: ETL, Python, SSIS, SSAS, Power BI, Data Warehouse, Data Factory, Migration, Integration, Dataset, Architecture Design.

Soft-Skills:

Strong work ethic, professionalism, and attention to detail

Excellent collaboration and communication skills, able to work effectively in a multidisciplinary team environment

Highly self-motivated and adaptable to learning and understanding new technologies.

Efficient time management and priority setting abilities

Analytical mindset with the ability to manage requests and deliver quality results

PROFESSIONAL EXPERIENCE

Data & IT Service, Dallas, TX, US · 2022- Present

Data & IT Services is a leading provider of comprehensive data management and IT solutions that help businesses unlock the full value of their data and technology assets.

Database Administrator

Designed, implemented, and managed enterprise-level database systems, including database architecture, data models, and schema designs, to ensure optimal performance and scalability across Microsoft SQL Server, MySQL, and Azure SQL platforms

Created complex SQL queries, stored procedures, and functions to perform ETL operations from various sources into the database using SQL, Azure Synapse Analytics, SSIS, DTS Packages, SSAS, dimensional modeling (Star Schema, Snowflake Schema), and Power BI

Conducted regular database performance tuning, query optimization, and indexing to boost system efficiency, reduce response time, and enhance overall database performance using tools like SQL Profiler, Extended Events, Query Store, Index Tuning Wizard (DTA), and Windows Performance Monitor

Implemented comprehensive backup and recovery strategies to ensure data integrity and business continuity in case of system failures or disasters, maintaining Recovery Point Objective (RPO) and Recovery Time Objective (RTO)

Administered database security measures by enforcing access controls, authentication mechanisms, and encryption techniques to protect sensitive data

continued …

ALEMAYEHU TESFAYE · Page 2

945-***-**** · *********.********@*******.***

Collaborated with cross-functional teams, including software developers and system administrators, to integrate and migrate data to the Microsoft Azure cloud

Partnered with cross-disciplinary teams, including developers and system administrators, to integrate and migrate data to Microsoft Azure cloud environment

Employed SQL Server Integration Services (SSIS) and various ETL tools to create and sustain efficient data integration workflows, facilitating smooth data flow to the data warehouse for analytical purposes

Monitored and addressed database issues such as performance bottlenecks, data corruption, and connectivity challenges

Performed regular database capacity planning and devised strategies to manage increasing data volumes and user needs

Established database monitoring and alerting systems using SQL Server Agent Job and Windows Scheduler to proactively detect and resolve potential issues, ensuring optimal availability and performance

Maintained up-to-date knowledge of the latest database technologies, trends, and best practices, continuously improving skills and knowledge

Technologies Used: Python, SQL, SSIS, SSAS, SQL Server, MySQL, Azure SQL, PowerShell, Data Warehouse, Power BI

USAID/PMI Funded IRS Project, Addis Ababa, Ethiopia · 2019 - 2021

The USAID/PMI Funded IRS Project is a malaria control program that provides technical and logistical support to the Ethiopian government to implement and sustain high-quality indoor residual spraying (IRS) campaigns as a key malaria vector control intervention.

Database Engineer

Installed and Configured SQL Server Instances in Development, Staging, and Production Environments.

Installed and configured SQL Server instances across different environments (development, staging, production)

Performed various database administration tasks, such as: Upgrading RDBMS (SQL Server, MySQL) Migrating databases, changing server configuration parameters, Transferring system databases and Managing user accounts and logins

Created new databases and implemented comprehensive backup strategies, including transaction log backup, differential backup, and full backup, with different recovery levels (simple or full)

Documented the databases and configurations for the development, staging, and production environments

Designed, implemented, and maintained the internal Extract, Transform, Load (ETL) pipeline, and developed a framework to automate the process using SQL agent jobs, while also suggesting process improvements

Developed and tested PowerShell scripts, T-SQL stored procedures, and SQL functions for monitoring and administering databases across different environments (development, staging, production)

Performed various database-related activities, such as automation, proactive performance monitoring, system tuning, and query optimization

Identified and resolved locking and blocking issues, and provided analysis on the causes and their impacts

Implemented data reporting systems, including designing and provisioning security access

Technologies Used: SQL Server, MySQL, PowerShell, SQL, SSIS, JOSN, Power BI, Data Warehouse

ACADEMIC PROJECTS

Migration of Legacy Database to SQL Server 2019 (2019): Led a database migration project, successfully upgrading a legacy SQL Server 2008R2 environment to SQL Server 2019. Conducted

continued …

ALEMAYEHU TESFAYE · Page 3

945-***-**** · *********.********@*******.***

extensive testing to ensure compatibility and developed a detailed migration plan. Executed the migration with minimal downtime and ensured data integrity throughout the process. Enhanced query performance and implemented indexing strategies to boost overall system efficiency.

Technologies Used: SQL, SSMS, SSAS, SSIS

School Data Cloud ETL Migration (2021): Implemented the migration of school administration data to a Azure cloud for a student project. Utilized Microsoft Azure Data Factory to transfer from on-prem data to cloud Azure blob storage. Developed ETL pipelines and performed data transformations, facilitating scalable data processing and enhancing administrative operations in a cloud environment.

Technologies Used: Azure Cloud, Data Factory, Azure Synapse Analytics, SSIS, Azure Blob

EDUCATION

Certificate in Database Administration, ETL Development, and Azure Analytics

(Completed in 2019)

Dynamo Data – Certified Data Mastery Bootcamp, Dallas, TX, US

Key Coursework and Skills Gained: Administering and optimizing SQL Server databases, Developing ETL pipelines and stored procedures using SSIS,

Implementing cloud-based data analytics solutions on Microsoft Azure, Hands-on projects applying modern data engineering best practices.

Contact this candidate