FLORIS M. NGANDU
Raleigh,NC
Summary
Over 5+ years of experience in SQL Server Database Administration. Highly skilled in orchestrating high availability and disaster recovery solutions by implementing failover clustering, log-shipping, mirroring, replication, Always On, analyzing performance and tuning data. Proficient in reviewing database designs and documents for providing suggestions for enhancement base and optimal performance of databases, ETL, Windows Clustering, with strong experience in migrating application and IT infrastructure to public cloud, Patches,Refreshes, SQL Server Upgrades,Creating and Managing logins and users following the principle of least privilege, thorough understanding of backup and recovery processes and end to end Project Management. Strong Experience with SQL Server 2012 through 2019 Administration standalone and cluster environment.
Overview
10
10
years of professional experience
1
1
Certification
Work History
MS SQL Database Administrator
Duke Health
08.2020 - 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
SQL Server Database Administrator
CNC Logistics(AMAZON)
08.2018 - 07.2020
- 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 environment.
Service Desk Analyst
Western Union
01.2015 - 05.2018
- Answered queries by telephone or self-service ticket to support internal and outside computer hardware, software, network, application access and telecommunications systems.
- Delivered basic support and troubleshooting such as password resets, printer configurations and break/fix instructions.
- Analyzed and resolved IT problems to achieve complete resolution for customers with minimal productivity loss.
- Routed, tracked and managed client's service desk tickets from inception to close and documented issues and results.
- Documented solutions and troubleshooting steps concisely in ticketing system and alerted other team members of new service solutions.
- Support end-users with installation, configuration, and troubleshooting of hardware and software to ensure continued usability of equipment and software at a Tier II level - including, but not limited to: Network Connectivity, MS Office, Microsoft Outlook, tablet/smartphone support, Windows 7/10
Education
MS SQL Server Database Administration
KiawitechIT Academy
Houston, TXAssociate of Science - Pharmacy Technology Programme
Duke University
Durham, NC04.2021
BBA -
University of Zambia
Lusaka, Zambia2018
Skills
- Performance Tuning & Monitoring using DMV, Extended Events, Activity Monitor
- Installation, Configuration of MS SQL Server versions from 2008 to 2019 following best practices
- Configuring Replication, Failover Clustering, Log Shipping, AlwaysOn Availability
- Database Migration, Backup and Restore
- T-SQL Scripting
- Index management, integrity checks, statistics
- Managing Logins and Permission for multi-user
- Configuring Transparent Data Encryption, Dynamic Data Masking and Always Encrypted
- Log Shipping, Always-On High Availability
- Traditional Failover cluster, Replication
- Performance Monitoring & Tuning
- Data Modeling & Application Design
- Basic proficiency in dataset analysis using Python
Certification
- Microsoft Certified Azure Database Administrator Associate [AZ104]- Currently Pursuing
Timeline
MS SQL Database Administrator
Duke Health
08.2020 - Current
SQL Server Database Administrator
CNC Logistics(AMAZON)
08.2018 - 07.2020
Service Desk Analyst
Western Union
01.2015 - 05.2018
- Microsoft Certified Azure Database Administrator Associate [AZ104]- Currently Pursuing
MS SQL Server Database Administration
KiawitechIT Academy
Associate of Science - Pharmacy Technology Programme
Duke University
BBA -
University of Zambia
Similar Profiles
Laikyn TilleyLaikyn Tilley
Professional Nursing Assistant at Duke HealthProfessional Nursing Assistant at Duke Health
Ashley BrownAshley Brown
Financial Care Counselor at Duke HealthFinancial Care Counselor at Duke Health
Nicole MaleckiNicole Malecki
Duke Infusion Nurse at Duke HealthDuke Infusion Nurse at Duke Health