Lots of guys out there flying at the majors and regionals with DUIs.
Just don't get another!
How do I know? Worked in flight ops and know about all the guys who can't fly into Canada. (And there's lots) That doesn't account for those who have paid to be rehabilitated by the Canadians or 10 yrs have past and it's forgiven.