This story can consist multiple tasks to for each dual write operation

Update the transaction isolation level from Read Committed to Serializable for dual writes operations to ensure data consistency and prevent issues during concurrent operations. 

A coffee and code session to explain it and see if we want to go this route