alcoholic engineer
Scotty, O'Brien (tng), O'Brien evolved (DS9), Tripp Tucker (he's from the Florida everglades, half the engine problems are because he's rigged the engine to produce dilithium moonshine).
I mean seriously, O'Brien went from standing in a transporter room all day to being a...