[JOBS]: Introduce a transactional outbox and durable background worker

[grantfox-oss]

Context

Emails, notifications, audit records, storage cleanup, and blockchain reconciliation are side effects of database changes. Executing them inline couples request success to external services; executing them after commit without durable coordination can lose work.

Scope

• Add an outbox model written in the same transaction as domain changes.
• Build a worker with atomic claiming, visibility timeout/lease, heartbeat, bounded retries, and dead-letter handling.
• Define versioned event payloads and idempotent consumers.
• Implement initial consumers for transactional email and one operational side effect.
• Add replay, inspection, and redrive tooling with audit records.
• Define retention and safe payload redaction.

Acceptance criteria

• A committed domain change always leaves durable side-effect work.
• Rolling back the domain transaction creates no outbox event.
• Worker crashes and duplicate delivery do not duplicate logical side effects.
• Poison messages stop retrying and remain inspectable/redrivable.
• Queue depth, oldest age, attempts, and failures are observable.
• Integration tests exercise concurrent workers and crash recovery.

Relevant areas

Prisma models, payout/application/support mutations, email-service.ts, future notifications and escrow reconciliation.

[ebubeb683-ship-it]

Please assign this issue to me. i checked it out and im confident i will solve it
my eta is 4 hours

[victorocheje]

I would like to work on issue

[grantfox-oss]

🦊 GrantFox — @victorocheje has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #96)
2. Your PR will be reviewed by the Eduvault-stellar maintainers

Good luck! Track your progress on GrantFox.