DPD officer resigns after caught high on job