Your Supe sounds like a real gem (NOT)! My guess is that you're not the only one who has had difficulty working with him and perhaps someone else has already gone to HR. I would start looking for a job while you are still employed. Then, in the meantime...start documenting all incidents that you have had with him. When you announce to HR that you are resigning, let them know about every incident that you have recorded about him. If he hasn't already been counseled about his attitude, at least it will be documented and put on his file.
Congrats on being sober over 8 months! That's a great accomplishment...don't let an idiot upset you to the point of wanting to drink. He's not worth the energy.
Make it a great weekend!