SIMON ABEBE
HOUSTON,TEXAS
Summary
SQL Database Administrator with 6+ years of IT experience in Microsoft SQL Server installation, configuration, administration, and performance tuning across multiple versions (2019 to 2005). Proficient in backup, restore, disaster recovery, and high availability solutions including clustering, mirroring, replication, and log shipping. Skilled in automating tasks, creating and modifying migration scripts, stored procedures, and managing SQL Server security. Experienced in database optimization, troubleshooting performance issues, and providing 24x7 production support.
Overview
8
8
years of professional experience
1
1
Certification
Work History
SQL SERVER Database Administrator
Md Anderson Medical Cancer Center
08.2022 - Current
- Provide SQL Server database Administration and monitoring support across production, development and staging environments
- Installed, Managed and administered SQL server 2022/2019/2017/2016/2014/and 2012 SQL servers
- Installation, Upgrade, Configuration and Migration of MS SQL Server.
- Installing and upgrading the Database server and application tools
- Managed the SQL Server in database mirroring and clustered environment
- Setting up and configuring AlwaysOn High Availability in MSSQL Server 2016 and 2019
- Setting up the Transactional Replication in between SQL Server databases
- Involved in development of databases including creating new databases, converting old databases to new databases, modification of existing databases, creating reports to meet business needs
- Creation and maintenance of user security permissions and migrating the entire database lP objects from one server to another server as required by the business
- Configured Email notifications through SMTP to get Alerts
- Performed database consistency checks using DBCC Utilities
- Created SSIS Packages to export and import data from various sources
- Improving query performance using profiler, execution plan, database tuning advisor
- Monitor connections, locks and performance of SQL Server
- Extensive testing on the performance of the Stored Procedures
- Worked with complex stored procedures, triggers, cursors, views, tables and other SQL joins and statements for applications
- Applied Security Patches and Service packs and evaluated the performance
- Experience in setting up SQL Server maintenance plans using client tools
- Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
- Planning for backup and recovery of database information
- Deploy SSIS packages on to the production server and configure configuration files
- Design and implement comprehensive backup plan and disaster recovery strategies, implement and schedule replication process for updating parallel servers
- Modifying the database structure, as necessary, from information given by application developers
- Provided 24x7 Production support for the database and application issues.
SQL Server Database Administrator
Reliant Energy
04.2020 - 07.2022
- Designed Database Recovery Plans and Participated in Disaster Recovery Drill processes
- Used compression options in backup and restore jobs for storage space management
- Performed backup using backup compression and Data compression in MS SQL Server 2014 and SQL Server 2012 on clustered environment
- Implemented SQL server logins, Roles and Authentication modes as a part of security policies
- Configured Logins, roles, and authentication modes
- Involved in scheduling the reports to run on a daily and weekly basis in Report Manager
- Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints
- Used Database Tuning Advisor, Perf
- Monitor and Activity Monitor for performance tuning
- Created a SSIS package from Production servers
- Administered and managed the SQL Server 2014, 2012 production and Non-production servers
- Experienced in creating SSIS packages using proper control and data flow elements
- Export and import data from sources like flat files, row files using DTS, SQL Server Integration Services
- Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
SQL SERVER Database Administrator
HP
01.2018 - 03.2020
- Extensively involved and interacted with the application team in Upgrading 2008R2 to 2012
- Monitored performance and optimize SQL queries for maximum efficiency
- Performing query plans and making sure each and every query is using appropriate Indexes
- Extensive testing on the performance of the Stored Procedures
- Applied Security Patches and Service packs and evaluated the performance
- Configured Snapshot and Transactional Replication
- Involved in troubleshooting the performance issues for different database applications
- Deployed the created SSIS packages in Development and Testing environments
- Created SSIS Packages to export and import data from various sources
- Implemented database Mirroring and Log Shipping for disaster recovery
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
- Used tools like SQL Server Profiler, Performance Monitor to identify bottlenecks
- Create database objects including Views, UDFs, and Triggers to implement Business Logic
- Prepared, maintained and modified SQL server installation and configuration documents
- Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
- Daily backup and scheduling Jobs.
SQL Server DBA
ALLEGIANCE BANK
08.2016 - 12.2018
- Extensively involved in maintenance of SQL Server 2008/2008R2/2012
- Involved in configuring HADR solutions like replication, database mirroring, and log shipping
- Involved in Building Disaster recovery environment as a replica to the Production servers and Created Custom Log-Shipping to manage and Support Disaster Recovery and restores
- Used DMVs and Functions for monitoring the performance of the server
- Performed Database Statistics and performed Re-indexing through Maintenance Planner
- Implemented database recovery models, backup strategies, restore jobs
- Performed database consistency checks using DBCC Utilities
- Experience in setting up SQL Server maintenance plans using client tools
- Involved in database design, database standards, and T-SQL code reviews
- Involved in modifying database objects following change requests
- Interacted with Business Analysts to clarify terminologies, concepts, and attributes
- Identified index fragmentations for decisions in rebuilding or reorganizing Indexes
- Monitored the SQL Server Jobs, database size, disk space in SQL Server
- Running DBCC consistency checks and fixing data corruption in application databases
- Daily backup and scheduling Jobs
Education
Bachelor of Arts - Information Technology
ADMAS UNIVERSITY
ADDIS ABABA , ETHIOPIA07.2012
Diploma in Purchasing and supplies management -
ADDIS ABABA COMMERCIAL COLLEGE
ADDIS ABABA ,ETHIOPIA07.2008
Skills
- Relational databases
- Database Administration
- Database monitoring
- Teamwork and Collaboration
- Problem-Solving
- Problem-solving abilities
- Performance Tuning
- Extended Events
- Database Auditing
- SQL Server Agent
- Query Optimization
- SQL Profiler
Certification
- Microsoft Exam 462: Administering Microsoft SQL Server 2012/2014 Databases
- Azure Database Administrator Associate
Toolsenvironments
Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2, SSIS, SSRS, SSMS, Enterprise Manager and SQL Query Analyzer, and Windows server 2016/2012R2/2008R2/2008, Enterprise server and platforms .Net, PowerShell, TFS, SSDT, Microsoft Visual Studio, Azure, SCOM monitoring tool, LiteSpeed, Foglight, Ansible Tower, Remedy, SolarWinds, ServiceNow, and RedGate
Timeline
SQL SERVER Database Administrator
Md Anderson Medical Cancer Center
08.2022 - Current
SQL Server Database Administrator
Reliant Energy
04.2020 - 07.2022
SQL SERVER Database Administrator
HP
01.2018 - 03.2020
SQL Server DBA
ALLEGIANCE BANK
08.2016 - 12.2018
Bachelor of Arts - Information Technology
ADMAS UNIVERSITY
Diploma in Purchasing and supplies management -
ADDIS ABABA COMMERCIAL COLLEGE
- Microsoft Exam 462: Administering Microsoft SQL Server 2012/2014 Databases
- Azure Database Administrator Associate
Similar Profiles
Elizabeth ConnerElizabeth Conner
Certified Medical Assistant at Md Anderson Medical Cancer CenterCertified Medical Assistant at Md Anderson Medical Cancer Center
Taylor TranTaylor Tran
Oncology Nurse at Md Anderson Medical Cancer CenterOncology Nurse at Md Anderson Medical Cancer Center
Teresa NarvaezTeresa Narvaez
Clinical Investigational Technician at Md Anderson Medical Cancer CenterClinical Investigational Technician at Md Anderson Medical Cancer Center