Warehousing solution, Australian construction-industry client

The promotion to Senior Software Engineer landed in the middle of this warehousing solution for an Australian construction-industry client. The distinctive technical problem here was offline-first sync: field applications needed to keep working through intermittent connectivity, so I designed an offline-first database-syncing solution combining SymmetricDS for replication with Debezium and Kafka for change-data-capture. Device-side messaging ran over MQTT through a Mosquitto broker.

This exposed a RESTful backend and ran on Azure, the one project in my Zone24x7 stretch that wasn't AWS-hosted, secured with OAuth2 on top of a Spring Boot/Hibernate/PostgreSQL backend behind NGINX.

I introduced Clean Architecture a second time here, this time invited rather than unofficial, and automated the PowerShell setup scripts for every application component so a new environment configured itself instead of taking a day of manual setup.