Althea Room LLC
Backend Software Engineer (Contributor)
Oct 2026 – now
Remote
Backend APIs, a production database migration, security reviews and CI/CD across Althea's wellbeing apps: Life, Focus and Mind.
- Built and extended REST APIs for Althea's wellbeing apps, including the Mind backend (8 endpoints, 6 tables) with shared authentication integrated from the Core service.
- Migrated the Focus PostgreSQL database from a managed cluster to a self-hosted VPS, verified 12/12 tables, and prepared the cutover plans for Core and Focus.
- Ran security reviews across 5 backend repositories, patching 13 issues, and fixed auth and password-reset bugs found in beta testing.
- Set up CI/CD with GitHub Actions: tests, dependency audit, Sonar, and a release pipeline to Google Play, for both backend and mobile repos.
- buildqueued
- testsqueued
- dependency auditqueued
- sonarqueued
- security scanqueued
The scan hasn’t run yet. Press Run.
- internal
- closed beta
- production · 10% rollout
$ waiting for a run
| table | rows old → new | checksum | |
|---|---|---|---|
| users | · | ||
| sessions | · | ||
| focus_blocks | · | ||
| streaks | · | ||
| goals | · | ||
| reminders | · | ||
| devices | · | ||
| subscriptions | · | ||
| tags | · | ||
| block_tags | · | ||
| settings | · | ||
| audit_log | · |
- Announce a maintenance window
- Freeze writes (app in read-only mode)
- pg_dump → pg_restore on the VPS
- Verify row counts + checksums, 12/12
- Switch DATABASE_URL, smoke test
- Keep the old cluster read-only for rollback
$ focus-db migration · managed cluster → vps-01