Reliability

A practical guide to SQL isolation levels: Read Committed, Repeatable Read, Serializable, database-specific behavior, and locking trade-offs.

How to implement the transactional outbox pattern for reliable event publishing: schema design, relay claiming, retries, duplicates, ordering, and CDC.

How to run background jobs safely in production with replay-safe handlers, bounded retries, dead-letter triage, visibility timeouts, and queue dashboards.

A practical rollout plan for safe database migrations using expand-and-contract, phased constraints, resumable backfills, and rollback planning.

A practical guide to API integration testing: real request boundaries, auth, persistence checks, failure cases, idempotency, and response contracts.