People love casting stones when they likely have taken the wheel at least once when they were "ok to drive." Don't get me wrong, I'm not letting anyone off the hook. Fact is, everyone makes mistakes, but DUI is a big'un. If its past lawyer'ing up and fighting it then you need to find a flight school, corporate or 135 gig. Getting into 121 is gonna be very tough. Got a buddy with a full-on DUI that flew in Saipan VFR 135, then went to a small corporate gig in the midwest, then twin-cessna's on Cape Cod, and now scheduled 135 in the midwest. Getting work isn't impossible, and getting into 121 isn't impossible, but your buddy may have to accept an alternative career path. A clean record post-DUI and a record of doing what you can to continue flying will make getting hired down the road easier (not to mention that the word of previous employers can carry a lot of weight).
**I know I said "you" a lot, but I meant your buddy...