Professional Summary

Dynamic and creative database administrator with over 20 years of experience producing detail-oriented results in various IT and business environments, having over 10 years of experience as a SQL Server DBA performing detailed analysis and troubleshooting different Microsoft products, SQL Servers features, and Operating Systems. Robust experience in managing (migrating, updating) all aspects of a large databases in 24/7 data processing environmentt and in depth knowledge and experience in data modeling, gathering and analyzing business and technical requirement while working in agile and waterfall methodology projects.

Certification & Training

DAT202.1x: Processing Big Data with Hadoop in Azure HDInsight

MCTS (70-432) - SQL Server 2008 Implementation and Maintenance

MCITP (70-450) - SQL Server 2008 Designing, Optimizing and Maintaining a Database

MCDBA - Microsoft Certified Database Administrator (2000)

MCSE - Microsoft Certified System Engineer (Windows Server 2003)

Principles of Project Management - University Learning Institute

Certification of completion on AWS Solutions Architect.

TECHNICAL SKILLS

Database - SQL Server 2016/2014/2012/2008/2005/2000, MS Access 2010, 2003 & 2000, MS Access

SQL Tools - Query Analyzer, Profiler, Database Mail, SQL Agent

ETL Tools - SSIS/DTS, BCP, FTP

Reporting - SSRS (SQL Server Reporting Services/Server)

Data Modeling - Quest Data Modeler

Programming - SQL, T-SQL, Store Procedures, Triggers

Operating System - Windows Server 2012/2008/2003/2000, Windows XP/NT4.0, MS-DOS, VMware

Hardware/Storage - SAN, RAID

Technical Summary:

Database:

Installation, configuration and management of the different SQL Server versions(2017,2016,2014,2012,2008R2,2008,2005,2000)

Extensive experience with

oT-SQL programming using CTE and cursors

oWriting T-SQL, Dynamic queries, Trigger, and Stored-Procedures

oAutomation of tasks and jobs using Windows PowerShell scripts

oAssisted Database Developers to optimize SQL queries, Stored Procedures

Utilizing SSIS feature, data analysis, data conversion and data cleanup of mortality data of the Latin American countries with around 40 million records and this task involved the transfer of files from different type of file sources, cleansing of the data, transforming to the business rule set by the clients(to SQL Server database tables)concatenating, extracting and grouping the files according to the business rule

Monitoring, Performance Tuning, Query Optimization, Backup/Recovery, Security Management

SQL/T-SQL Programming

Strong Database Administration experience with MS SQL Server (2000, 2005, 2008,2012,2014), MS Access 2000 & 2003

Perform database upgrades from SQL Server 2000 to 2005/2008, SQL Server 2005 to 2008 and SQL Server 2012 and to 2014

Working in VMware virtualization supporting virtual Windows 2012 servers where SQL Server 2012 databases are managed

Migration of Oracle and MySQL database to SQL Server 2005 and 2008

Deployed large databases to development, test and production environment

Preparing Change Management Requests (CMRs) for large data deployment and large data updates

Preparing SQL Performance tuning baseline using the native tools like PerfMon, SQL Profiler, Dynamic Management Views

Strong work experience and knowledge with SQL Server Database High availability using Clustering, Standby/Replication, Database Mirroring, and Log shipping

Web/Application Server Administration:

Experiences administering Web Server (Internet Information Services or IIS) that include installing, and configuring and administration

Deployment of different applications to development, test and production environments

Operating Systems:

Working experience on Operating Systems (O/S) include Windows Server2012/ 2008/2003/2000 Server, Windows 2000/XP/7

Working experience also includes installing, configuring, and administering the above operating systems

Networking:

Designed and Managed network using HUB, ROUTER, and SWITCH

Administration and management of user accounts in AD (Active Directory) in Windows 2000/2003/2008/2012 Server

Participated on the application of SAN storage for redundancy, high availability and scalability business requirement for PAHO

Professional Experiences:

SQL Database Administrator Lansing, MI Apr 2019 - Present

State of Michigan

Working on SQL Server 2008 R2 clustered (Active/Passive) environment, SQL Server 2014, SQL Server 2016

Managing different sizes of database up to the 3.5 TB and during the migration process moved the database using the SAN detach and attaching to the legacy and new location and using the MoveIt ftp applications

