Ebrahim Abebe

Alexandria VA

Email: adzocc@r.postjobfree.com

Phone: 206-***-****

EDUCATION:

●Masters in Engineering, GMU, Fairfax VA (May 2020)

HONOR SOCIETY:

●Golden Key International Honor Society Member

Clearance:

Secret Clearance (Active)

CERTIFICATION & TRAINING

●AWS certified (SA)

●MCSA - (Microsoft Technology Solutions)

oData Warehousing

oT-SQL writing

oSQL Engine Administration

●MCP – (Microsoft Certified Professional)

●MCITP - (Microsoft Certified IT Professional) - Database Administration: SQL Server 2008

●Training on:

oSSIS (SQL Server Integration Services)

oSSRS (SQL Server Reporting Services)

oSQL/T-SQL Programming

CAREER OBJECTIVE:

Over 10 years of experience in the IT industry. Over 5 years of Hands-On Professional Experience as an AWS Engineer and worked on migration to AWS as well as provisioning of resources in AWS using Terraform and configuration of same using Ansible. Over 7 years of experience as a SQL Server DBA/Developer with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server (2000, 2005, 2008, 2012,2014,2016), Operating Systems, AD (Active Directory), data modeling including gathering and analyzing business requirement, solid working experience in managing large databases in 24/7 environment including backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints, DBCC, etc. Working experience entails strong working experience on using database third party tools like Idera, SpotLite, ERWin, Visio, Toad Data Modeler, and Toad for SQL Server Admin.

Quick Profile:

AWS

Terraform and Ansible for IaC and CaC

DMS Operations team member with a high privileged access

Subject Matter Expert in Data and Schema Migration

Knowledge Bar raiser at AWS RDS and DMS teams

Worked with RDS PostgreSQL, SQL Server, MySQL and Oracle

Worked on Red Shift Data warehouse

AWS services IAM, Cloud Watch, SNS, EC2, VPC, SG, and many more

Database:

SQL Server 2016,2014,2012,2008/2005/2000, MySQL (4.0.3, 5.0.1), MS Access 2003 & 2007

Database Migration: Oracle 11g, 10gR2, MySQL (4.0.3, 5.0.15)

SQL Server Tools

SQL Server Management Studio, Enterprise Manager, Business Intelligence Development Studio, Query Analyzer, SQL Profiler, SSIS and DTS, Replication, Clustering, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Configuration manage/Surface Area Configuration and Service manager, Client and Server Network Utilities

Operating System:

Windows Server 2012/2008/2003/2000, Windows XP/7, MS-DOS, VMware

Languages:

C#, SQL, T-SQL, Stored Procedure, Function, Trigger, HTML, DHTML, ASP, ASP.NET

Reporting:

SSRS (SQL Server Reporting Services)

Data Modeling:

SSDD (SQL Server Database Diagram)

Third-Party Tools:

Idera, SpotLite, ERWin, Visio, Toad Data Modeler, and Toad for SQL Server Admin

Hardware/Storage:

SAN, RAID

Technical Summary

●AWS DMS and SCT Subject Matter expert

oTerraform, Ansible, Packer, and Jenkins for IaC and CaC

oDMS Operations team member with a high privileged access

oKnowledge Bar raiser at AWS RDS and DMS teams

oWorked with RDS PostgreSQL, SQL Server, MySQL and Oracle

oWorked on Red Shift Data warehouse

●AWS services IAM, Cloud Watch, SNS, EC2, VPC, SG, and many more

●Deep understanding and working experience of SQL Server (SQL 2000, SQL 2005, SQL 2008, and SQL 2008 R2, 2012,2014,2016), MS Access, MySQL includes installation, configuration, and maintenance of standalone and Clustered Servers Active/Passive Cluster Design

●Performed Data Modeling, data analysis, database design, and developing E-R diagram using ERWin, Database Diagram

●Optimizing and Performance Tuning, Query Optimization, Performance Tuning using execution plan, Profiler, Database Tuning Tool, Windows Performance Monitor

●Experience in resolving Dead Locks or long running queries and slow running server

●Performance monitoring using different tools comes with the MS SQL Server and third party tool like SpotLite, Idera SQL Diagnostic

●Working experience with the new features of SQL Server 2008, 2008 R2, 2012,2014 such as database mirroring, online indexing and recovery

●Expert of database Backups and Restoration

●Strong knowledge and experience in configuring and administering High Availability Database like Database Mirroring, Replication, Log shipping, Cluster Database, Always on Availability and Availability Group

●Vast knowledge and working experience on SSIS, DTS, SQL Server Reporting Services, scripting for customized Report Generation

●Knowledge of Microsoft Best Practices with regards to configuration of SQL data/log drive locations

●Experience with Security and Audit Management

●Strong working experience in installing, upgrading, and maintaining Web servers (IIS) and Operating Systems: Microsoft Windows Server Family (2000,2003, 2008, 2012)

●Installing and configuring VMware and Synergy

●Applied Service Pack (SP) and hot fixes for Databases, Operating Systems

●Migrated databases from other databases like Oracle 10g, MySQL, Sybase to SQL Server 2008,2012,2014

●Upgraded databases from MS SQL Server 7, 2000, 2005 to MS SQL Server 2008

