Clement Ukwishaka
Houston,TX
Summary
MS SQL Database Administrator with 5 years of expertise in managing, optimizing, and securing SQL Server environments. Demonstrates proficiency in high availability solutions including failover clustering, log shipping, and Always On setups, complemented by robust skills in performance tuning and disaster recovery planning. Skilled in automating database tasks and enhancing system security, ensuring compliance with company SLAs and industry best practices.
Overview
5
5
years of professional experience
Work History
MS SQL Database Administrator
Alpha Testing/Universal Engineering Sciences
09.2022 - Current
- Performed all day-to-day aspects of MS SQL database administration
- Responsibilities include database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution
- Responding to ticket queue (refreshing databases, creating logins and users)
- Automation of DBA Tasks and monitoring
- Designed and implemented comprehensive Back up and disaster recovery strategies according to company’s SLA
- Setting up always On, replication and database mirroring
- Installed and configured different versions of SQL Server
- Implement and enforce security for all the SQL Server Databases
- Used Performance monitor, Activity Monitor, DMV and Extended Events to optimize queries and enhance the performance of database servers
- Windows and SQL patching
- Reviewing and optimizing storage
- Configured High Availability Solution- Always On Cluster, Traditional Failover Clustering, and Log Shipping
- Capacity planning and resource allocation
- Respond to and resolve database access and performance issues
- Documented processes for installations, clustering, availability group setup, and patching
- Designed and implemented comprehensive Backup plan and disaster recovery strategies
- Rebuilt indexes at regular intervals per Microsoft recommendations for better performance
- Used Activity Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
- Training courses on Azure Cloud Technology for migration support
- Optimized SQL query performance, reducing load times by 20% through in-depth analysis.
SQL Server Database Administrator
Terracon Consultant, Inc
12.2019 - 07.2022
- Setup/Installation of SQL Server test, development, and production environments
- Administered the installation and upgrade of SQL Server software products, monitoring, and maintenance tools
- Administered data backups for effective disaster recovery
- Monitor database "health" - availability, reliability, performance, capacity planning, server clustering
- Automates system procedures using both windows and SQL Server scripting
- Supporting, maintaining, troubleshooting, installing, configuring, and upgrading multiple Programs of Records (many mission critical)
- Providing user support and guidance
- Performing daily weekly and monthly data maintenance tasks through re-indexing, integrity checks, database shrinking, log file monitoring
- Upgrade and patch SQL Server services under high availability infrastructure with "Fail-Over Clustered Instance", "Always-On Availability Group" and "Log-Shipping
- Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
- Maintaining production databases, performing periodic patch upgrades and reviewing existing policies and procedures and suggesting suitable changes if necessary
- Used the query store and Execution Plan to improve the optimization of the T-SQL code
- Provided 24 x 7 Production support for the database and application issues
- Configure SQL / DB MAIL for sending server / database alerts
- Monitoring and scheduled jobs on production and staging.
Education
MS SQL Server Database Administration -
KiawitechIT Consulting LLC
Houston, TXAssociate Degree in Computer Science -
Sinclair Community College
Cincinnati, OhioMicrosoft Certified Azure Database Administrator Associate [AZ104] -
KiawiTech Consulting LLC
Skills
- Performance Tuning
- Monitoring
- SQL Server Installation
- Configuration
- Replication
- Failover Clustering
- Log Shipping
- AlwaysOn Availability
- Database Migration
- Backup
- Restore
- T-SQL Scripting
- Index Management
- Integrity Checks
- Statistics
- Login Management
- Permission Management
- Transparent Data Encryption
- Dynamic Data Masking
- Always Encrypted
- Always-On High Availability
- Traditional Failover Cluster
- Performance Monitoring
- Tuning
- Data Modeling
- Application Design
- Disaster Recovery
- Windows Clustering
- Patches
- SQL Server Upgrades
References
Available upon Request
Timeline
MS SQL Database Administrator
Alpha Testing/Universal Engineering Sciences
09.2022 - Current
SQL Server Database Administrator
Terracon Consultant, Inc
12.2019 - 07.2022
MS SQL Server Database Administration -
KiawitechIT Consulting LLC
Associate Degree in Computer Science -
Sinclair Community College
Microsoft Certified Azure Database Administrator Associate [AZ104] -
KiawiTech Consulting LLC
Similar Profiles
SAMUEL R. PEREZSAMUEL R. PEREZ
Project Manager & Environmental Scientist at Universal Engineering Sciences (UES)Project Manager & Environmental Scientist at Universal Engineering Sciences (UES)
Rachel MayRachel May
Field Technician at Universal Engineering Sciences, IncField Technician at Universal Engineering Sciences, Inc
Audrey BrickeyAudrey Brickey
Lead Biller/Lead Project Administrator at Universal Engineering Sciences, IncLead Biller/Lead Project Administrator at Universal Engineering Sciences, Inc