Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

HENRY DANJUMA

Texas

Summary

Cloud and Database System Administrator with 8 years of experience in database management, system design, and ETL processing across various on-premise and cloud platforms with excellent troubleshooting skills. Seeking to contribute proven expertise in process automation, software optimization and monitoring to increase their reliability, availability, scalability and ensure overall database system health.

Overview

8
8
years of professional experience

Work History

Database Administrator

Amdocs
01.2022 - Current
  • Leveraged Oracle Enterprise Manager and SQL Server Management Studio to accurately size database and cloud resources; and devise strategic design plans, maintaining databases at optimal sizes for large companies including AT&T, Orange, Sky, T-Mobile, and Vodafone Disney, Warner Bros, and MUFG Bank
  • Partner with IBM, Microsoft, Google, and AWS to migrate 500+ on-premises databases to cloud platforms (AWS, Azure, GCP) utilizing microservices architecture with Docker for containerization and Kubernetes for orchestration
  • Ensure the availability and performance of multiple database and application environments using SolarWinds and Redgate, effectively handling high capacity demands and diverse system requirements
  • Automate routine DBA tasks, like maintenance, backups, recovery, and upgrades using PowerShell and SQL Server Agent, reducing manual intervention and maintaining peak system performance with minimal downtime
  • Collaborate with cross-functional teams using Jira and Confluence to streamline processes; and use Splunk, Redgate to monitor network traffic while resolving ServiceNow tickets leading to a 2-hour reduction in daily resolution time
  • Design database structure using ER/Studio and SQL Developer, implementing indexes, constraints, and data integrity measures tailored to business needs, resulting in a 20% improvement in database performance
  • Use Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, and scripts, to resolve bottlenecks, deadlocks, and slow running queries
  • Consult and plan with business and applications owners regarding new SQL server builds or reassessment of existing
  • Backup/Recovery and Disaster recovery Procedure
  • Monitor and manage the disks storage events for over 300 database servers.

SQL Database Administrator

TeleWorld Solutions
12.2020 - 12.2021
  • Streamlined, manage, and automate SSIS, SSRS, and SSAS packages, enhancing data integration, reporting, and analysis capabilities, leading to a reduction in data processing time helping to make 5G a reality for 1M+ end users
  • Installed, configured, and maintained multiple SQL database instances to support various applications across organization.
  • Developed and executed SQL scripts for database creation, modification, and maintenance tasks, ensuring proper functioning of databases.
  • Implemented high availability features such as Clustering, Always On, Log Shipping, Database Mirroring, and Replication, increasing system uptime by 99.99% and ensuring seamless access to critical business data
  • Implemented and managed regular database backup and recovery strategies to prevent data loss and ensure business continuity in case of system failures.
  • Assisted in database restoration processes during testing and production environments, ensuring data integrity and accuracy.
  • Installed and managed over 400+ servers in start to end onboarding process.
  • Developed and deployed custom Crystal Reports for financial, operating, and billing processes, and implemented disaster prevention and recovery strategies to safeguard valuable business data.
  • Ensured robust data security and efficient problem resolution by leveraging in-depth knowledge of SQL Server architecture, connectivity, replication, and backup/restore processes, facilitating timely adherence to SLAs.
  • Monitored error logs using Splunk and performed health checks, using performance tuning tools like Query Store, Extended Event and SQL Server Profiler, consistency checks with DBCC, defragmentation, and index tuning.

Database Administrator/System Admin Analyst

Startech Network
01.2019 - 11.2020
  • Developed custom ServiceNow applications and modules to align with business requirements, utilizing ServiceNow Studio IDE and JavaScript, leveraging platform's out-of-box functionality.
  • Administered ServiceNow platform upgrades and maintained system integrations using REST/SOAP web services, ensuring seamless communication between various IT systems and minimal disruption during version transitions.
  • Collaborated with stakeholders to gather requirements, design, and implement ServiceNow workflows and automation using Flow Designer and IntegrationHub, streamlining service delivery and reducing manual intervention.
  • Utilized cloud tools such as AWS Cloud Format on, Azure Resource Manager templates, and Google Cloud Deployment Manager to automate infrastructure provisioning and management, optimizing resource utilization and scalability on respective cloud platforms.
  • Leveraged cloud monitoring and management tools like AWS CloudWatch, Azure Monitor, and Google Cloud Operations Suite to proactively identify and resolve potential issues, ensuring optimal system performance and reliability across multi-cloud environments.
  • Conducted performance tuning and optimization of database systems to improve query response times and overall system efficiency.
  • Collaborated with application developers to optimize queries and improve database access patterns, enhancing overall performance of applications.
  • Proactively monitored and diagnosed database issues, such as performance bottlenecks, locking conflicts, and data corruption, and promptly resolved them to minimize downtime and service disruptions.
  • Assisted in database audits and compliance checks to ensure data security and regulatory adherence.
  • Maintaining availability of production databases
  • Oversee database replication and backup.
  • Analyze, consolidate, and tune databases for optimal efficiency.
  • Ensuring database security and integrity.

Database Engineer

Access Bank
02.2015 - 12.2018

Education

Bachelor of Science - Business Administration

University of Ilorin

Skills

  • Technical Skills:
  • Database Design & Management Cloud Migration Server Integration Encryption Backup and Recovery Site Reliability & Monitoring Disaster Recovery Planning ETL Processing & Data Warehousing Server Integration Postgres Data Transformation Services Upgrade Wizard & Replication Linux Administration MySQLDB2
  • Scripting Tools & Platforms: PowerShell TSQL SQL Microsoft NET framework Linux Command Line
  • ETL & Cloud Infrastructure: SSIS DTS SQL AWS Azure
  • Other Technology Tools & Platforms: Splunk SolarWinds Commvault ServiceNow Redgate Docker EKM Jira/Confluence
  • Critical Thinking
  • Complex Problem-Solving
  • Implementing security measures

Accomplishments

  • ServiceNow System Administrator – November 2021 | Microsoft DP-300 – November 2021 | Microsoft AZ-104 – August 2021

Timeline

Database Administrator

Amdocs
01.2022 - Current

SQL Database Administrator

TeleWorld Solutions
12.2020 - 12.2021

Database Administrator/System Admin Analyst

Startech Network
01.2019 - 11.2020

Database Engineer

Access Bank
02.2015 - 12.2018

Bachelor of Science - Business Administration

University of Ilorin

Similar Profiles

CREATE PROFILE
HENRY DANJUMA