B

Bethelhem Assefa

About

Detail

Gujarat, India

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • Liberty Mutual
    SQL Server Database Administrator
    Liberty Mutual
    Oct 2023 - Current (2 years 11 months)
    Orchestrated enterprise support for 180+ SQL Server 2016–2022 instances on Windows Server 2019/2022, coordinating Always On Availability Groups to maintain availability for 12 business units supporting 20M+ policy records. Engineered diagnostics using Extended Events, DMV analysis, and SQL Profiler to identify blocking and deadlocks in reporting workloads, resolving priority incidents within 45-minute response windows across 16 production databases. Hardened regulated data environments by implementing TDE, column-level encryption, RBAC, and Active Directory integration, supporting SOX- and HIPAA-aligned audit readiness for 25+ compliance assessments. Automated backup validation, integrity checks, and Azure Blob Storage archival through Powe
  • Epsilon
    SQL Server DBA
    Epsilon
    Nov 2022 - Sep 2023 (11 months)
    Upgraded SQL Server 2014/2016 to 2019 across 11 cross-channel marketing platforms, stabilizing analytics pipelines ingesting 30M customer interaction records daily for campaign performance reporting. Implemented Always On Availability Groups and Windows Failover Clustering on 22 production instances, sustaining high availability and uninterrupted connectivity for data ingestion and reporting workloads. Performed performance tuning using Extended Events, Query Store, DMV analysis, and execution plan optimization to resolve latency issues and restore SLA alignment for 18 mission-critical reporting databases. Strengthened regulated data environments with TDE, RBAC, auditing, and Active Directory integration, aligning database operations with P
  • M
    SQL Server DBA
    Molina Health Care
    Feb 2021 - Oct 2022 (1 year 9 months)
    Implemented Always On Availability Groups and Windows Failover Clustering for healthcare claims platforms, ensuring continuous access to 32 SQL Server 2012–2019 databases supporting 8 state Medicaid programs. Tuned ETL pipelines built on SSIS and T-SQL to support SSRS reporting workloads, stabilizing overnight claims adjudication cycles processing 15M+ records per run. Established standardized backup, restore, and point-in-time recovery procedures across non-prod and prod environments, safeguarding 38+ TB of PHI-regulated healthcare data. Migrated legacy SQL Server 2008/2012 instances to SQL Server 2019 on Windows Server 2019, decommissioning 12 end-of-life servers and improving long-term platform supportability. Standardized operational do
Education verified_user 0% verified
  • O
    MS in Information Processing Science
    Oulu University
    Finland
  • O
    BS in Business Information Technology
    Oulu University
    Finland