Dyfed-Powys Police has dismissed former Superintendent Gary Davies after a misconduct hearing found he engaged in inappropriate behaviour towards female colleagues over several years.