To get the Super Sniper Rifle in Terraria, you'll need to defeat the Skeleton King boss. Once you've done that, the rifle will be available for purchase from the Arms Dealer NPC.