Summary
Overview
Work History
Education
Skills
Leadership Activities
Certification
Timeline
Generic

Mikias Legesse

New Orleans,LA

Summary

Almost 5 years of IT experience in Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance and Performance Tuning, Backup/Restore and disaster recovery experience in SQL Server Having hands on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors and functions to meet business requirements.

Experience in SQL Server Management Studio, SQL Server Reporting Services Installation, Configuration and Maintenance using Visual Studio and Reporting Services. I am looking forward for a position in which I can fully utilize my experience in Database Administration.

Overview

5
5
years of professional experience
1
1
Certification

Work History

SQL DBA

EG&K inc
New Orleans, LA
10.2018 - 03.2020
  • Cerner Corporation designs, develops, markets, installs, hosts, and supports healthcare information technology, healthcare devices, hardware, and content solutions for healthcare organizations and consumers worldwide
  • My role in this project was to maintain and monitor servers and databases and migration of several applications from 2005 to 2008 and 2012.
  • Worked with software vendors to analyze and resolve software installation and ongoing support issues.
  • Installed, configured, and maintained SQL server 2012 , 2016, 2019 and 2022 databases on servers.

SQL DBA

NOLA DBA LLC
New Orleans, LA
03.2021 - 11.2023
  • As a DBA my role was maintaining performance, migrating databases and upgrading.
  • Created tables, views, functions, stored procedures and other database objects.
  • Extensive experience in installation, configuration, upgrading and maintenance of Microsoft SQL Server, Software products and features.
  • Worked with developers and other infrastructure team member with regards to accommodating new functionality of database interfaces.
  • Great technical skills in version migration and upgrades.
  • Experienced in close coordination with developer staff to create, configure and manage various database objects including tables, indexes, sequences, functions, procedures, packages, triggers and facilitating work of developers by resolving issues that might impede their ability to get their work done in time.
  • Expert in creation and maintenance of user security, managing users, their security privileges and accesses. Configuration and auditing of SQL Server Security in line with business requirement, manage server logins-user accounts and passwords along with database object permissions- Client/server Connectivity.
  • Ability to establish and maintain sound backup and recovery/restore policies and disaster recovery procedures to meet the business Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
  • Scheduling the backups for Databases and Transaction log, perform restoration operations proficient in high availability solutions including Always On Availability Solutions. Set up database Replication models (Snapshot, Merge, Peer to Peer and Transaction), Log Shipping, Clustering and Mirroring on Physical and Virtual machines.
  • Working Knowledge of monitoring –SQL Server Performance using profiler to find performance, dead locks, blockings resolved using DAC (Dedicated Administrator Connection) and capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Expertise in extracting and transforming data using data transformation services like import/export wizard, BCP, Bulk insert, attach/detach. Also proficient in migration /movement of data between databases.
  • Experience in developing and turning SQL Server Integration Services (SSIS) packages and Reporting Services (SSRS) creating deployment utility to Deploy SSIS Packages over Production and QA Systems.
  • Creating new and maintained existing scripts for db monitoring, database administrative tasks, automation, task scheduling and generation of various reports.
  • Capable of individual wok and a very good team player
  • Used integration services (SSIS), SQL Server Reporting Service (SSRS) for business reporting purposes and generating reports by using SSRS.

Education

Associates of Arts - Photographic, Film, and Video Technology

Master Film And Communications Plc
Addis Ababa, Ethiopia
12-2013

Some College (No Degree) - Database Management

AbroVision Global IT Training And Consultancy
Houston, TX

Some College (No Degree) - Computer Installation And Repair Technology

Vocational Education
Addis Ababa, Ethiopia

Skills

  • MS SQL SERVERS 2012 to 2022
  • Microsoft Office (Word, Excel, PowerPoint, Outlook), MS Projects
  • Adobe Premiere, Adobe Photoshop
  • Graphics Design
  • Remote Office Availability
  • Attention to Detail
  • Time Management
  • [Microsoft Official Azure Certification] Certified

Leadership Activities

  • Former Vice President of Management club, University Of Houston -Downtown
  • Active Member of ILM (Illuminating through Literacy Movement)
  • Volunteer at Houston Food bank

Certification

  • Azure Certification.

Timeline

SQL DBA

NOLA DBA LLC
03.2021 - 11.2023

SQL DBA

EG&K inc
10.2018 - 03.2020

Associates of Arts - Photographic, Film, and Video Technology

Master Film And Communications Plc

Some College (No Degree) - Database Management

AbroVision Global IT Training And Consultancy

Some College (No Degree) - Computer Installation And Repair Technology

Vocational Education

Similar Profiles

CREATE PROFILE
Mikias Legesse