NPN Transistor Parameter Determination Gain Question
The maximum voltage gain from a single bipolar is VDD /  0.026.

Thus your 9v example has max gain of 9/0.026 or 9 * 39  ~~ 360.

Yet to convert 0.005 volt into 9vpp you need gain of 9/0.005 = 9*200 = 1,800.

Summary: a single bipolar is not the answer.