Secret Service confirms the sniper was on the "elevated position" that was an obvious sniper's nest that they completely ignored