A stupid, incompetent, or foolish person...
(It's worth noting that doofus is a relatively recent addition to dictionaries: Merriam-Webster's collegiate dictionary has it, but not the old Webster 1913 standby.)
Regading Etymology, the American Heritage Dictionary points to the Scottish word "doof", which means exactly the same thing. The German word "dof", also meaning fool, is suggested by others.