Summary
Overview
Work History
Education
Skills
References
Languages
Timeline
Generic

Hycinth Babila Tanyi

Airdrie,AB

Summary

I am a professional Database Administrator (DBA) with over 3 years of experience in SQL server Administration and Database design modeling and maintenance. I have been well experienced in dealing with, monitoring and managing large databases in an enterprise environment. Highly skilled in all aspects of database management including security checks and policies, performance tuning, troubleshooting, managing Backups and recovery models. Installing, configuring and updating various servers. Simplifying administrative processes through proper documentation, generating reports, setting up high Availability, Disaster recovery Solutions in SQL server, such as Always on availability groups, Traditional failover clustering, Log shipping, mirroring and Replication.

Trouble Shoot and resolve SQL server performance issues using both SQL server inbuilt tools and 3rd party tools, Maintain and achieve High availability of databases via coordinating with infrastructure teams to allocate system resources to Database Server. Generating Prompt response to tickets, resolve user request based off priority, and ensure database configuration maintenance. Resolve security and software concerns by carefully managing and pushing patches and other updates to production and non-production servers. Experience with partitioning schemas and tables, creating file groups using SQL server. Configure and manage High Availability and Disaster Recovery solutions Using (Always On, Failover Clustering, Log shipping and Replication). Experience in Administering SQL security by creating user logins with appropriate roles, monitoring user accounts, granting privileges to users and groups, administering the principal of least privilege. Experience in SQL server performance tuning, Query Optimization, client connectivity and Database consistency checks Using DBCC.

Overview

2025
2025
years of professional experience

Work History

SQL Server Database Administrator

CHRAPA (Implementing partners for UN Women and UNDP Cameroon)
12.2022 - 09.2024
  • Enhanced database performance and implemented recovery procedures on all servers.
  • Increased efficiency by 30% by providing optimum database performance with efficient backup and restore.
  • Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
  • Interacted with clients, application team, and project managers to implement and support solutions to meet client needs.
  • Configured and managed High Availability (HA) and Disaster Recovery (DR) solutions (Log shipping, Always On, Mirroring, Clustering).
  • Implemented database security using TDE (Transparent Data Encryption).
  • Used Query Store, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance database performance.
  • Did SQL and Windows patching.
  • Reviewed and optimized storage.
  • Responded to ticket queue (refreshing databases, creating logins and users, and granting privileges).
  • Daily health checks of all databases.
  • Documented all processes in a step-by-step manner to keep up with a good knowledge sharing policy within the team and the entire company.
  • Implemented and automated maintenance jobs.
  • Rebuilding the indexes at regular intervals for better performance.
  • Executed vertical and horizontal migration in SQL server using stand alone and cluster.

Junior SQL Database Administrator

ENEO, Cameroon
01.2020 - 06.2022
  • Successfully installed and managed SQL Server 2019 Enterprise edition.
  • Produced high-standard database solutions to meet stability, reliability, and performance metrics.
  • Ensured data security through DDM and TDE, and made recommendations for improvements.
  • Assisted in the monitoring and review of strong analytical, planning, and organizational skills, with the ability to manage competing demands.
  • Collaborated with the development team to ensure optimal database design and performance, analyzing and optimizing SQL server queries.
  • Updated statistics, database integrity checks, and backup operations.
  • Responsible for monitoring and troubleshooting log shipping.
  • Reviewed and optimized virtual machine environment.
  • Used log shipping for synchronizing the database.
  • Used data partitioning, snapshot isolation in SQL server.
  • Tested and implemented physical and logical backup and recovery methods to point-in-time recovery.
  • Troubleshooted and resolved issues that may arise with SQL server.
  • Used SQL Profiler, extended events, query store, and database tuning advisor to enhance performance.
  • Planned and implemented database backup/restore and Disaster Recovery.
  • Experience in conducting code reviews with application developers to ensure best practices for data access are used.
  • Resolved database and performance issues.

