Wayne Dalphinis was attached to the North East Command Unit when he was caught with half an ecstasy tablet in July.
He resigned in September, but a hearing has found charges of gross misconduct were proven anyway.
He had only joined the police recently and was on his probation at the time.