I worked with a pilot who had a dui.....he had 300 hrs tt. he accumulated another 3-400 hrs as my copilot then got a job with asa. the conviction was less than 3 years old. its definately not a good thing to have over your head but its not the end of the world either.