You basically need to set the record level lower on the camera and boost the mic input.
I don't know about the Rode Stereo Videomic, but the Rode Videomic Pro has this feature built in to boost the output.
This hiss is basically down to the signal to noise ratio. If you record at a high level on the camera but have a low audio input signal, there will be more noise relative to actual desired sound. Boosting the mic's output level, and recording at a lower setting on the camera (which will give you the same ultimate volume) will increase the signal to noise ratio and help eliminate the hiss (which you can further tweak in post - to a degree).
But, most DSLRs only record 44Khz 16Bit sound, so as soon as you try to do anything to it in post, it degrades very very quickly. I think there are a couple out there that record 48Khz, but as it's still 16Bit it degrades quickly if you try to do anything to it in post.
I'd consider looking into an external recorder like the Zoom H4n or Tascam DR-100. I use the DR-100 myself, which has 48v phantom power to power condenser mics through XLR inputs, recording at 96Khz 24Bit audio, then you can take the line out from the recorder through an appropriate cable to the mic input on the camera for syncing up in post.
In-camera audio will never be perfect, no matter what you do (although it can get "good enough", depending on your needs). It was just never designed as a recording device for master quality audio really.