Case Study

Case Study Consolidating Election Technology for New York Counties

How we consolidated separate legacy voter databases into a single white-labeled centralized platform on Azure, reducing overhead and maintenance.

The Client

A trusted partner for voter database management and election operations in New York.

Our client is a leading software and service provider specializing in voter database management and election operations. Serving County Boards of Elections and School Districts across New York State, they deliver critical, high-stakes infrastructure that ensures secure, accurate, and compliant voting processes. Their systems manage voter registration records, signature verification files, ballot layouts, and district poll mappings for thousands of voters.

In the public sector, particularly regarding election technology, data integrity and platform reliability are non-negotiable. System failures, data corruption, or downtime during election cycles can lead to severe legal and civic consequences. The client's products must comply with state and federal regulations, requiring robust security measures, strict access controls, and comprehensive audit logs.

As they expanded their client roster to include more counties and school districts, the administrative overhead of managing their software footprint grew. The client recognized that their existing architecture, while reliable, was not built to scale efficiently. They partnered with our engineering team to modernize their software delivery model and streamline system management.

The Challenge

Resolving the complexity of distributed systems management.

When we began this project, the client was operating under an outdated software distribution model. For every new county or school district they onboarded, they deployed a separate database and a dedicated server instance. This meant they were maintaining dozens of isolated environments, each running its own copy of the voter management application.

This distributed approach was highly resource-intensive. Applying security patches, database schema updates, or custom software configurations required the IT team to log into each server individually, making maintenance cycles slow and error-prone. It also limited the client's visibility into overall operations, as there was no centralized dashboard to monitor system health, data syncs, or user activity across their entire customer base.

To sustain their growth, the client needed a digital transformation. They required a unified platform that could consolidate these isolated databases, modernize their legacy technology stack, and simplify system updates and support.

Every County Board and School District had a dedicated database and server, leading to severe complexity.

Upgrading and patching dozens of isolated systems was slow and heavily strained IT support resources.

Outdated software dependencies limited the client's ability to introduce modern features.

Distributed environments made centralized monitoring and security auditing difficult.

What our audit found

Analyzing the bottlenecks of a multi-instance architecture.

Our engineering team conducted a detailed structural audit of the client's infrastructure. We analyzed server performance metrics, evaluated database replication speeds, and reviewed the deployment pipelines. The audit confirmed that the primary bottleneck was not the application's core code, but the multi-instance deployment architecture.

Having multiple isolated SQL databases created a massive footprint that was expensive to host and difficult to secure. Because there was no centralization, any query optimization or schema change had to be replicated across all instances manually, increasing the likelihood of database drift. Additionally, the technology stack was built on older framework versions that lacked native container support and modern API routing capabilities.

We determined that the client needed to transition from a multi-instance model to a multi-tenant, centralized database architecture. By containerizing the application and utilizing a single database with secure row-level separation for different clients, they could significantly reduce hosting overhead and simplify system administration.

1

Separate server hosting inflated cloud costs and wasted processing power.

2

Database schema drift occurred between counties because of manual database patching.

3

Older technology libraries limited the implementation of modern security protocols.

4

Absence of a centralized database prevented aggregation of state-wide reporting insights.

The Solution

How we turned it around.

Unified Database

Centralization and Multi-Tenant Database Architecture

We designed and built a single, centralized database structure that securely houses data for all client counties and school districts. Using robust row-level security and tenant isolation policies, we ensured that each county can only access its own voter records, signature files, and ballot configurations.

This consolidated database replaced the scattered instances, eliminating data silos and creating a single, reliable source of truth for the entire platform.

What we shipped

  • Designed a multi-tenant database schema with secure row-level access controls.
  • Consolidated dozens of isolated customer databases into a single, unified database system.
  • Enabled aggregated, state-wide data reporting for compliance and auditing.
Modern Application Stack

White-Labeled Angular and .NET Core Platform

We rebuilt the voter management application using a modern tech stack consisting of an Angular 16 frontend and a secure .NET Core API backend. We designed the application to be fully white-labeled, allowing each Board of Elections and School District to customize the portal branding, language, and interface layout to match their official guidelines.

The modern frontend provides an intuitive portal for voters and election officials, delivering responsive layouts that load quickly on any device.

What we shipped

  • Rebuilt the legacy interfaces using a modern, responsive Angular framework.
  • Developed a secure, scalable .NET Core API layer to handle business logic.
  • Implemented white-label capabilities for custom branding and layouts per client.
Containerized Deployments

Containerization and DevOps Automation on Azure

To optimize resource usage and simplify platform management, we containerized the application using Docker and deployed it on Microsoft Azure. By hosting all tenants on a single, containerized application server cluster, we dramatically reduced hosting overhead and simplified deployment pipelines.

We established automated CI/CD pipelines so that any platform updates, security patches, or feature releases are deployed to all tenants simultaneously with zero downtime.

What we shipped

  • Containerized the voter application using Docker to isolate dependencies and simplify hosting.
  • Deployed the unified platform on Azure, optimizing resource utilization.
  • Built automated CI/CD pipelines to deliver platform-wide updates instantly.

The Numbers

Outcomes we can talk about.

The migration to the centralized, containerized Azure architecture successfully resolved the client's operational complexity. By replacing dozens of isolated servers with a single multi-tenant platform, the organization established an easy-to-maintain system where updates, backups, and security patches are applied globally in a single operation. This has significantly reduced overhead for the IT support team.

While historical quantitative cost and performance metrics were not fully logged under the old multi-instance model, the qualitative shift has been transformative. Resource utilization has been optimized, resulting in a far more cost-effective hosting model on Azure. Additionally, county boards and school district staff now benefit from improved visibility, with comprehensive, real-time election tracking and reporting tools at their fingertips.

The platform is now highly scalable and secure. Centralized logging and database monitoring allow the client to audit user access and ensure strict regulatory compliance. The white-labeled Angular interface provides a seamless experience for voters and staff alike, ensuring New York counties can manage elections with maximum precision.

What We Built

Centralized multi-tenant database architectureWhite-labeled Angular frontend portal.NET Core API services layerAzure containerized deployment templatesContinuous monitoring and alert systemAutomated migration scripts for legacy data

What's Next

Implementing automated voter verification pipelines.

With the centralized database and containerized platform stable, the next phase of the roadmap involves developing automated voter registration and verification workflows. We plan to integrate the platform with state DMV databases via secure APIs, enabling automated signature matching and address verification.

Additionally, the client plans to introduce advanced cybersecurity features, including multi-factor authentication (MFA) for poll workers and encrypted digital ledger auditing to further enhance the transparency and security of election operations.

Frequently Asked Questions
About This Project

The questions teams usually ask when they want to run a similar engagement.

We implemented strict multi-tenant isolation at the database layer using row-level security (RLS). Every query executed by the application is scoped to the authenticated tenant's ID, preventing any cross-tenant data access.

The Real Numbers

Need real numbers? Let's talk.

We kept the names off the page. The story is real, the outcomes are real, and we're always happy to walk a serious team through the rest of it.

Start a Conversation