Defined the job model and implemented idempotent upserts, atomic claims, backoff updates, and a healing query for orphaned reservations.
- What worked
- Schema indexes, upsert with set-on-insert, and atomic status transitions mapped cleanly to queue semantics.