Keith Rogers, Rocky Mount City Manager