Summary
Overview
Work History
Education
Skills
Contact
Education
Certification
Personal Information
Timeline
Generic

Ugochukwu Ogbu

Lanham,MD

Summary

Adept SQL Server Database Administrator with a proven track record at St Theresa Nurselink, enhancing team productivity and achieving a 99.9% system uptime. Expert in performance tuning and disaster recovery, I bring strong leadership and effective communication skills to the table. Skilled in AlwaysOn availability groups and database security, ensuring robust and compliant database environments.

Overview

8
8
years of professional experience
1
1
Certification

Work History

SQL Server Database Administrator

St Theresa Nurselink
Maryland
05.2018 - Current
  • Provided technical leadership and guidance to junior team members on database administration best practices and tooling, leading to an increase in team productivity across various digital channels at St Theresa.
  • Successfully managed and maintained databases in virtual and cloud environments, including Production, Staging, and Development databases, achieving a 99.9% system uptime.
  • Collaborated effectively with the infrastructure team to optimize MS SQL Server performance and ensure system stability, resulting in a 15% improvement in database response time.
  • Implemented timely patching and upgrades of MS SQL Server while maintaining rigorous security standards and documentation, ensuring 100% compliance with security protocols.
  • Demonstrated leadership by overseeing database projects, performing troubleshooting, and offering mentorship for escalated issues, resulting in consistently efficient and reliable database operations.
  • Monitored database status, including CPU, memory, I/O, space, and deadlock issues using SQL Server Utilities.
  • Created and supported ETL processes to SQL Server, Access to SQL Server, Excel to SQL Server.
  • Worked on setting up the SQL Server Configuration to resolve resource allocation and memory issues for SQL Server databases and set up ideal memory and min/max server options.
  • Managed and troubleshoot SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, Azure SQL, Azure Managed Instance, SQL VM Instances both on-premises and in the cloud.
  • Migrated and Upgraded SQL server from Legacy to 2016, 2017, & 2019 and Azure.
  • Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
  • Managed RDS SQL Server and MySQL
  • Major point of contact in analyzing AWS tools in fixing performance issues.
  • Expertise in leveraging CloudWatch, PI, and EM in fixing performance issues and RCA
  • Expertise in planning and cost management
  • Expertise in AWS DMS and SCT
  • Expertise creating and assigning IAM roles and users, using the principle of less privilege.
  • Expertise in creating EC2 instances for databases.
  • Expertise in Multi-AZ and Availability Zones in the AWS Cloud
  • Strong leadership and capacity planning qualities.

Database Administrator I

April 2 Ventures
08.2016 - 05.2018
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
  • Participated in SQL Server Database Security Audit by degradation Of Sys Admin Security Privileges of over 200 Security objects.
  • Configured, and managed SQL Backups Using Commvault Command Center for both on-premises and Azure cloud environment.
  • Migrated SQL server from Legacy 2008 to SQL 2016 on advanced Pure storage in eVDC.
  • Built shared cluster with AlwaysOn facility to save the license cost and provided Disaster recovery for mission-critical applications.
  • Experience in building three node AOAG traditional clusters for critical applications and in shared Infrastructure.
  • Migrated 50 servers from on-prem to Azure cloud. Some stand-alone instances and some on AlwaysON High Availability Instances. Moved some to Azure managed instances, Azure SQL
  • Created and supported ETL process from Oracle to SQL Server, Sybase to SQL Server, Access to SQL Server, Excel to SQL Server.
  • Increased the MS SQL Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.
  • Monitored and fixed nightly maintenance; optimized and improved DTS and SSIS packages.
  • Performed upgrades and security patches to databases as required.
  • Experience in Supporting thousands of SQL servers in a mission-critical and highly available environment.
  • Experience in Disaster Recovery Planning and Implementation.
  • Solid experience in High availability (Always-On) SQL Server solutions, including Replication Models. (Snapshot/Transactional), Log Shipping, Mirroring, and HADR Setup Configuration.
  • Hands-on experience in GCP and Azure
  • Great expertise in effectively communicating, supporting, troubleshooting, and resolving customers issues.
  • Strong knowledge of MS Office products.

Education

Bachelor of Science - Computer Science

Federal University of Technology
Owerri, Nigeria

Skills

  • AlwaysOn availability groups
  • SQL server reporting services
  • Database security
  • SQL server integration services
  • Resource governor
  • SQL server agent
  • Log shipping
  • Database mirroring
  • SQL profiler
  • Database mail
  • Disaster recovery
  • Performance tuning
  • Backup and recovery
  • SQL server analysis services
  • Data warehousing
  • Replication management
  • Database auditing

Contact

Lanham, MD 20706

Education

Owerri, Nigeria

Certification

  • Microsoft Certified: Azure Data Fundamentals (DP-900) - Certification
  • Microsoft Certified: Azure Fundamentals (AZ-900) - Certification
  • AWS Certified Cloud Practitioner - AWS Certification

Personal Information

Title: Database Administrator/Engineer

Timeline

SQL Server Database Administrator

St Theresa Nurselink
05.2018 - Current

Database Administrator I

April 2 Ventures
08.2016 - 05.2018

Bachelor of Science - Computer Science

Federal University of Technology
Ugochukwu Ogbu