Large-scale public records portal
A portal that lets officials search, filter and export a very large table of public records without waiting, with access decided by role and every use logged.
Built the load pipeline, the database, the search backend, the portal and its cloud infrastructure.
Receive the extract
Files are checked for shape and completeness before anything is loaded.
Bulk load
Rows go in through the database’s bulk path, with duplicates removed during the load.
Index
Indexes are built for the lookups and filters the portal offers.
Serve
An API pages results and applies the role check on every request.
Operate
The portal runs on cloud servers with two independent ways to reach them for maintenance.