Eng

Case Study

TIER.net Centralisation Project

The TIER.net central system, managing over 13 million TB/HIV patient records, was suffering severe performance degradation during dispatch uploads from large provinces. The original single-server Hyper-V architecture lacked resilience and scalability. Dukstra Technologies was contracted in May 2019 to assess and redesign the environment, with Brian Zhou serving as product owner – translating stakeholder requirements into a workable technical architecture while remaining hands-on across every layer of the build.

The solution moved the platform from a single physical server to a multi-server architecture, isolating SQL operations and reporting onto dedicated servers. Brian led the Windows Server and Hyper-V build-out across all nine provinces, stood up Microsoft SQL Server environments hosting 1.7+ TiB of data, configured SSRS reporting and transactional replication for provincial synchronization, and hardened access control, VPN connectivity, pfSense firewall environments, and SSL certificate management. A dedicated reporting server reduced contention, while Windows Admin Center and RMM tooling provided ongoing monitoring of server health and performance.

Dispatch upload performance improved significantly, reporting stayed responsive during peak loads, and the re-architected system proved robust enough to handle growing data volumes – leading Brian’s involvement in the later migration of the on-premises infrastructure to Microsoft Azure.

Total People lived
in our city

0 K

Square kilometres
region covers

0 K

Private & domestic
garden land

0 %

Average Costs of Home
Ownership

0 th

Over three years
in the ruling

Save the Children believes every child deserves a future. In the U.S. and around the world, we give children a healthy start in life the Chief may also be involved in fire prevention.

Learn More