A longtime and beloved security guard is dead after being shot while doing his job Wednesday evening at a Connie’s Seafood restaurant on Houston’s East Side.