Summary
Overview
Work History
Education
Skills
Timeline
Generic

Roger Ndanyeh

Turnhout

Summary

Highly analytical and results-driven IT professional with over five years of progressive experience in MS SQL Server Database Administration, fundamental knowledge in Microsoft Azure Cloud Computing, BI and Data Analysis. Proven success in deployment of effective IT roadmaps, processes, and procedures involving setting up high availability and disaster recovery solutions in SQL Server such as Always On availability groups, log shipping, replication, and traditional fail over clustering. Significant expertise in SQL server upgrade and database migration both on premises as well as to and from Azure cloud. Adept at database modelling and configuring security solutions in SQL Server such as Transparent Data Encryption, Dynamic Data Masking, Always Encrypted and much more. Also well versed with creating and managing users and logins in SQL Server and administering Active Directory users. Demonstrated history of successful execution of various processes comprising of disaster recovery solutions, monitoring, and database performance optimization. In addition, ETL, data cleaning in power query, visualization in BI tools such as Excel, Power BI and Tableau. Also versed with great understanding of the DAX language for data manipulating.

Overview

20
20
years of professional experience

Work History

Database administrator

Inspire Consulting LLC
01.2019 - Current
  • Collaborating in designing and implementing the migration of SQL databases to azure cloud
  • Develop, maintain, and optimize SQL Server Components and Architecture
  • Optimize database encryption and auditing ensuring security
  • Harness SQL Server database backup and restore
  • Collaborate with various teams in planning and implementing backup strategies for disaster recovery
  • Work with cross-functional teams to design and implement highly available, scalable, and secure Azure Infrastructure
  • Implemented security best practices in my environment
  • Worked with project managers from different vendors to understand the release plans and provided support and security strategies according to their requirements
  • Actively participated in the troubleshooting
  • Mitigated the risk of cluster failures by monitoring and optimizing resource utilization, preventing resource drainage, and enhanced overall cluster stability
  • Collaborated with security teams to implement security best practices, manage access controls, and ensure compliance with industry standards and regulations.

IT Support Technician

British Council
01.2004 - 12.2018
  • Troubleshoots hardware, software, and network issues to identify and resolve technical problems
  • Implement security measures to protect systems from cyber threats and ensure data confidentiality
  • Managing user accounts, permissions, and access rights to various systems and applications
  • Install, configure, and update hardware and software components
  • Implement security measures to protect systems from cyber threats and ensure data confidentiality
  • Perform routine maintenance tasks such as system updates, backups, and security checks to ensure the smooth operation of IT systems
  • Maintain detailed records of technical issues, resolutions, and system configurations for future reference
  • Provide training to end-users on how to use new software or hardware systems effectively.

Education

Skills

  • Networking
  • Always-on, Log shipping
  • Traditional Fail Over Clustering
  • Replication
  • Data Migration
  • Monitoring and Performance Optimization
  • Database Security
  • SQL and Windows Cluster Development
  • SSMS, Visualization (Hyper V)
  • Pivot Table and chart in excel
  • Troubleshooting
  • Dashboards in excel, Tableau, Power BI
  • ETL with Power Query
  • Power Pivot
  • Azure
  • Windows OS
  • Jira
  • Confluence
  • IT support
  • Effective Communicator
  • Active Listening
  • Empathy
  • Clarity and Directness
  • Teamwork
  • Adaptability
  • Critical Thinking
  • Problem-Solving
  • Resilience

Timeline

Database administrator

Inspire Consulting LLC
01.2019 - Current

IT Support Technician

British Council
01.2004 - 12.2018

Roger Ndanyeh