Lalem Mezgebu
Burtonsville,MD
Summary
Microsoft certified SQL Server (DBA) with 8+ years of experience designing, coding, testing, and supporting next-generation database solutions. Proficient in Windows Server, SQL Server, Azure, SSIS, SSRS, and database administration tasks, database security, backup and recovery. Strong communication and problem-solving skills with a track record of successful teamwork and proactive system support.
Overview
8
8
years of professional experience
Work History
SQL Server Database Administrator
Bank of America
03.2020 - Current
- Provide comprehensive SQL Server database administration across production, development, and staging environments
- Strategize High Availability, Disaster Recovery, and Backup solutions aligned with RTO and RPO guidelines, using mechanisms like Replication, Log Shipping, Database Mirroring, Always On, and Clustering
- Conduct baseline assessments of SQL Servers to identify potential bottlenecks in Memory, Disk I/O, and CPU
- Manage user access, security privileges, and tailored permissions in MS SQL databases by creating groups, roles, and users
- Lead performance tuning and optimization using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor, and other tools
- Generate reports in SQL Server via SSRS to meet Front-End user requirements
- Utilize Index tuning wizard, perform rebuild & reorganize operations on indexes, and employ System Monitor and SQL Server Profiler extensively for bottleneck identification and resolving slow-running queries
- Evaluate execution plans, query plans, key lookup operators, and assess transaction isolation levels for troubleshooting
- Design and implement maintenance plans, jobs, and execute ETL processes using Azure Data Factory for optimal performance
- Upgrade Microsoft SQL Server, manage failover clustering, log shipping, and replication
- Execute Migration projects from lower to higher versions and on-premise servers to Azure cloud
- Engage in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency checks using DBCC
- Demonstrate understanding of Cloud computing architecture, technical design, and implementations (IaaS, PaaS, SaaS)
- Hands-on experience in troubleshooting and responsible for data migration from Excel, flat files to Microsoft SQL Server using BCP, DTS utilities, and executing ETL processes using SQL Server SSIS and DTS
Database Administrator
Washington Medstar
01.2018 - 01.2020
- Developed and maintained databases for efficient handling of customer data
- Collaborated with staff to devise and implement procedures preventing data loss and ensuring maximum system availability
- Created scripts and processes for seamless data integration and maintenance
- Implemented high availability solutions, including database mirroring, clustering, and Always On Availability Groups
- Collaborated with cross-functional IT teams and healthcare professionals to ensure continuous and seamless data access for patient care and administration
- Designed, updated, and maintained database structures, including data models, to meet organizational data requirements
- Established robust backup and recovery procedures to safeguard data and minimize downtime in case of system failures
- Collaborated with application developers and analysts in designing and implementing effective database structures
- Administered, supported, and monitored databases, proactively resolving issues and maintaining server health
- Modified databases to align with evolving needs and goals identified during the planning process
- Conducted comprehensive tests to identify issues and implemented necessary modifications
- Implemented and controlled user profiles, access levels, and permissions across databases to ensure data security
- Built databases and table structures tailored for web applications
- Coordinated with project management to adhere to set schedules, testing databases for flaws, and reducing downtime
- Implemented and utilized RDBMS tools and utilities for continuous monitoring, tuning, and optimization of system performance.
SQL Server Database Administrator
T-Mobile
01.2016 - 01.2018
- Designed and implemented TSQL queries for reporting and complex solution development
- Managed individual workload and collaborated with colleagues on larger-scale tasks in a distributed team environment
- Maintained complex T-SQL queries, views, and stored procedures across multiple databases with minimal supervision
- Documented analysis results and provided detailed feedback for performance improvement
- Developed and updated databases to efficiently handle and manage customer data
- Coordinated with project management to ensure strict adherence to database development timelines
- Implemented and consistently maintained security measures to safeguard sensitive customer data
- Ensured unwavering compliance with relevant data security and privacy regulations, including GDPR and industry-specific standards
- Established and meticulously maintained backup and recovery procedures to safeguard data and minimize downtime in case of system failures
- Implemented high availability solutions, including database mirroring, clustering, or Always On Availability Groups, to ensure uninterrupted services
- Developed, tested, and refined disaster recovery plans to maintain business continuity in the face of unforeseen events
- Configured backup/restore utilities and developed comprehensive disaster recovery policies and procedures
- Created custom database objects, innovative stored procedures, and provided hands-on application support
- Built databases and meticulously crafted table structures tailored to meet the needs of dynamic web applications
- Administered, supported, and continuously monitored databases, proactively resolving issues and maintaining optimal server health.
Education
BSC Computer Science -
Mekelle University
Certificate in MCDBA: Administering Microsoft SQL
Skills
- Disaster Recovery
- Change Data Capture
- Database Partitioning
- Replication Management
- Database Mirroring
- Backup and Recovery
- Log Shipping
- Systems Administration
- Database Management
- Running Backups
Timeline
SQL Server Database Administrator
Bank of America
03.2020 - Current
Database Administrator
Washington Medstar
01.2018 - 01.2020
SQL Server Database Administrator
T-Mobile
01.2016 - 01.2018
BSC Computer Science -
Mekelle University
Certificate in MCDBA: Administering Microsoft SQL
Similar Profiles
Daniel NavaDaniel Nava
Lead Operations Representative at Bank of AmericaLead Operations Representative at Bank of America
Devi MaksutiDevi Maksuti
Personal Banker at Bank of AmericaPersonal Banker at Bank of America
Angelo VillarrealAngelo Villarreal
Relationship Banker at Bank of AmericaRelationship Banker at Bank of America