In my civilian job if I got a DUI I would lose my security clearance, which I would be fire for.
Lawyers are disbarred, Doctors lose their license to practice, Pilots lose their certificates.
They all get fired for it.
I suppose a bagger at Walmart might not get fired for being a meth head...