Kibreab Fiseha
Landover,MD
Summary
Database Developer/Database Administrator 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,Power BI, Tableau 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
11
11
years of professional experience
1
1
Certification
Work History
Database Engineer
IANA ( Intermodal Association of North America)
Beltsville, MD
03.2024 - Current
- Designed and developed interactive Power BI reports and dashboards to deliver key business insights.
- Developed and fine-tuned complex SQL queries using MySQL-specific features like EXPLAIN.
- Implemented MySQL performance best practices.
- Optimized indexing strategies, including composite and covering indexes.
- Utilized InnoDB buffer pool preloading for faster startup times.
- Configured query cache for frequently executed, read-only queries.
- Implemented partitioning for large tables to improve query performance.
- Created comprehensive Power BI reports and dashboards.
- Designed interactive visualizations for key business metrics.
- Implemented row-level security for data access control.
- Optimized data models using DAX for efficient calculations.
- Set up incremental refresh to reduce data load times.
- Performed regular database maintenance and optimization.
- Utilized MySQL Workbench for performance reports and query analysis.
- Implemented automated OPTIMIZE TABLE operations for fragmented tables.
- Configured and monitored slow query log to identify performance bottlenecks.
- Collaborated with cross-functional teams to resolve database-related issues.
- Provided expert MySQL performance tuning advice across the organization.
Database Developer/Database Administrator
Federal Aviation Administration (FAA)
Washington, DC
01.2020 - 02.2024
- Designed comprehensive database schemas aligned with business requirements.
- 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, Deadlocks, 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, and JSON file.
- Develop Tablix, drill down, drill-through reports using SQL Server Reporting Services (SSRS).
- Created jobs to automate repetitive tasks using SQL Server Agent.
- Provided high availability through clustering (active/passive), mirroring, log shipping, replication (transactional), and Always On.
- 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 and maintained robust database architectures, including schema optimization, entity-relationship modeling, and index strategies.
- Implemented comprehensive data security measures, ensuring confidentiality, integrity, and availability across all database systems.
- Developed and executed disaster recovery and high availability solutions, including replication, clustering, and business continuity planning.
- Conducted regular performance analysis and query optimization, utilizing advanced T-SQL techniques and dynamic SQL.
- Designed and developed scalable ETL processes using SSIS, successfully managing deployments from development to production.
- Created interactive dashboards and reports using modern visualization tools, such as Power BI and Tableau.
- Collaborated with cross-functional teams in an Agile environment to gather requirements and translate them into technical specifications.
- Implemented data consistency measures through constraints, triggers, and stored procedures.
- Provided technical support for diverse database platforms, including SQL Server and DB2 on Z/OS.
- Designed and maintained various database objects, optimizing for performance and scalability.
- Managed user access and permissions, implementing role-based security models.
- Developed and maintained comprehensive database documentation and technical guides.
SQL Database Administrator
Kraft-Heinz Inc
West Pittsburg, PA
07.2016 - 03.2018
- Designed and implemented disaster recovery and high availability solutions, including replication, clustering, and business continuity plans.
- Conducted regular performance analysis and tuning of databases and queries, utilizing T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers. Collaborated with cross-functional teams to gather business requirements, create technical specifications, and design efficient database solutions.
- Designed and developed database objects (tables, functions, stored procedures, triggers, jobs), and implemented constraints to ensure data consistency.
- Created and deployed ETL solutions using SSIS, transforming source data into data marts and data warehouses.
- Developed and deployed SSRS reports based on business needs, effectively presenting data from the warehouse.
- Participated actively in Agile Scrum teams, contributing to daily stand-ups and creating technical documentation.
- Provided technical support for DB2 developers using z/OS, demonstrating versatility across database platforms.
- Implemented complex T-SQL statements for data filtering and transformation in data warehouse systems.
- Successfully managed the deployment of database solutions from development to production environments.
Senior SQL Server Database Administrator
Püzer Inc
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
- Developed and optimized complex SQL queries involving multiple tables to extract data.
- Provided data migration support after deployment
- Designed and created various database objects, such as tables, functions, stored procedures, and triggers, as per business requirements.
- Optimized SQL server performance using SQL Profiler, Activity Monitor in SSMS, and T-SQL query to display Execution plan
SQL Server Database Administrator
Marlin Steel
Baltimore, MD
08.2013 - 03.2014
- 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.
- Worked closely with business analysts and stakeholders to understand their reporting needs and translate them into SSRS reports.
- Provided data migration support after deployment.
- Designed and created various database objects, such as tables, functions, stored procedures, and triggers, as per business requirements.
- Performed data migration from SQL 2008, 2008R2, to 2012 of SQL server.
- Optimized SQL server performance using SQL Profiler, Activity Monitor in SSMS, and T-SQL query to display Execution plan.
Education
Bachelor's - Computer Science
Addis Ababa University
Addis Ababa, EthiopiaSkills
- T-SQL
- SSIS
- SSRS
- Power BI
- Tableau
- SSAS
- Azure
- AWS
- ETL
- Performance Tuning
- Troubleshoot
- Data Warehouse
- Scrum
- JSON
- DMV
- SQL Server Profiler
- MySQL Workbench
- Windows PowerShell
- Source and Version Control: Git, Github
- Code debugging
- Database Design
- NoSQL Databases
Certification
- MCDBA Microsoft Certified Database Administrator, 03/19
- Microsoft Azure Data Fundamentals DP-900, 12/22
- AWS Certified Cloud Practitioner (CLF-C01), 02/23
Personal Information
Title: Database Developer/Database Administrator
References
References available upon request.
Timeline
Database Engineer
IANA ( Intermodal Association of North America)
03.2024 - Current
Database Developer/Database Administrator
Federal Aviation Administration (FAA)
01.2020 - 02.2024
SQL Database Administrator
Higher Education Services Corporation
05.2018 - 01.2020
SQL Database Administrator
Kraft-Heinz Inc
07.2016 - 03.2018
Senior SQL Server Database Administrator
Püzer Inc
03.2014 - 07.2016
SQL Server Database Administrator
Marlin Steel
08.2013 - 03.2014
Bachelor's - Computer Science
Addis Ababa University
Similar Profiles
Tristan KayserTristan Kayser
Apprentice at Artist Blacksmith's Association of North AmericaApprentice at Artist Blacksmith's Association of North America
Caslyn LustalCaslyn Lustal
Documentation Agent at Hanjin Intermodal AmericaDocumentation Agent at Hanjin Intermodal America
Naftale HirdNaftale Hird
Investments Compliance Manager at QBE North America, Investments Compliance North AmericaInvestments Compliance Manager at QBE North America, Investments Compliance North America
Shaunice FrazierShaunice Frazier
Armed Special Police Officer at Allied Universal Security ServicesArmed Special Police Officer at Allied Universal Security Services
Alpha JallohAlpha Jalloh
Residential Manager at Rock Creek FoundationResidential Manager at Rock Creek Foundation