Engineer / Software / Services
Getting off the old system
Data taken out of something ageing and into something supported, with the business still running while it happens.
Improved GIS map performance 10x on Postgre
Improved geographical map application performance by 10x through strategic database transition from MSSQL to PostgreSQL, including the data cutover, optimizing processing and data security.
Improved a GIS map application 10x by migrating MSSQL to PostgreSQL — spatial queries dropped from 2.5s to under 250ms.
Moved every string into a content tree
Moved every user‑facing string out of Python into a content tree of 874 files across three languages, after finding dead translations nobody could see were dead and a check silently grading a third of the achievements.
The prose is now editable without touching code and comparable across languages by counting. The cost is that adding a language is now unambiguous rather than…