Database Ownership

Millions of records across membership, claims and encounters. Migrations, performance, incident fixes.

Scope

Schema and data migrations on live systems.
Query and index performance.
Audited, single-transaction fixes for incidents, such as rebuilding corrupt insurance-card IDs with their checksum.
Final review of other teams' migrations and app logic.
Caught a sync bug that put claim items under the wrong claims; moved the affected reports to live data.