GO:0047016:   cholest-5-ene-3-beta,7-alpha-diol 3-beta-dehydrogenase activity
Catalysis of the reaction: NAD+ + 7-alpha-hydroxycholesterol = NADH + H+ + 7-alpha-hydroxycholest-4-en-3-one.