Installed and configured SQL Server 2016 as well as the SSDT and SSMS

Use PowerShell script to automate daily SQL Server Tasks

prepared the SQL Server Performance tuning Baseline for the specific servers in the department

As a DBA, led the SQL Server 2008 R2 server and database (With sizes of 3.5 TB) migration to SQL Server 2016 as well as various databases from different servers to SQL Server 2016 servers

During the migration of various SQL server database from 2008 R2 to 2016, setup up data transfer jobs using SSIS feature of SQL Server and configured the packages and configuration files relevant to the new environment

Utilizing the Red Gate tool to monitor the SQL server databases’ performance and the native tools such as PerfMon to monitor both the SQL server and database performance issues as well

Utilized basic Linux commands, to perform various of the data transfers during the migration process

SQL Database Administrator Washington, D.C. Mar 2014 - Mar 2019

Pan America Health Organization (PAHO)

Managed 12 regional SQL server 2012 servers on Windows server 2008 operating systems

Performed data analysis, data conversion and data cleanup of mortality data of the Latin American countries with around 40 million records and this task involved the transfer of files from different type of file sources

Transformed business rule set by the clients (to SQL Server database tables) concatenating, extracting the files according to the business rule set

Managed around 300 SQL Server 2012 share point databases on Windows 2012 servers

Using the SSIS feature of SQL Server 2014 as ETL tool, transferred Health data from different sources (Excel, CSV large fixed width text files, access files etc.) to SQL Server Databases

Deployed the SSIS packages in SQL Server 2014 using the Integration Services Catalog for the transfer of different types of health related data files from Latin America countries to Centralized warehouse and apply different SSIS task for transforming them to SQL Server database tables.

Installed SQL Server 2017, SQL Server 2016, SQL Server 2014 with SP1(Patches) /SP2 on a new Windows 2012 server and migrated databases from SQL Server 2008 R2 server, SQL server 2005 server

Created backup maintenance plan for the above system and user databases and maintenance plan reports as well

Managed the backup process of different regions (around 19 countries of Latin America) to be restored to the Head quarter server on daily bases which are used for different reports purposes in the head office using the FTP or the Remote administration utility

Using Microsoft certification MSCE (Microsoft Certified System Engineer), worked with infrastructure team managing the Active Directory (creating users, groups and authorizing access to resources)

Became primary point of contact (on-call) for the issues with the infrastructure after business hours and weekends for one week each month

Led effort as a member of the change management process (CMP) team, checking all changes were recorded, documented, evaluated, authorized, prioritized and make the required impact analysis on projects such as the SQL Server 2014 upgrade

Worked on data modeling using ERWIN data modeler

Gained extensive knowledge of the policy-based management system for the control and automation of different SQL tasks

Managed and operated the Epicor Enterprise Resource Planning (ERP) application (EPICOR 9.04) for inventory and finance applications in PAHO with PALTEX. Created a databases backup, restore and disaster recovery policy

Utilized the ftp protocol to transfer files from remote servers and prepared queries from these data sets to be used In the Crystal Reports generation effort

Managed the financial data for Epicor ERP OLTP financial with volatile data application

Managed a VBA application for different Health related information for Latin American countries.

Migrated Access databases to SQL Server 2014 using the SSMS.

Prepared SLA with the hosting company regarding the database backup and restore policies of the Epicor system

Prepared Backup/Restore, Re-indexing and Statistical Update using the maintenance plan. Prepared the hourly transactional, daily differential and the weekly full backups for the production databases.

Managed to prepare the SQL Server Performance tuning Baseline for the all servers in the 19 countries

Troubleshooting SQL Server performance issues with SQL Server in-built tools like Dynamic Management Objects such as Sys.dm_os_wait_stats, sys.dm_os_waiting_tasks, etc., different Dynamic Management Views, and third-party tools like Red Gate SQL Monitor.

Implemented SAN storage for redundancy, high availability and scalability business requirement for PAHO, especially applying redundancy of local data backups in the SQL Server data in the VMware hosts

Installed SQL Servers 2008 R2 with SP2 upgrade on new servers and migrated different databases from SQL Server 2005

