A friend of mine was convicted of drink driving, the airline did not find out. He continued to fly, and drink! He fell asleep at the holding point and the F.O. could not wake him and so returned the aircraft to the ramp. He was sacked.
With no airline job he turned to light aircraft charter. Flying fish in from Scandinavia. Customs examined the fish one day and found it stuffed with drugs. He went to prison.
On his release from prison he continued to drink. Well now he is dead from liver damage. A great guy, but I nor anyone I know would trust a pilot with a drink drive conviction.