Developing Custom Prometheus Exporters for Legacy Microservices

Act as a Software Architect. Architect and design a highly optimized, custom Prometheus exporter written strictly in [LANGUAGE] (e.g., Golang or Python). The exporter's sole function is to continuously fetch, translate, and expose raw state metrics originating from a legacy [DATA_SOURCE] (e.g., an antiquated SOAP API or a proprietary Oracle DB). The binary must flawlessly handle an aggressive [SCRAPE_INTERVAL] (e.g., 10 seconds) without causing connection pool exhaustion. Meticulously define the precise Prometheus metric types (Gauges for queues, Counters for absolute totals, Histograms for latency) mapped to the data source. Provide the exact boilerplate code for the `Collector` interface implementation, strictly enforcing Prometheus best practices regarding naming conventions and HELP strings.