Summary
Overview
Work History
Education
Skills
Timeline
Generic

Joshua Nfuah

Summary

Professional SQL specialist with strong track record in database management, optimization, and security. Proven ability to enhance performance and ensure data integrity. Known for effective team collaboration and adaptability in dynamic environments. Skilled in SQL scripting, troubleshooting, and database architecture, delivering reliable and efficient solutions.

Overview

8
8
years of professional experience

Work History

MS SQL Database Administrator

REM North Dakota
01.2021 - Current
  • Using SQL server in-built tools such as SQL Server profiler, Extended Events, activity monitor-to-monitor performance and system health; Database Integrity checks to ensure database integrity, stability, and system availability
  • Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and with technologies such as Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client’s or customers sensitive data
  • Implement and define a vigorous Backup and Recovery strategy and Capacity planning following the company's SLA that is Recovery Point Objective (RPO) and Recovery Time objective (RTO) and the Retention policy
  • Planning the Installation of Microsoft SQL Server 2005SP4, 2008R2, 2012, 2014, 2016, 2017, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patches during scheduled database nonproduction hours to ensure databases are up to date in Virtualized environments
  • Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems
  • Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production in standalone and Clustered environments such as Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WTFC), Database Mirroring, Replication such as transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, updating statistics for query optimization using performance and activity monitor, event viewers, extended events
  • Analyze, solve, and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning, Partitioning, compression and updating statistics to enhance speed and maximize system performance
  • Create and update database documentation about company standard procedures, technology features and production issue troubleshooting
  • Creating and monitoring maintenance plans and agent jobs that automates backups and reorganize/rebuild indexes for query performance
  • Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing on call support during after-hours and weekends
  • Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24/7 support
  • Review scripts submitted by the development team and working with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases
  • Control and establish appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases
  • Develop database security guidelines and perform audits
  • Migrate SQL server databases from on-premises to AZURE using Data Migration Assistant
  • Develop and monitor system and application alerts to ensure Health monitoring and performance tuning
  • Create and maintain azure managed SQL instances and databases

SQL Server Database Administrator

MOLEX
06.2018 - 12.2020
  • Company Overview: Chicago, IL
  • Backup and Restore (Using both native SQL Server and LightSpeed External backup tool)
  • Monitoring Performance and managing parameters using SPORT LIGHT external monitoring tool
  • Biweekly Database Refresh from PROD to STG, DEV AND UAT environments
  • Production level support for onsite and offshore - On Call 24/7 environment
  • Examined 'Code Reviews' from BA's, DA's, BI
  • S and Developers
  • Setting up Jobs as need arises
  • Created Documentation of all SQL Server processes
  • Controlling access permission and privileges
  • Maintained database response times in 24X7 Production environments
  • Database Security (Access control, Logins and Permissions etc.)
  • Configured Log Shipping for Disaster recovery
  • Troubleshoot Performance issues
  • Upgrades and Patches
  • Troubleshoot Performance issues
  • Index Optimization
  • Developing, managing, and testing back-up and recovery plans
  • Writing basic TSQL commands, Troubleshoot wrong written Queries and User problem
  • Chicago, IL

SQL Database Administrator

MTN CAMEROON
02.2017 - 04.2018
  • Company Overview: BUEA Cameroon
  • Prioritizing and responding to and execute tasks in a high-pressure environment
  • Design, develop, test, deploy and maintain databases, database objects, database security and database recovery solutions
  • Planned and coordinated security measures such as TDE, DDM and AE
  • Applying the principle of least privileged
  • Instituted the maintenance and support of Replication and Log Shipping
  • Created various maintenance plans for index fragmentation and backups to automate the team’s tasks and ensure better system health and performance
  • Identify existing systems that are candidates to be enhanced or modernized though detailed analysis of the use and design of current databases
  • Responsible for taking and maintaining database backups for recovery in the event of disasters
  • Upgraded SQL Server 2005 sp4 servers to SQL Server 2016 with both In-place and Side by Side Upgrade for new applications in the company
  • Configure and setup Always On availability groups in a 3-node windows cluster environment where two where on premises and 1 in a data center for Disaster recovery
  • Handled SQL Server installation, Configuration, Security, and maintenance following best practices
  • Using SQL Server Profiler, Extended Events, Query Store, Database Engine Tuning Advisor (DTA) for performance and monitoring
  • Cooperate with developers when writing complex queries and schema refinement
  • Working with the entire IT team to maintain database response times in 24/7 Production environments by developing automated alert jobs
  • Develop rules and guidelines for the development of SQL objects
  • Optimize indexes and tables
  • Create and maintain database dictionaries and schema documentation
  • Design and deploy data table structures, triggers, functions, stored procedures, and views
  • Create queries and reports
  • Fulfill data requests
  • Resolve database access and performance issues
  • Interface with developers, network, virtualization, storage, and systems operations teams to resolve problems with applications and database systems
  • BUEA Cameroon

Education

Bachelor of Science - Computer Sciences

University of Buea
Cameroon
10-2014

Skills

  • Database management
  • Data migration
  • Performance tuning & Query optimization
  • Backup strategies & Data backup
  • Data security
  • Replication setup
  • Database maintenance
  • Troubleshooting
  • Database upgrades & patching
  • High availability & Database clustering
  • SQL server administration
  • Collaboration and Team work

Timeline

MS SQL Database Administrator

REM North Dakota
01.2021 - Current

SQL Server Database Administrator

MOLEX
06.2018 - 12.2020

SQL Database Administrator

MTN CAMEROON
02.2017 - 04.2018

Bachelor of Science - Computer Sciences

University of Buea

Similar Profiles

CREATE PROFILE
Joshua Nfuah