Redis is great for some things but is definitely not the right tool here. It's built mainly for serving up small chunks of info (or functionality) very quickly. And it kicks ass at that.

This is a system that probably sees even more writes than reads, and they're batched up mostly at night anyway. The longer term management of that infrastructure is a big part of the pain.