Participated on a SQL 2014 Upgrading project, which involved the inventory processes of all SQL servers existing in the organization by using MAP tool kit and applied the SQL Server 2014 Upgrade Advisor for any data type and compatibility issues to be dealt with. Project involved around 25 SQL Servers of different versions (SQL Server 2005, SQL Server 2008, SQL Server 2008 R2) to upgrade to SQL Server 2014.

Configured new SQL Server 2014 (for the Test and production environments) for the preparation of the upgrade process.

Performed the required Capacity planning preparation for the upgrade from physical server to virtual servers, performance of the new virtual servers with regard to disk space and index utilization

Transferred DTS packages to SSIS packages before migrating to SQL Server 2014.

Gained practical experience and excelled in the design and creation of databases for PAHO, especially with the health department

Prepared SQL Server Performance baseline for different servers for monitoring performance, server disk space, log files and the success of assigned jobs

SQL Database Administrator Upper Marlboro, MD July 2013 - Feb 2014

Maryland Vehicle Administration (MVA)

Database administration

oManaging over 27 branch servers Databases Server (Development, Test, and Production environments)

oManaging different databases on these servers

Database Programming:

oExtensive use of T-SQL programming using CTE and cursors

oWriting T-SQL, Dynamic queries, Trigger, and Stored-Procedures

oAssisted Database Developers to optimize SQL queries, Stored Procedures

oTools Used: Query Analyzer

Report Development:

oInstalled, Configured, and administered SQL Server Reporting Services (SSRS)

oDeveloped, Deployed, and Managed Reports

oManaged Reports Security

Database High Availability:

oInstalled, Configured and Maintained Database Mirroring using automatic fail-over option

oConfigured Log Shipping as Standby database from Production database for Reporting purposes

oConfigured and Maintained Transactional Replications

DTS/SSIS

SQL Database Administrator/DBA Alexandria, VA Jun 2011 - Jun 2013

Department of Labor

Database Upgrades, Migration and Patch Management

oManaged over 34 Databases Server (Development, Test, and Production)

oManaged Application/Web Server (IIS 5.0, 6.0,6.5, 7.0, 7.5)

oManaged SQL Servers databases in different environments (Development, Test, and Production)

oInstalled, Configured, and Managed SQL Server 2008, 2005 & 2000 in development, test, and production environment

Report Development:

oInstalled, Configured, and administered SQL Server Reporting Services (SSRS)

oTools Used: Developed Reports using BIDS (Business Development Studio), and Report Builder 3.0, 2.0

Data Modeling:

oWorked on more than 10 data modeling projects and generated E-R Diagram

oBackward & Forward Engineering with data modeling tools mentioned above

Database Monitoring/Performance Tuning

oStrong and solid knowledge on database Monitoring and Performance tuning

oMonitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works

oApplied different maintenance plans for the automation of daily activities

oTools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter,etc.

Database Programming

oWritten T-SQL, Trigger, and Stored-Procedures

oAssisted Database Developers to optimize SQL queries, Stored Procedures etc.

oTools Used: Query Analyzer

DTS/SSIS

Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well

Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views

Developed Different Maintenance Plans for database monitoring

Monitored Server Activity, Error Log, space usage, and solving problem as needed

Maintained service-related reports (backups, maintenance plan)

Deputy Manager & IT Manager Kigali, Rwanda Aug 2008 - Feb 2010

Simba Department Store

Installed and configured SQL Server 2000 and took backups, restored data, and created different jobs

Installed the LAN for the department store

Managed the Windows Server Operating system in regard to security and disk space management and created security policy for the organization

Managed the financial and inventory-based application databases

IT Consultant - Elizabeth Glaser Pediatric AIDS Foundation - Ethiopia - Feb 2004 - May 2005

Studied the existing system and proposed the hardware such as server with its operating system and other interrelated devices necessary for the upgrade. Installed, maintained and troubleshoot various applications on the proposed servers

IT Department Head for the Department of National Defense of Ethiopia - Apr 1995 - Jan 2004

Administered the IT department for the Ministry of Defense

Supervised programmers, hardware engineers in the department

Managed the local area network for the department

Junior programmer - The Ethiopian Sugar Corporation - May 1992 - Mar 1995

Utilized COBOL programming language to create, design, and maintain an accounting application

Education:

B.S. Mathematics - Addis Ababa University, Ethiopia

Contact this candidate