The correct sentence is "Does he sing well?"
"Sing" is a verb, and "well" is an adverb modifying verbs. "Good" is an adjective and can only modify nouns, so it cannot modify "sing."