Gauge theory description of D-brane black holes: Emergence of the effective SCFT and Hawking radiation