Greg Duffie

Randstad Digital

Architected Schema Migration (Multi-Config → Single-Clinic)

Senior SQL Server Database Architect, Administrator, and Lead Developer2023

Situation

The legacy "multi-config" pod/chair schema was creating data duplication and maintenance complexity that slowed development velocity and made the system harder to reason about as the clinic count grew.

What I Did

Designed and executed a strategic transition from the legacy multi-config architecture to a streamlined clinic-centric schema. Coordinated the migration in phases to avoid disrupting the live scheduling system serving active clinics.

Result

Reduced data duplication and maintenance complexity across the schema, simplifying the data model and accelerating future feature development.

Tools & Tech

SQL ServerArchitectureSchema Design