●Deployed Databases in Test, Dev and Production environment

●Deployed web-based applications, websites in the application/web-server like IIS (Internet Information Services)

●Strong Data Modeling Experience as worked on more than 15 data modeling projects including gathering and analyzing business requirements

●Strong working experience in creating and supporting database administration scripts; scheduling jobs

●Working experience in configuring and setup mail server for database mail notification

●Good customer support experience in providing end-user support on a day-to-day basis

●Working experience with SAN and RAID

●Experience using Configuration Tools such as SQL Server Configuration Manager and SQL Server Surface Area Configuration

●Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers

●Installed and maintained Microsoft Reporting Services [MSRS] on 2000 and SQL Server Reporting Services [SSRS] 2005 and 2008, 2012,2014

●Experience in creating and scheduling SSIS/DTS packages

●Database Migration: Migrated Oracle 10gR2, MySQL, MS Access 2003/2000/97 databases into MS SQL Server 2008 R2

●Imported/Exported Excel, Flat file, CSV file to SQL Server Databases

●Good experience in writing and debugging SQL Server stored procedures/triggers and documenting issues/resolutions of SQL Server Applications

PROFESSIONAL EXPERIENCE:

DHS, Washington, DC May 2020 – present

●DevOps Engineer AWS (IaC and CaC)

oProvision AWS infrastructure using Terraform

oConfigure resources provisioned in AWS using Ansible

oDocker for building Images to be used for provisioning

oGitlab Repository for IaC and CaC code

oGitlab CI-CD for Orchestration

oProvide support for the whole AWS infrastructure

VPC, ACL, Sub Net, EC2, S3, SG, DMS, RDS, Red Shift

AWS, Amazon, Herndon, VA April 2016 – May 2020

●AWS DMS and SCT Subject Matter expert

oDMS Operations team member with a high privileged access

oKnowledge Bar raiser at AWS RDS and DMS teams

oWorked with RDS PostgreSQL, SQL Server, MySQL and Oracle

oWorked on Red Shift Data warehouse

oVPC, ACL, Sub Net, EC2, S3, SG, DMS, RDS, Red Shift

Capital Novus, Fairfax, VA April 2013 – March 2016

SQL Database Administrator and Developer

Responsibilities and Accomplishment:

●Managed 24/7 Database Environment

●Installed, Configured, and Administered SQL Server 2005, 2008, 2012, 2014 in development, test, and production environment

●Installed and Configured Operating System, Windows Server (2000, 2003, 2008, 2012)

●Database High Availability: Installed, Configured and Managed Database Mirroring, Replication and Log Shipping. Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2005, 2008, 2012, 2014

●C#/SQL/T-SQL, Triggers, And Stored Procedure:

oWrote SQL, T-SQL, Stored-Procedures and triggers.

oAssisted SQL developers to optimize SQL queries, Stored Procedures and Triggers

oCLR functions using C# on many occasions

oWriting C# scripts while developing SSIS packages on many occasions

●Monitoring and Performance Tuning: Performed database monitoring and Performance tuning. Monitor Servers activity, and worked with clients to solve different problems. Performed index and statistics management. Managed SQL Server Error Logs, space usage, growth pattern. Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics. Managed BLOCK and LOCK

●Database Automation: Created Backup jobs for different types of backup like FULL, Differential and Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics. Created BAT programs to move backup and other files to backup servers

●Data Modeling: Worked on different Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database. Used Backward & Forward Engineering to create Logical and Physical database

●Index/Constraints, Triggers, Stored Procedure: Created and managed Index (Cluster/Non-Cluster), Constraints

●Security Management: Created and Managed users, roles, security at object level, data encryption

●Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008/2012

●Database Migration: Migrated MS Access 2003/2000/97 databases into MS SQL Server. Migrated Oracle 10g, MySQL database into MS SQL Server 2008. Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database,

●Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups

●Reports: Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS. Developed Ad-hoc Reports using Report Builder 3.0, 2.0. Deployed Reports. Managed security for reports

DuPont Fabros Technology, Ashburn, VA March, 2010 – January, 2013

SQL Database Administrator

Responsibilities and Accomplishment:

●Maintained mission critical production database as well as production applications including Emergency off-hour support

●Installed and configured SQL Server 2000, and 2005 on Windows Server 2000 and 2003 as standalone and Clustered Servers

●Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks)

●Wrote SQL/T-SQL codes, stored Procedures, Triggers and Functions

●Helped database developers to tune up SQL/T-SQL Queries

●Applied Service Packs, and hot fixes

●Performed database backups, restored database from backup

●Replication: Configured and maintained transactional and merge replication

●Security Management: Access and security management like creating Logins with appropriate roles. creating users and groups and granting and revoking privileges for data security

●Migrated Oracle, MySQL, MS Access 2000/97 databases into MS SQL Server 2000and2005

●Standby and Mirroring: Configured and Maintained Replicated database using LogShipping and Replication in SQL Server 2000 and 2005 for high availability

●Performed performance: Using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers

●Documentation: Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices

●Reporting Services: Installed, configured and maintained SQL Server 2000/2005 Reporting Service. Managed reports and helped developers in designing and developing reports

REFERENCES: Available on request

Contact this candidate