Define assignment states and their required database fields
Rows marked assigned sometimes have no assignee or lease deadline, making recovery ambiguous.
Estimated field mix
- Database engineering80%
- Backend20%
Preparing the next view without exposing private workflow data.
Design a system. Diagnose tail latency. Ship a migration. Recover a failed rollout. Pick a focused ticket or follow a project through its delivery phases.
1380 tickets · 138 projects · 26 engineering fields · Four difficulty levels
Field counts and the engineering field filter use each project's primary field. Estimated ticket labels can span multiple fields.
1380 matching tickets · Page 36 of 115
Rows marked assigned sometimes have no assignee or lease deadline, making recovery ambiguous.
Estimated field mix
Jobs created at the same instant appear in a different order on each poll, making starvation difficult to reproduce.
Estimated field mix
The job list is scoped in the controller, but the claim repository accepts a globally valid job ID.
Estimated field mix
Two polling clients select the same pending job before either writes its assignment.
Estimated field mix
A disconnected reviewer reconnects after its job was reassigned and still holds a token that appears current.
Estimated field mix
A late heartbeat runs after completion and changes the row back into an apparently active assignment.
Estimated field mix
A result is visible while its job remains assigned because completion and result linking commit separately.
Estimated field mix
A sweep selects expired jobs, then reclaims one that was renewed before its update executes.
Estimated field mix
Operators need to choose a polling interval and concurrency limit based on observed contention in the local prototype.
Estimated field mix
After an outage, operators need to resume assignments without redoing completed work or accepting stale reviewer results.
Estimated field mix
A test restore contains tables but cannot start the application because expected roles and extensions are absent.
Estimated field mix
Operators find three similarly named dump files and cannot tell which migration version or time each represents.
Estimated field mix
138 matching projects · Page 2 of 12
Repair public-service booking across keyboard use, zoom, timeouts, and changing availability.
Improve navigation, text adaptation, annotations, and revision recovery in an internal document reader.
Build a bounded live coordination room with ordered events, reconnect recovery, and clear authority.
Reconcile synthetic vehicle locations, assignment changes, and stream interruptions in an operations dashboard.
Build a local release assistant that prepares reviewable plans and survives interrupted release steps.
Shorten a local monorepo check loop while retaining correctness when inputs, dependencies, or tools change.
Build a deterministic checkout regression suite around pricing, accessibility, payment failures, and isolated test data.
Create a local webhook laboratory that reproduces duplicates, disorder, signature failures, and interrupted delivery.
Build a retrieval workflow that respects document access, cites exact revisions, and declines unsupported answers.
Build a routing assistant that suggests queues, validates model output, and preserves accountable human corrections.
Build a vendor inventory connector with stable identity mapping, resumable ingestion, reconciliation, and tenant-safe operations.
Build a calendar booking workflow with time-zone rules, conflict handling, idempotent provider calls, and safe reconnect behavior.
Practice scoped changes, keep a portable implementation and verification record, and learn to explain operational tradeoffs. Choose a ticket whose prerequisites you can provide.
Use realistic work to structure onboarding, internal practice, and conversations about engineering decisions. Each project names the delivery benefit. Agree scope and compensation before requesting company-specific work.
CSV contains one row per ticket. Map fields and issue types in your tracker; project grouping and dependency keys are descriptive. JSON preserves the complete project structure. These downloads do not synchronize with Jira.