ENEO
Bamenda
01.2020 - 06.2022
  • Oversaw all facets of daily Microsoft SQL server functions including design and installation, configuration and tuning
  • Software and hardware upgrades, security, user provisioning, system troubleshooting, and backup and recovery management.

  • Successfully installed and managed SQL Server 2019 Enterprise edition
  • Produced high-standard database solutions to meet stability, reliability, and performance metrics
  • Ensured Data Security through DDM and TDE and made recommendations for improvements
  • Assist in the monitoring and review of strong analytical, planning and organization skills with ability to manage competing demands
  • Designed and implemented highly available and Scalable SQL server databases in my environment, monitored and troubleshooted performance issues
  • Collaborated with Development teams to ensure optimal database design and performance, Analyzing and optimizing SQL server queries
  • Update statistics, database integrity checks and Backup operations
  • Responsible to monitor and trouble shoot log shipping
  • Installed and configured SQL server following best practices
  • Reviewing and optimizing virtual machines environments
  • Used Log shipping for synchronization of Databases
  • Used Data partitioning, Snapshot isolation in SQL server
  • Database Design and Modelling
  • Tested and implemented physical and logical Backup and recovery methods, Point in time Media recovery
  • Troubleshooting and resolving issues that may arise with SQL server
  • Maintained Database Response times in 24/7 Production Environment
  • SQL server Profiler, Extended events, Query store and Database Tuning Advisor (DTA) for performance
  • Planning and implementation of Database Backup/restore and Disaster Recovery
  • Technical knowledge of an implementing of and experience with installing, upgrading and configuring and deploying end user hardware
  • Respond to and resolve database access and performance issues
  • Experience conducting code reviews with application developers to ensure best practices for data access are used

Education

KIAWITECH IT Academy
Houston, Texas
01-2019

Master of Science - International Business

University of Wollongong
10-2017

Associate Degree - Computer Science

University Of The People

Skills

  • Backup and Restore, Database refresh, Active directory, Data Migration Assistant (DMA), Activity Monitor, SQL Profiler, SSMS, TSQL, Configuration manager
  • Dynamic Data Masking (DDM), Transparent Data Encryption (TDE) Always Encrypted, Red Gate
  • Always on availability, Database mirroring, Log Shipping, Traditional Failover Clustering, VM- ware, Hyper V, Replication, SQL Databases
  • Database Modeling
  • Data Collection
  • Performance Tuning
  • Backups/Restore
  • Microsoft SQL server
  • Transact SQL
  • Active Directory
  • Implementing
  • Security
  • Measures
  • Always on
  • Configuration of Traditional Failover clustering
  • Power Shell
  • Comprehensive knowledge of SQL server installation, migration on premise, patching, troubleshooting, optimization, maintenance (modeling, HA (high availability) and DR (Disaster Recovery)
  • Skilled in building complex environments using functions such as Always On, Windows Failover Cluster, Log shipping and Mirroring
  • Competence in performance monitoring and Tunning
  • Competent organization skills, strong Analytical and critical thinking skills
  • Excellent attention to detail, cross-functional communication and ability to learn and adapt to change
  • Microsoft SQL server 2008- 2022
  • Advance Skills in Monitoring Tools

References

Albert  Tumasang, Project Manager, Eneo Cameroon  Tel: +237 673970114

Lidy Tayo   Tel: +1(240) 660-8536

Languages

English
Full Professional
French
Full Professional

Timeline

SQL Server Database Administrator

CHRAPA (Implementing partners for UN Women and UNDP Cameroon)
12.2022 - 09.2024

Junior SQL Database Administrator

ENEO, Cameroon
01.2020 - 06.2022

ENEO
01.2020 - 06.2022

KIAWITECH IT Academy

Master of Science - International Business

University of Wollongong

Associate Degree - Computer Science

University Of The People
Hycinth Babila Tanyi