The client is a B2B project management software provider used by mid-market operations teams for complex workflow orchestration, serving 18 enterprise clients each running on a dedicated, fully isolated environment before this engagement. However, they faced significant hurdles:
- Cost Prohibitive: Spinning up new infrastructure for every client was expensive and eroded gross margin with every new sale.
- Slow Sales Cycle: Onboarding took weeks of manual provisioning, frustrating both sales and new customers eager to start.
- Maintenance Hell: Updating software meant deploying to 18 separate environments, each with slightly different configuration drift.
- Enterprise Requirements: A subset of premium clients had contractual requirements for physical data isolation that a naive shared-tenant model couldn't satisfy.
We redesigned the backend for multi-tenancy with strong isolation, while still honoring the premium tier's dedicated-infrastructure requirement:
- Row-Level Security (RLS): Implemented in PostgreSQL to ensure tenant data isolation within a shared database for standard-tier customers.
- Cognito Custom Attributes: Mapped users to tenant IDs automatically at login, removing a whole class of manual account-setup steps.
- Terraform Modules: To automatically provision dedicated resources for premium "Enterprise" tier tenants who still needed physical isolation, generated from the same codebase as the shared tier.
- Self-Serve Onboarding Flow: New standard-tier customers could now activate an environment in minutes instead of filing an infrastructure ticket.
Cost Per Tenant ($)
Designing the tenant isolation strategy and getting sign-off from the two enterprise clients with the strictest compliance requirements.
Writing tooling to safely merge 18 separate database schemas into the new shared-tenant model without data loss.
Testing with 5 pilot customers before committing to the full cutover.
Cutover of all 18 client environments in a single coordinated weekend migration window.
Infrastructure costs dropped by 35% as resources were shared efficiently across the standard tier. New client onboarding moved from weeks to the same week, allowing the sales team to close deals faster and remove a recurring objection from the sales process.
The Terraform-based premium tier also turned out to be a selling point of its own — the client began marketing "dedicated infrastructure" as a distinct pricing tier, something the old architecture could never have offered consistently.
"Our margins used to be eaten up by server costs. Now, we add customers without adding overhead. It's pure profit."