Worked on improving concurrency stability in the Shopify/rails repository by addressing issues with Active Storage blob analysis. Focused on backend development using Ruby on Rails and database management, the work involved preventing unnecessary lock_version increments during blob analysis and touch operations. By implementing ActiveRecord::Locking::Optimistic.preserve_lock_version_on_touch and refining the blob touch cascade to respect transaction commit intent, the changes reduced spurious stale-object errors during concurrent edits. Adjustments to the AnalyzeJob ensured only metadata was touched, minimizing unintended cascade effects. This targeted bug fix enhanced data integrity and reliability for concurrent editing scenarios, resolving a longstanding issue in the codebase.