Summary
Overview
Work History
Education
Skills
Websites
Education Certificate
Timeline
Generic

Hiwot Getenet

Houston,TX

Summary

Over 7 Years of Experience in SQL DBA with solid skills in database administration and management. Experienced Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance, Performance Tuning, Backup/Restore, and disaster recovery procedure experience in SQL Server 2008/2008R2/2012/2014/2016/2017/2019. Skilled in optimizing database performance, implementing security measures, and troubleshooting database issues. Installing and configuring SQL Server 2008/2008 R2/2012/2014/2016/2019 as per requirement. Extensively worked on Active-Active and Active-Passive Clustering. Committed to delivering high-quality results and ensuring the smooth functioning of databases. Having hands-on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors, and functions to meet business requirements. Experienced in SQL Server Reporting Services Installation, Configuration, and Maintenance using Visual Studio and Reporting Services. Upgraded SQL server versions and applied patches and service packs. Experienced in implementing SQL Server Security and object permission like maintaining the creation of users, configuring permissions database authentication modes, and assigning roles of users. Expertise in implementing different high availability and disaster recovery mechanisms like replication models, log shipping, database mirroring, and clustering. Worked on Clustering and server consolidation, troubleshooting production issues, and raising high availability. Proficiency in SQL Server Replication, Backup/Recovery, Disaster recovery, and planning. Sound knowledge stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions. Expert in tuning databases by choosing indexes and using tools such as Database Engine Tuning Advisor and SQL Profiler. Expertness in troubleshooting database issues like space issues, deadlocks, performance, and blocking. Experienced in SQL Server tools like Enterprise Manager and SQL Query Analyzer. Experienced in allocating system storage and planning future storage requirements for the database system. Experienced in Monitoring and optimizing the performance of the database. Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, and Event Viewer for performance analysis. 24 X 7 Production Database on Call Support. Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Overview

8
8
years of professional experience

Work History

SQL Server Database Administrator

Capital One (Contract)
Houston, TX
11.2021 - Current
  • Performed unit and system testing by developing automated test scripts via SQL
  • Managed 200 + Database Servers between the Development, Quality Assurance, User Acceptance, and Disaster Recovery Environments
  • Applied Patches and Service packs, hotfixes to update different versions of MS SQL server
  • Implemented and configured AlwaysOn High Availability
  • Experience in implementing HADR solutions like Clustering, Replication, and Log shipping
  • Designed Database Recovery Plans and Participated in Disaster Recovery Drill processes
  • Used shrinking/compression options in backup and restore jobs for storage space management
  • Created and modified Database objects as per change requests from Development teams
  • Created Linked Servers between different Servers in SQL Server Environments
  • Performed database consistency checks using DBCC Utilities and handling data corruption
  • Experience in Rebuilding/ Reorganizing Indexes based on Index fragmentation levels
  • Implemented SQL server logins, Roles, and Authentication modes as a part of security policies
  • Configured the DB SMTP mail and Alert system for notification purposes
  • Created and scheduled maintenance plans for jobs like checking fragmentation and backup plans
  • Used Database Tuning Advisor, Perf
  • Monitor and Activity Monitor for performance tuning
  • Created an SSIS package from Production servers
  • Experience in SQL Server Reporting Services (SSRS)
  • Created Logins and Roles with appropriate Permissions
  • Fixed SQL server failed logins following migration projects following detach/attach decisions
  • Configured Transparent Data Encryption (TDE) and Auditing
  • Fixed the failed Logins and user permissions in Active Directory and at the SQL Server Level
  • Used Red Gate, SQL Compare, and Data Compare tools to compare SQL Database Schemas
  • Managed numerous Change Management requests on production servers.

SQL Server Database Administrator

Geospace Technologies (Contract)
Houston, TX
03.2019 - 11.2021
  • Extensively involved in the maintenance of SQL Server 2008/2008R2/2012
  • Involved in configuring HADR solutions like replication, database mirroring, and log shipping
  • Involved in Building a Disaster recovery environment as a replica of the Production servers and Created Custom Log-Shipping to manage and Support Disaster Recovery and restores
  • Managed multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
  • Configured Email notifications through SMTP to get Alerts and diagnose the performance counters
  • Used DMVs and Functions for monitoring the performance of the server
  • Performed Database Statistics and applied Re-indexing through the Maintenance Planner
  • Applied Security Patches and Service packs and evaluated the performance
  • Implemented database recovery models, backup strategies, and 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 the Logical and Physical Data Modeling Processes
  • Configured Logins, roles, and authentication modes
  • 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
  • Created SSIS Packages to export and import data from various sources
  • Extensive testing on the performance of the Stored Procedures
  • Monitored the SQL Server Jobs, database size, and disk space in SQL Server
  • Running DBCC consistency checks and fixing data corruption in application databases
  • Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
  • Perform capacity planning and offer - and short-term solutions to controlling and managing database growth and space management.

