I had a couple of them... but they were more than 23 years ago and I know they are much tougher now than they were then.
I've sponsored some alkies that have had DUI's. Most of them had a few of them before I sponsored them. In regards to what is going to happen next, in your case, it would be best for you to speak with an attorney. They will know the laws in your area and they will know the attitudes of the judges there.
Where I'm living now, first offense, it's usually a fine of around a thousand dollars and probation, and depending on the BAC, Blood Alcohol Content level, if it's very much over the limit, they may or may not have to do a few days in jail, sometimes, they can do it on weekends, and/or they can do community service, and their driving privileges are restricted. They may include the "drunk driving classes" (expensive) and may require a certain number of AA meetings to attend, where they get court cards signed.
Again, when you're dealing with the law -- you want to talk to lawyers! If you can't afford one, try calling the Public Defender's Office and see if they can help or at least answer your questions.
Second & third offenses... are much more punishing. In some areas, a second or third offense gets treated as a felony, jail sentences get longer, fines get higher, driving suspensions and revocations get longer, cars can be taken away, driver's license can get taken away permanently, and/or they can make you install a blow-device that monitors your blood alcohol level to be able to start your car (these are very expensive).
4th, 5th, 6th, 7th offenses??? Yep. When alcoholism kicks in... alcoholics will find a way to get those too! And, they do!
Once upon a time, I could go with the sponsee to court, talk to the prosecutor and judge, if the alkie was serious about recovery -- and it would seem to help. Now, they go by strict sentencing guidelines and it very seldom seems to do any good.
Again, speak with a lawyer. That's the best suggestion I can make.
Regardless of what you do, you'll have to face it. Some slick lawyers can get people off... and often, those people just go back to drinking and driving after leaving the court house.
In regards to employment... that's unique, too. Some people lose their job and some don't. The one's that do get fired and have to look for another job -- the driving offense shows up on their record, most often, for the rest of their life... And, it can also prevent you from getting employed in certain occupations.
I've known many alkies that have came to AA, got sober, got serious about their sobriety and recovery -- and totally re-created their lives for the better. But, they've still had to face their problems and pay the piper for their dances with trouble. We all have to do that -- if we want to stay sober.