YOSEF BAHATA
MA
Summary
Over 7+ years of IT experience specializing in Microsoft SQL Server Database Administration, covering Installation, Configuration, Maintenance, Performance Tuning, Backup/Restore, High Availability, and Disaster Recovery for SQL Server 2022/2019/2017/2016/2014/2012. Possess extensive knowledge in implementing Always On, Log Shipping, SQL Failover Clustering, and Replication models. Additionally, skilled in Azure SQL Database management, including cloud database deployment, monitoring, and performance tuning. Capable of leveraging Azure features such as Azure SQL Managed Instance and Azure Monitor for database health checks and Troubleshooting.
Overview
7
7
years of professional experience
1
1
Certification
Work History
SQL SERVER DBA
Cambridge College
09.2023 - Current
- Installation, Configuration, Managing, and Administration of SQL Server 2012/2014/2016/2017/2019/2022 databases.
- Design and maintain database architecture, schemas, and objects to support business requirements.
- Proactively monitor database health and performance using tools like Activity Monitor, dynamic Management Views and third-party solutions like Redgate.
- Troubleshoot and resolve database-related issues, minimizing downtime and performance degradation.
- Design and optimize T-SQL queries, stored procedures, and functions.
- Create and manage ETL processes to support data movement and integration using SSIS and other relevant tools.
- High Availability and Disaster Recovery setup using Always On, SQL Failover Clustering, and Log Shipping.
- Participate in the creation of development, staging, and production database instances, and migration from one environment to another.
- Setting up Transactional Replication and monitoring database health.
- Data migration from on-premises to Azure SQL Database.
- Implemented Azure Data Studio for monitoring and managing Azure SQL databases.
- Backup and restore processes, including testing recovery for business RTO and databases.
- SSRS reporting and data transformation with SSIS.
- Database mail configuration, creating alerts, and notifications.
- designing maintenance plans and jobs to achieve maximum performance especially on Ola Hallengren maintenance plan for index rebuild & reorganize, Update Statistics & Database health Check (DBCC).
- Experienced in Change Data Capture (CDC) feature in SQL server to capture all the changes during migration of data between databases.
- Manage user access, roles, and permissions to ensure database security.
- Administration and implementation of data compressions and online indexing.
- Applying transparent data encryption and dynamic data masking on MS SQL Server.
- Automating tasks by using power shell scripting.
- Collaborating with development team, system administrators, and other IT professionals to optimize database design and to ensure the database meets organizational needs.
- Experience in Using on SQL server native and third-party tools.
SQL SERVER DBA
Cubic Corporation
01.2021 - 07.2023
- Install, configure, and maintain SQL Server instances (2012 and above).
- Administer and support SQL Server databases across production, development, and staging environments.
- Design backup policies and conduct regular testing to ensure data integrity.
- Experience in performance optimization using Extended viewer, Profiler, Activity Monitor, and Dynamic Management Views.
- Monitor and optimize database performance, including query performance, indexing, and server resource utilization.
- Managed data migration to Azure SQL, including ETL processes using SSIS.
- Configuring high availability using Always On, Failover Clustering, and Log Shipping.
- Implementation of Azure Data Studio for monitoring and managing Azure SQL databases.
- Designing Database Maintenance Plans and optimized query performance using Azure insights.
- Monitor database environments (using alert logs, trace files, alert mechanisms, and other tools) for issues and problems with database functionality, connectivity, or downtime.
- Ensuring database security and user role management.
- Handle numerous change management requests on production servers.
- Experienced on log shipping for synchronization of databases.
- Creating of maintenance jobs by using power shell scripting.
- Automation of frequent database refresh requests from Production to test & development servers.
- Plan, test and apply SQL patches on SQL servers to make sure we are up to date.
- Maintain accurate documentation for database configurations, procedures, and issues.
- Provide regular performance and availability reports to management.
- Implement and maintain database security (roles, permissions, encryption).
- Assist in TSQL development (check-in, review, build, testing, and deployment).
SQL SERVER DBA
7 Eleven
04.2018 - 12.2020
- Install, configure, and maintain SQL Server instances (2012 and above).
- Manage and administer SQL Server 2008 R2 through SQL Server 2022.
- Performing upgrades and migrations from SQL Server lower version to upper version..
- Implementation of disaster recovery solutions including Log Shipping, Database Mirroring, and Replication.
- Experience in using PowerShell scripting for automation of maintenance tasks.
- Experience in designing Backup & recovery strategy such as backup configuration, disaster recovery testing, and capacity planning.
- Solid experience in Performance tuning using Extended event, SQL Profiler, Tuning Advisor, and optimizing T-SQL queries.
- Planning of database storage and ensuring database performance, including Azure SQL Database readiness.
- Optimizing performance of queries with modifications in the queries, eliminated redundant data, normalizing tables, establishing joins and creating indexes whenever necessary.
- Troubleshooting long-running queries, locks, deadlocks, and performance issues.
- Import data across multiple instances using BULK INSERT and BCP Utility.
- hands of experience in using Event Viewer, SQL Error Logs and Log File Viewer for monitoring purposes.
- Implementation and maintenance of database security (roles, permissions, encryption).
- Develop and maintain documentation for database systems, processes, and procedures.
Education
Bachelor of Science - Civil Engineering
Jimma University
Ethiopia07-2007
Skills
- Microsoft SQL Server 2022/2019/2017/2016/2014/2012R2
- Windows Server 2022/2019/2016/2012R2
- Azure SQL Database
- T-SQL
- MySQL
- PowerShell
- SQL Server Management Studio
- SQL Server Data Tools
- Visual Studio
- Extended Event
- SQL Profiler
- Database Engine Tuning Advisor
- SSIS/SSRS/SSAS
- JIRRA
- Red Gate
- Azure Portal
- Azure Monitor
- Always-On
- Log Shipping
- Database Mirroring
- Clustering
- Replication
Certification
Microsoft Certified: Azure Database Administrator Associate
https://learn.microsoft.com/api/credentials/share/en-us/YosefBahata/C0F597EF07D224D2?sharingId=F6F43
Training
- Construction Claim Management
- Quality Management System Audit based on ISO 19011:2001
- Human Resource Management & Project Planning and management
Timeline
SQL SERVER DBA
Cambridge College
09.2023 - Current
SQL SERVER DBA
Cubic Corporation
01.2021 - 07.2023
SQL SERVER DBA
7 Eleven
04.2018 - 12.2020
Bachelor of Science - Civil Engineering
Jimma University
Similar Profiles
Kathrine CorbettKathrine Corbett
Associate Dean of Academic Advising and Field Experience at Cambridge CollegeAssociate Dean of Academic Advising and Field Experience at Cambridge College
Robyn CarrollRobyn Carroll
Senior Executive Assistant to the President / Liaison to the Board of Trustees at Cambridge CollegeSenior Executive Assistant to the President / Liaison to the Board of Trustees at Cambridge College
Rocío MataRocío Mata
First Grade Teacher at Cambridge CollegeFirst Grade Teacher at Cambridge College
Salwan BettiSalwan Betti
Pharmacy Technician at Keyes DrugPharmacy Technician at Keyes Drug
Richard ElstnerRichard Elstner
Driver / Fuel Delivery at Roberts Energy Product ServicesDriver / Fuel Delivery at Roberts Energy Product Services