Dominic Nkongho
Abingdon,MD
Summary
As a MS SQL DBA my functions spans the installation and post configuration of different versions and editions of MS SQL Servers(2008-2019),capacity planning, performance turning, monitoring, troubleshooting, patching and optimization of the databases,manage user access and permissions to ensure data security and compliance with Company's regulations. Managed High Availability and Disaster Recovery solutions such as Always-On Availability Group, Log shipping, Replication, Traditional Failover Clustering, database mirroring in both stand alone and cluster environments.
Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
Overview
9
9
years of professional experience
Work History
MS SQL Server Database Administrator
District Healthcare Services, LLC
Abingdon, MD
02.2022 - Current
- 6+ Years of Experience in Installation, Configuration and administration of MS SQL Server 2008 to 2019 in production, test and development environments following Microsoft best practices.
- Experience in setting up and managing High Availability/Disaster Recovery (HADR) solutions; AlwaysOn Availability Groups, SQL Server Failover Clusters, replication, mirroring, log-shipping etc
- Creating and scheduling SQL Server jobs to perform database maintenance activity,Updating statistics, Consistency checks, Rebuilding indexes,Monitoring error logs and event logs for database errors,Index Tuning Advisor,SQL Server native tools and services etc
- Experience in setting up and managing Extended Events,Dynamic Management View,SQL Server Broker Service,Linked Servers, MSDTC, SQL Server System Databases,Database Mail,SQL Server Health Checks and Policies,Managing SQL Server security and auditing,Database roles
MS SQL Server Database Administrator
WebstaurantStore Distribution Center
Aberdeen, MD
03.2022 - 01.2023
- Installing and upgrading SQL Servers, including applying service packs
Performing routine database maintenance - Managing SQL Server security and auditing
User security
Database roles
Authentication methods
SQL Server and database auditing
Encryption at rest, transit, and backup
Capacity Planning for storage and database objects
Maintaining and managing SQL Server disk space to ensure storage is properly utilized
Index and statistics usage
Managing disk storage for Windows Failover Cluster Service (WFSC)
Database backup and recovery
Establishing standards and schedules for database backups
Developing recovery procedures to meet RPO and RTO
Restoring databases with point in time recovery
Creating and testing Disaster Recovery plans - Proficient in TSQL coding, tuning, and ETL methodologies
SQL Server High Availability Methods
Mirroring
Always On
MS SQL Server Database Administrator
Rite Aid Distribution
Aberdeen, MD
09.2019 - 12.2021
- Identify any issues such as performance bottlenecks, fragmentation, or inconsistencies.
Perform routine maintenance tasks such as index rebuilds, statistics updates, and database integrity checks. - Monitor and maintain Always On Availability Groups for SQL Clusters,Ensure synchronization state across replicas,Perform failover testing and handle failover scenarios as necessary.
- Schedule and perform SQL Server updates and patches,Coordinate with stakeholders to minimize downtime and ensure updates are applied in a timely manner.
- Work with application owners to plan and execute migrations to SQL Server 2019,ensure compatibility and performance optimization during the migration process.
- Evaluate resource utilization and performance impact,Plan and execute server consolidation efforts while minimizing disruption to existing services.
- Backup and Recovery Management,Review and optimize SQL backup schedules and technologies. Implement backup strategies to ensure data integrity and disaster recovery readiness.Monitor backup jobs, troubleshoot failures, and perform periodic recovery tests.
MS SQL Server Database Administrator
Eshcol Travel & Tours
Yaounde, Cameroon, Cameroon
04.2017 - 03.2018
- Performs all aspects of database management including installation, patching, backup and recovery, performance and tuning, security administration and space management.
- Database Backup, Backup Verification, and Restore.
- SQL Server Process Documentation.
- Troubleshooting Reported Service Support Issues.
- Database tuning and performance monitoring, Monitor and maintain the health and performance of SQL Server instances.
- Establish and maintain sound disaster recovery policies, backups, and procedures.
IT Service Desk Technician
Computer World W.L.L
Buea, Cameroon, Buea Cameroon
07.2015 - 01.2017
- Configure, install, deploy, upgrade, secure, maintain, and support desktops, laptops, tablets, printers, scanners, and other peripheral devices as assigned
- Set up, troubleshoot, and repair printers and other peripherals.
- Maintain an inventory of equipment, including laptops, printers, and related supplies
- Perform basic network administration tasks, including monitoring and maintenance of networks; manage office networking issues, including Wi-Fi, LAN, and connectivity problems.
Education
Associate of Arts - Human Resources Development
Pan African Institute For Development (PAID-WA)
Cameroon06-2013
Skills
- Strong verbal and written communication skills, with an ability to express
- Ability to multi-task and context-switch effectively between different activities and teams
- Effective Listening, Time Management, Verbal communication, and written communication skills
Timeline
MS SQL Server Database Administrator
WebstaurantStore Distribution Center
03.2022 - 01.2023
MS SQL Server Database Administrator
District Healthcare Services, LLC
02.2022 - Current
MS SQL Server Database Administrator
Rite Aid Distribution
09.2019 - 12.2021
MS SQL Server Database Administrator
Eshcol Travel & Tours
04.2017 - 03.2018
IT Service Desk Technician
Computer World W.L.L
07.2015 - 01.2017
Associate of Arts - Human Resources Development
Pan African Institute For Development (PAID-WA)