Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

HawiI Abera

SQL Server DBA
Dallas,TX

Summary

Results-oriented Microsoft SQL Server Database Administrator with six years of experience in installation, configuration, and administration of SQL Server databases (2012/2014/2016/2019/2022). High-performing professional with extensive experience managing large-scale, complex databases. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up to date with new technologies and advancements. Proficient in configuring proactive maintenance plans, automation, backup/restore, query tuning, high availability and disaster recovery planning to ensure optimal performance. Demonstrates expertise in crafting a database and implementing migration scripts, modifying stored procedures, triggers, cursors, and functions to meet dynamic business requirements.

Overview

5
5
years of professional experience

Work History

SQL Server Database Administrator

Bank Of America
07.2022 - Current
  • Collaborate closely with application development team to ensure successful deployment and optimal performance of database applications.
  • Install, configure, administer, and apply patches on Microsoft SQL Server 2014/2016/2019/2022 in clustered and non-clustered windows server as standalone and clustered node.
  • Maintain databases in Production, Pre-production, Test, and Development environments.
  • Conduct comprehensive research and evaluation of alternative solutions to address issues, recommending most cost-effective and efficient options.
  • Spearhead or actively participate in design and implementation of intricate database solutions, demonstrating expertise in managing large-scale projects.
  • Orchestrate facilitation, monitoring, and implementation of data replication solutions across multiple databases.
  • Create automated maintenance plan jobs for backups, index management, statistic updates and database consistency checks.
  • Implement advanced monitoring and alerting mechanisms to enhance performance of database systems.
  • Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
  • Ensure database consistency, integrity, security, and auditing in strict adherence to regulatory and compliance requirements.
  • Maintained documentation of database systems, providing valuable reference resource for team members and stakeholders alike.
  • Formulate and monitor policies, procedures, and standards to ensure data recovery, integrity, and space requirements of databases.
  • Plan and monitor projects, communicating progress effectively to application owners.
  • Utilize Redgate, SQL Compare, and Data Compare tools for database schema comparison.
  • Oversaw development, testing, and implementation of database systems, aligning with capacity standards and sizing objectives.
  • Implement HADR solutions such as clustering, Always On, replication, and log shipping, contributing to robust data availability.
  • Provide mentorship to less experienced DBAs, guiding them in performance of day-to-day activities and project-related duties as directed.
  • Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
  • Optimized database performance by implementing index tuning strategies and query optimization techniques.

SQL Server DBA

Tyson Foods
06.2020 - 07.2022
  • Possessed profound understanding of relational database management systems (RDBMS) with focus on OLTP databases.
  • Proactively managed Microsoft SQL Server instances, creating SQL scripts for database creation, maintenance plans, user logins, and server monitoring with exception reporting via Database Mail notifications, and a SQL Server failover system for enhanced availability.
  • Implemented Transactional Replication between SQL Server databases, ensuring real-time data synchronization and maintaining data consistency across environments.
  • Collaborated with application developers to modify database structure, aligning it with business requirements and optimizing performance.
  • Planned and executed comprehensive backup and recovery strategies for database information, creating maintenance plans and jobs to ensure data integrity and availability.
  • Conducted successful data migrations from Excel to SQL Server using bulk insert and BCP IN and OUT, facilitating efficient data transfer.
  • Configured Always On for High Availability and Disaster Recovery (HADR) solutions within Availability Groups (AG).
  • Upgraded Microsoft SQL Server, performed failover clustering, log shipping, and replication tasks.
  • Utilized System Monitor and SQL Server Profiler to identify bottlenecks and optimize performance.
  • Created SSIS packages for scheduling data import/export between databases across instances, demonstrating proficiency in data integration.
  • Applied patches to SQL Server mirroring configurations and utilized shrinking/compression options in backup and restore jobs for efficient storage space management.
  • Rebuilt/Reorganized indexes based on fragmentation levels, optimizing database performance.
  • Conducted side-by-side and in-place upgrades, lower environment database refresh from production environment.
  • Conducted meetings with application teams to ensure alignment with corporate milestones and project objectives.
  • Monitored SQL Server jobs, database size, and disk space, ensuring optimal system performance and resource management.
  • Implemented SQL Server logins, roles, and authentication modes with appropriate permissions, ensuring data security and access control.
  • Developed strong communication and organizational skills through working on group projects.

Junior SQL DBA

Arkansas Blue Cross and Blue Shield
01.2019 - 05.2020
  • Assisted in installation and configuration of SQL Server instances, collaborating with senior DBAs to establish and maintain optimal settings and configurations.
  • Executed routine maintenance tasks, including indexing defragmentation, backups, restores, and consistency checks, ensuring continuous data reliability to enhance database performance and efficiency.
  • Devised and executed effective backup and recovery strategies, safeguarding critical data from loss or corruption.
  • Helped manage user access and permissions to databases, ensuring data security and compliance with access policies.
  • Assisted in applying patches and updates to SQL Server instances, ensuring systems were up to date with latest security patches.
  • Worked closely with developers, system administrators, and other IT teams to facilitate effective communication and collaboration.
  • Actively participated in team meetings and contributed to collaborative projects, fostering cohesive and productive working environment.
  • Assisted with day-to-day operations, working efficiently and productively with all team members.

Education

BS - Computer Information Systems

University of Arkansas
Arkansas

Skills

  • Problem-solving, Self-starter, Excellent communication, Organization skills
  • Databases – MS SQL Server 2012 – 2022
  • SQL Server tools – SSMS, RDBMS, SSCM, SSIS, SSRS, Query Analyzer, Activity Monitor, Profiler, Database Engine Tuning Advisor, Performance Monitor, Command Prompt, SQL Server logs
  • Service now, Redgate, Jira, MS Outlook, MS Word, MS Excel, MS PowerPoint, Windows, PowerShell, Tableau, T-SQL, SharePoint
  • Performance Tuning, Capacity Planning, Backup and recovery, Disaster Recovery, Replication Management, HADR Mechanisms, Log Shipping, Windows patching

References

Will provide upon request.

Timeline

SQL Server Database Administrator

Bank Of America
07.2022 - Current

SQL Server DBA

Tyson Foods
06.2020 - 07.2022

Junior SQL DBA

Arkansas Blue Cross and Blue Shield
01.2019 - 05.2020

BS - Computer Information Systems

University of Arkansas

Similar Profiles

CREATE PROFILE
HawiI Abera SQL Server DBA