Tehtena Zeru
Madison,AL
Summary
Over Six years of experience in Microsoft SQL Server Database Installation, Configuration, Administration Maintenance and Performance Tuning, backup/restore, and disaster recovery experience in SQL server 2019/2017/2016/2014/2012. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. 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.
Overview
6
6
years of professional experience
Work History
Database Administrator
Huntsville Hospital
05.2022 - Current
- Installation, Upgrade, Configuration, and Migration of SQL Server in clustered and non-clustered production environments.
- Managing Virtual Machine environments linked to MS SQL databases in both physical and VM ware hypervisors.
- Setting up Snapshot, Transactional, and merge Replication in between SQL Server
- SQL Server upgrades and migration from earlier versions to SQL Server 2012/2014/2016/2017/2019
- SQL Server Performance Tuning and Query optimization- SQL Profiler, Query Execution plan, indexing strategies.
- SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Replication
- Build dashboards, and reports using SQL, DAX, Power BI, or other visualization tools.
- Data modeling, Azure Data Factory, SSIS, SSRS, Power BI.
- Capacity Planning, Storage Planning, Hardware Upgrades, and Preparing Estimates for Database.
- Incident and Problem Management focusing on continuous improvements and quality of service.
- SQL Server Security Auditing, hardening, and remediation.
- Design and Implement Database Backup and Restore policies.
- Automate routine maintenance tasks using PowerShell.
- Build project documentation and troubleshooting guides.
- Creates incident (ICM) related performance analysis and reporting for review by IT management
- Participated in capacity planning and reviewed database changes for system impact.
- Performed backup using backup compression and data compression in SQL server databases in clustered environment.
- Worked on database refresh by taking backups from production database to development servers.
- Implemented high availability and disaster recovery setup on various servers using Windows clustering, replication, and Always on Availability Group setup.
- Implement TSQL and PowerShell.
MS SQL SERVER DBA
Bank Of America
04.2019 - 04.2022
- Involved in scheduling reports to run on daily and weekly basis in Report Manager.
- Maintaining referential integrity, domain integrity, and column integrity by using available options such as constraints.
- Upgrade databases from SQL Server2012 to 2016 in line with application requirements and version support,
- SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Log Shipping.
- Build dashboards, and reports using SQL, DAX, Power BI, or other visualization tools.
- Design and Implement Database Backup and Restore policies.
- Automate routine maintenance tasks using Power Shell.
- Build project documentation and troubleshooting guides.
- Creates incident (ICM) related performance analysis and reporting for review by IT management
- Participated in capacity planning and reviewed database changes for system impact.
- Implemented and tested point-in-time recovery of production databases.
- Automate routine maintenance tasks using Power Shell.
- Build project documentation and troubleshooting guides
Database Administrator
Wells Fargo
09.2017 - 03.2019
- Maintaining integrity and performance of databases and making sure data is stored securely and optimally.
- Responsible for MS SQL Server 2014 and 2016 and Upgrades servers.
- Installation and configuration and apply service packs and hotfixes.,
- SQL Server High Availability and Disaster Recovery solutions- Log Shipping, involved in scheduling reports to run on daily and weekly basis in Report Manager.
- Maintaining referential integrity, domain integrity, and column integrity by using available options such as constraints.
- Design and Implement Database Backup and Restore policies.
- Automate routine maintenance tasks using PowerShell.
- Build project documentation and troubleshooting guides.
- Participated in capacity planning and reviewed database changes for system impact.
- Performed backup using backup compression and data compression in SQL server databases in clustered environment.
- Worked on database refresh by taking backups from production database to development servers.
Education
Associate of Applied Science - Information Technology
Calhoun Community College
Decatur, AL12.2022
Skills
- Disaster Recovery
- Continuous Process Improvement
- Database Administration
- Database Management
- Compiling Data
- Running Backups
- Data Security
- Systems Administration
- Process Automation
- System Testing
- Document Management
- Customer Needs Assessment
Environment
Microsoft SQL Server 2019/2016/2016/2014/2012 and Windows server 2016/2012/ Enterprise server, Microsoft Visual Studio, and third-party Jira (Kanban Board), Remedy.
Timeline
Database Administrator
Huntsville Hospital
05.2022 - Current
MS SQL SERVER DBA
Bank Of America
04.2019 - 04.2022
Database Administrator
Wells Fargo
09.2017 - 03.2019
Associate of Applied Science - Information Technology
Calhoun Community College
Similar Profiles
Ashley SwaimAshley Swaim
Clinical Assistant at Huntsville HospitalClinical Assistant at Huntsville Hospital
Susan McGuireSusan McGuire
Registered Nurse, Operating Room at Huntsville HospitalRegistered Nurse, Operating Room at Huntsville Hospital
Cynthia AllenCynthia Allen
Clinic RN at Huntsville HospitalClinic RN at Huntsville Hospital