At least nine people were killed — including the shooting suspect’s own sister — and 27 others were injured