Asfaw Mack
Senior SQL Server Database Administrator
- Role
- Senior Sql Server Database Administrator at Allied Benefit Systems
- Location
- Silver Spring, MD, US
- LinkedIn followers
- 500 followers
About Asfaw Mack
A detail-oriented and analytical database administrator with diverse expertise for over 10 years in database design and development, capacity planning and scalability, performance monitoring and tuning, deployment, database migration, scripting, automation, security, documentation, event log, and server error log troubleshooting, and compliance. Implemented capabilities in installing, configuring, and handling SQL Server instances, implementing MS SQL Server’s security practices, and scheduling and monitoring SQL Server jobs and maintenance plans on-premises and cloud. Led the management of DevOps methodology, including planning, coding, building, testing, packaging, releasing, operating, and monitoring phases. A goal-oriented, knowledgeable producer who continually visualizes, expands, and generates ideas to maximize growth and profits
Experience
Senior Sql Server Database Administrator
Dec 2020 — Present · Chicago, IL, US
Responsible for providing day-to-day activities, including backup, restore, performance tuning, security management- Responsible for investigating potential problems and issues raised by customers- Monitor the health and performance of SQL OS, server applications using SQL Server Profiler, and other third-party tools- Installed and Managed SQL Server 2017/2019/2022 databases in Production and Preproduction- Responsible for a large-scale database migration from SQL Server 2012 to SQL Server 2019- Ability to review and author complex stored procedures- Implemented Transparent Data Encryption (TDE) and Column level encryption, Fortanix and UKC to maintain sensitive data- Use PowerShell to execute batch files- Moved data from flat files, Excel, Oracle, MySQL, MS Access, OLE DB Sources to SQL Server- Documentation of all the processes involved in maintaining the database for future reference- Involved in installing, configuring, and maintaining Clustering and Always On availability groups in production servers, with the latest Service Packs, Hot Fixes- Practical experience working with NoSQL, particularly MongoDB, PostgreSQL, including data modeling- Recovered databases from backups during disasters by implementing point-in-time recovery solutions- Created Maintenance Plans for database backup- Skilled in optimizing database performance through indexing, partitioning- Scheduling jobs and alerts using SQL Server Agent and Maintenance Plans and DB mail- Acquired experience in Agile projects with solid foundation in the software development lifecycle (SDLC)- Handled tickets/tasks, troubleshooted issues, and provided resolutions- Performed tests and evaluations regularly to ensure data security, privacy, and integrity- Implemented Forts nix encryption technology and became a Subject Matter Expert (SME)- Participated in 24/7 on-call rotation and responded to critical database incidents.
Education
Addis Ababa University, Addis Ababa, Ethiopia
B.S.C. Degree Computer Science , BS, Computer Science
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.