SQL Server Database Administrator

Frost Bank (Contract)
Sugarland, TX
09.2016 - 03.2019
  • Performed backup using backup compression and Data compression in My SQL Server 2008R2 on a clustered environment
  • Administered and managed the SQL Server 2008R2, 2005 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 and row files using DTS and SQL Server Integration Services
  • Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers
  • Migrated SQL Server 2005 databases to SQL Server 2008R2 databases, including DTS to SSIS packages
  • Implemented high availability on the various servers using Replication, Log-Shipping, and Mirroring
  • Implemented and assessed the point-in-time recovery of the production databases
  • Developed and created the new database objects, including tables, views, indexes, stored procedures and functions, advanced queries, and updated statistics using Query Analyzer and Enterprise Manager on the existing servers
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins, and created indexes whenever necessary
  • Loaded the data into other data sources like SQL Server using SSIS
  • Configured data partitioning and table partitioning on huge tables containing numerous rows for better performance
  • Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run on a daily and weekly basis
  • Monitoring SQL Server logs to ensure that the backup operations, batch commands, and scripts have been completed successfully
  • Contacted various users in gathering the requirements and documented the necessary changes
  • Created necessary templates for various requirements gathering and documentation
  • Application support for front-end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues, and memory leaks
  • Monitored Log shipping and Transactional Replication and troubleshooting of errors.

SQL Server Database Administrator

Walmart (Contract)
Houston, TX
04.2016 - 09.2016
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases like index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update database statistics
  • Used Stored Procedures, DTS packages, and BCP for updating Servers
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers, and user-defined functions
  • Assisted Log shipping for synchronization of the database
  • Involved in the migration of SQL Server 2014 databases to SQL Server 2016
  • Involved in creating Stored Procedures, views, tables, and constraints
  • Monitoring the server for High availability of the servers
  • Created stored procedures and triggers for Data consistency
  • Implemented and Scheduled Replication process for updating our parallel servers
  • Evaluated data storage considerations to store databases and transaction logs.

Education

Associate of Science - Computer Science

Unity University College
Ethiopian
09-2010

Skills

  • OLAP
  • Data Review & Analysis
  • Programming
  • T-SQL
  • PowerShell
  • Microsoft SQL Server 2005/2008/2012/2014/2016/2017/2019
  • Microsoft Visual Studio 2003/2005/2008/2010
  • Management Studio
  • SQL Profiler
  • Database Tuning Advisor (DTA)
  • SQL
  • MS Office 2000/XP/2003/2007/2010
  • MS Excel 2000/XP/2003/2007/2010
  • MS Outlook 2000/2003/2010
  • MS Visio
  • MS Project
  • SSIS
  • SSRS
  • SSAS
  • ERWIN
  • PDM
  • Created Logins and Roles with appropriate Permissions
  • Fixed SQL server failed logins following migration projects following detach/attach decisions
  • Fixed the failed Logins and user permissions in Active Directory and at the SQL Server Level
  • Used IDERA SQL Diagnostic Manager for monitoring, analyzing, and troubleshooting
  • Used Red Gate, SQL Compare, and Data Compare tools to compare SQL Database Schemas
  • Handled numerous Change Management requests on production servers
  • SQL SERVER
  • Microsoft SharePoint
  • JavaScript
  • SQL Server 2008 R2/2012/2014/2016/2017/2019
  • Microsoft SQL Server Management Studio
  • Database Management
  • Introduction to MS SQL
  • Database Applications
  • SQL Query
  • Database Maintenance
  • Database Security
  • Database Objects
  • Database Operations
  • Microsoft Windows Server
  • Database Tools
  • Software Databases
  • Windows server environment
  • Database Configurations
  • Collaborator
  • Disaster Recovery
  • Performance Tuning
  • Microsoft SQL
  • Data Security
  • Data Testing
  • System Testing
  • Data Migration
  • Presentations
  • Safety Protocol
  • Data Modeling
  • Database Administration

Education Certificate

  • GED
  • SAP Certified
  • Certified Train the trainer
  • Green belt Six Sigma certified.

Timeline

SQL Server Database Administrator

Capital One (Contract)
11.2021 - Current

SQL Server Database Administrator

Geospace Technologies (Contract)
03.2019 - 11.2021

SQL Server Database Administrator

Frost Bank (Contract)
09.2016 - 03.2019

SQL Server Database Administrator

Walmart (Contract)
04.2016 - 09.2016

Associate of Science - Computer Science

Unity University College
Hiwot Getenet