Summary
Overview
Work History
Education
Skills
Operating Systems
References
No Sql Database
Reporting And Analytics
Timeline
Generic

MIHRET YOHANNES

Summary

Senior SQL Database Administrator with 10+ years of experience in managing Microsoft SQL Server environments. Skilled in database installation, configuration, security, tuning, backup, recovery, migration, and upgrades. Proven track record in team mentoring and operational excellence. Proficient in complex systems management and cloud platforms like Azure, SSAS, SSRS, and MongoDB. Expertise in high-availability solutions, such as AlwaysOn Availability Groups and clustering. Delivery results in dynamic settings, ensuring data integrity, security, and optimization.

Overview

12
12
years of professional experience

Work History

Senior SQL Database Administrator Advisor

Cigna
04.2022 - Current
  • Led a team in the design, implementation, and maintenance of SQL Server databases supporting mission-critical applications.
  • Applied advanced performance tuning techniques to enhance query response times and improve system efficiency.
  • Implemented robust security measures ensuring compliance with industry standards and regulations.
  • Conducted regular health checks, monitored database performance, and proactively resolved issues.
  • Collaborated with development and cross-functional teams to optimize SQL queries, improving application performance.
  • Managed and optimized cloud-based Azure SQL Database solutions, driving resource efficiency.
  • Designed, implemented, and supported SSAS and SSRS solutions for enhanced data analysis and reporting.
  • Managed replication processes across geographically distributed database servers to maintain data consistency.
  • Implemented and maintained SQL Server clustering and AlwaysOn Availability Groups (AG) for high availability and disaster recovery.
  • Delivered proactive database performance monitoring and tuning, ensuring reliability and responsiveness.
  • Mentored junior team members, fostering skill development and teamwork.
  • Successfully administered large-scale SQL Server environments, ensuring optimal performance, availability, and security.

Senior SQL Database Administrator

Robert Bosch LLC
09.2017 - 04.2022
  • Installed, configured, and managed SQL Server instances across standalone, clustered, and availability group environments.
  • Led successful database migrations between different SQL Server versions, ensuring minimal downtime.
  • Applied updates, service packs, and cumulative patches to ensure the SQL Server environment was up to date.
  • Managed Active Directory and SQL Server security, including user and group management.
  • Enhanced performance through optimization, indexing, and query tuning techniques.
  • Conducted capacity planning, anticipating data growth and recommending hardware or software upgrades.
  • Implemented AlwaysOn Availability Groups for high availability and disaster recovery solutions.
  • Utilized third-party diagnostic and performance monitoring tools to ensure database health and efficiency.
  • Managed diverse SQL Server databases from small-scale to enterprise-level environments.
  • Migrated on-premises databases to Azure cloud platforms, optimizing resource utilization and reducing costs.
  • Designed and implemented SSAS cubes and SSRS reports for business intelligence and reporting needs.
  • Established and maintained transactional and peer-to-peer replication, ensuring data availability across multiple sites.

SQL Database Administrator

Xerox Corporation
10.2013 - 06.2017
  • Managed SQL Server instances across production, development, and testing environments.
  • Led successful migrations from older SQL Server versions to newer releases with minimal service interruption.
  • Designed and executed backup strategies, disaster recovery plans, and implemented database maintenance procedures.
  • Utilized SSIS for ETL processes and data migration between systems.
  • Configured Log Shipping, Database Mirroring, and Standby databases for high availability and failover.
  • Optimized database performance by executing regular maintenance tasks, indexing, and query optimization.
  • Implemented comprehensive security measures, including alerts and notifications, to monitor unauthorized activities.

Education

BSc - Management Information Systems

University of Gondar
Gondar, Ethiopia

Skills

  • Microsoft SQL Server
  • Database Design
  • Optimization
  • Performance Tuning
  • High Availability
  • Disaster Recovery
  • Cloud Platforms
  • Azure
  • Azure SQL Database Management
  • Database Security
  • Compliance Management
  • Automation
  • Scripting
  • PowerShell
  • T-SQL
  • Spotlight
  • SMT
  • UC4
  • Tivoli
  • SolarWinds
  • Idera
  • ServiceNow
  • Reporting
  • Analytics
  • SSRS
  • SSAS
  • SSIS
  • PowerBI
  • NoSQL Database
  • MongoDB Deployment
  • Upgrades
  • Operating Systems
  • Windows Server
  • Linux
  • Database administration
  • SQL performance tuning
  • Cloud database management
  • Disaster recovery
  • Data security
  • Database migrations
  • Query optimization
  • Capacity planning
  • Data replication
  • Reporting solutions
  • Health monitoring
  • Database documentation
  • Interdepartmental communication
  • Replication management

Operating Systems

  • Windows Server
  • Linux

References

Available upon request.

No Sql Database

MongoDB Deployment, Upgrades & High Availability

Reporting And Analytics

  • SSRS
  • SSAS
  • SSIS
  • PowerBI

Timeline

Senior SQL Database Administrator Advisor

Cigna
04.2022 - Current

Senior SQL Database Administrator

Robert Bosch LLC
09.2017 - 04.2022

SQL Database Administrator

Xerox Corporation
10.2013 - 06.2017

BSc - Management Information Systems

University of Gondar
MIHRET YOHANNES