Summary
Overview
Work History
Education
Skills
Certification
Toolsenvironments
Timeline
Generic

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
2022.08 - 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
2020.04 - 2022.07
  • 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
2018.01 - 2020.03
  • 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
2016.08 - 2018.12
  • 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 , ETHIOPIA
07.2012

Diploma in Purchasing and supplies management -

ADDIS ABABA COMMERCIAL COLLEGE
ADDIS ABABA ,ETHIOPIA
07.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
2022.08 - Current

SQL Server Database Administrator

Reliant Energy
2020.04 - 2022.07

SQL SERVER Database Administrator

HP
2018.01 - 2020.03

SQL Server DBA

ALLEGIANCE BANK
2016.08 - 2018.12

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

  • Teresa Narvaez

    Teresa NarvaezTeresa Narvaez

    Clinical Investigational Technician at Md Anderson Medical Cancer CenterClinical Investigational Technician at Md Anderson Medical Cancer Center

    View Profile
  • Ella Shanar

    Ella ShanarElla Shanar

    Ambulatory Treatment Center Volunteer at Md Anderson Medical Cancer CenterAmbulatory Treatment Center Volunteer at Md Anderson Medical Cancer Center

    View Profile
  • Elizabeth Conner

    Elizabeth ConnerElizabeth Conner

    Certified Medical Assistant at Md Anderson Medical Cancer CenterCertified Medical Assistant at Md Anderson Medical Cancer Center

    View Profile
SIMON ABEBE