A recreational drug user who uses needles to get high.
The phrase is derived from
sharps (a term for used needles and injection gear), and
shooting up (slang for injecting drugs).
Yo is that Dawson over there? Go ask her for some clean gear, she's a sharp shooter too!