KIBREAB FISEHA
Landover,MD
Summary
Database Administrator/Developer with 9+ years of diverse experience in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture and Business Intelligence (BI). Advanced understanding of SQL Server, SSIS, SSRS, SSAS, and Azure. Skilled in database management, performance tuning, optimization, troubleshooting,disaster recovery, backup strategies, and analyzing complex problems to develop effective solutions. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Database Administrator/Developer
Federal Aviation Administration (FAA)
01.2020 - Current
- Designed and implemented database structures to efficiently store and retrieve data
- Developed and optimized complex SQL queries to extract and manipulate data
- Performed regular database maintenance tasks such as backups, indexing, and performance tuning
- Collaborated with cross-functional teams to identify and resolve database-related issues
- Implemented and maintained data security measures to protect sensitive information
- Analyzing Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues
- Analyze and deploy scripts and packages in prod/test environments from different developers
- Implemented ETL Packages (SSIS) to extract Data from various sources like Oracle, File System, SQL Server, Json file and transformed extracted data using SSIS task and SQL Stored Procedure into de-normalized form
- Develop Tablix, drill down, drill through reports using SQL Server Reporting Services (SSRS)
- Created jobs to automate repetitive tasks using SQL Server Agent
- Involved in creation of backup/restore and disaster recovery plans for multiple servers
- Provided High availability through Clustering (Active/Passive), Mirroring, Log Shipping, Replication (Transactional), and Always On
- Created Database Authentication, configured Permissions and assigned Roles to different users
- Addressed slow performance issues in SQL server to improve database performance and minimize downtime
- Developed and implemented a plan of action for handling server outages, ensuring speedy recovery and minimal disruption to operations
- Managed over 10 team calls per day and available 24/7
SQL Database Administrator
Higher Education Services Corporation
Albany, NY
05.2018 - 01.2020
- Designed, implemented, and maintained Database Schema, Entity Relationship Diagrams, Tables, Constraints, and Indexes
- Managed Database backup and recovery of System and User databases
- Implemented database security policies to ensure data confidentiality, integrity, and availability
- Created and implemented database maintenance plans to optimize performance
- Implemented disaster recovery tools such as replication, clustering, and High availability and business continuity plan
- Conducted regular performance analysis and tuning of databases and queries
- Collected business requirements from users and translated them into technical specs and design docs
- Designed and created various Database objects such as tables, functions, stored procedures, triggers, and jobs
- Enforced Business Rules to filter bad data and implemented various Constraints and Triggers for Data Consistency
- Developed and implemented ETL process using tools such as SSIS
- Developed and maintained reports and dashboards using SSRS, Tableau and PowerBI
- Provided technical support for DB2 developer using Z/OS
- Involved in configuration of SQL Server Reporting Services (SSRS) and SQL Server to create role, security, and grant permissions to different level of users
- Designed, developed, and supported database solutions using SQL, T-SQL, SSIS, and SSRS
- Collaborated with Data Modelers and business analysts to understand requirements and the impact of ETL on the business
- Analyzed requirements and created technical documents as part of an Agile Scrum team, actively participating in daily standup meetings
- Extracted, transformed, and loaded source data into target tables to build necessary data marts
- Successfully deployed SSIS packages from development to production server
- Implemented complex T-SQL statements to filter data from transient stage to the data warehouse system
- Utilized constraints and triggers to ensure data consistency and integrity
- Utilized T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers to optimize database performance
- Developed SSRS reports from the warehouse based on business needs and effectively deployed them on report servers
- Created Users, Roles and managed security and permission of database
- Provided High availability through Mirroring, Log Shipping, Replication (Transactional).
SQL Server Database Administrator
Pfizer Inc Certified Medical Technician
03.2014 - 07.2016
- Designed and implemented database solutions, including maintaining database objects
- Conducted regular performance tuning and optimization of the database and queries to improve efficiency and response time
- Implemented backup and recovery strategies to ensure data availability and integrity in case of system failures
- Implemented data extraction, transformation, and loading (ETL) processes
- Created and maintained reports and dashboards using SSRS
- Provided technical support and troubleshooting for database-related issues, including diagnosing and resolving complex problems
- Developed and optimized complex SQL queries involving multiple tables to extract data
- Maintained log information in SQL table to track errors
- Worked closely with business analysts and stakeholders to understand their reporting needs and translate them into SSRS reports
- Provided technical support to internal and external customers on various products and services
- Provided data migration support after deployment
- Actively participated in data modeling (physical design and logical design) and performed normalization and de-normalization of databases
- Designed and created various Database objects such as tables, functions, stored procedures, triggers as per business requirements
- Involved in the entire life cycle including Database Design, Development, Testing, Optimizing, and Deploying on Development and Production Servers
- Created joins and sub-queries for complex queries involving multiple tables
- Performed data migration from SQL 2008 and 2008R2 to 2012 of SQL server
- Installed, configured, administered, and secured SQL server by creating logins and assigning server as well as database roles with business confidential information in mind
- Optimized SQL server performance using SQL Profiler, Activity Monitor in SSMS, and T-SQL query to display Execution plan
- Created jobs to automate repetitive tasks using SQL Server Agent
- Created backup/restore and disaster recovery plans for multiple servers
- Migrated DTS packages using DTS editor wizard into SSIS
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.) and loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
SQL Server Database Administrator
Marlin Steel
Baltimore, MD
08.2013 - 03.2014
- Designed and implemented database solutions, including maintaining database objects
- Conducted regular performance tuning and optimization of the database and queries to improve efficiency and response time
- Implemented backup and recovery strategies to ensure data availability and integrity in case of system failures
- Implemented data extraction, transformation, and loading (ETL) processes
- Created and maintained reports and dashboards using SSRS
- Provided technical support and troubleshooting for database-related issues, including diagnosing and resolving complex problems
- Developed and optimized complex SQL queries involving multiple tables to extract data
- Maintained log information in SQL table to track errors
- Worked closely with business analysts and stakeholders to understand their reporting needs and translate them into SSRS reports
- Provided technical support to internal and external customers on various products and services
- Provided data migration support after deployment
- Actively participated in data modeling (physical design and logical design) and performed normalization and de-normalization of databases
- Designed and created various Database objects such as tables, functions, stored procedures, triggers as per business requirements
- Involved in the entire life cycle including Database Design, Development, Testing, Optimizing, and Deploying on Development and Production Servers
- Created joins and sub-queries for complex queries involving multiple tables
- Performed data migration from SQL 2008 and 2008R2 to 2012 of SQL server
- Installed, configured, administered, and secured SQL server by creating logins and assigning server as well as database roles with business confidential information in mind
- Optimized SQL server performance using SQL Profiler, Activity Monitor in SSMS, and T-SQL query to display Execution plan
- Created jobs to automate repetitive tasks using SQL Server Agent
- Created backup/restore and disaster recovery plans for multiple servers
- Migrated DTS packages using DTS editor wizard into SSIS
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.) and loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
Education
Bachelor's - Computer Science
Addis Ababa University
Addis Ababa, EthiopiaSkills
- T-SQL
- SSIS
- SSRS
- SSAS
- Azure
- ETL
- Production Environment
- Data Warehouse DB
- Performance Issues
- DTS Database
- Scrum
- AWS
- Schema Troubleshoot
- GIT
- JSON
- Power Bi
- DMV
- SQL Server
- SQL Server Profiler
- Tableau
- MySQL Workbench
- Windows Powershell
- DBA
Certification
- MCDBA Microsoft Certified Database Administrator, 03/01/19
- Microsoft Azure Data Fundamentals DP-900, 12/01/22
- AWS Certified Cloud Practitioner (CLF-C01), 02/01/23
Additional Information
9+ years
Personal Information
Title: Database Developer/Database Administrator
Timeline
Database Administrator/Developer
Federal Aviation Administration (FAA)
01.2020 - Current
SQL Database Administrator
Higher Education Services Corporation
05.2018 - 01.2020
SQL Server Database Administrator
Pfizer Inc Certified Medical Technician
03.2014 - 07.2016
SQL Server Database Administrator
Marlin Steel
08.2013 - 03.2014
Bachelor's - Computer Science
Addis Ababa University
Similar Profiles
Tajjamul SaidTajjamul Said
Air Traffic Controller at Federal Aviation Administration, FAAAir Traffic Controller at Federal Aviation Administration, FAA
Daniel ThomasDaniel Thomas
Air Traffic Control Trainee at Federal Aviation Administration, FAAAir Traffic Control Trainee at Federal Aviation Administration, FAA
Janette GomezJanette Gomez
Resident Engineer at Federal Aviation Administration, FAAResident Engineer at Federal Aviation Administration, FAA
Nick RisiNick Risi
Supervisory Contract Specialist at Federal Aviation Administration, FAASupervisory Contract Specialist at Federal Aviation Administration, FAA
Kafaya WasiuKafaya Wasiu
Certified Medical Technician at Otik Health CareCertified Medical Technician at Otik Health Care