The former Aberdeen midfielder has been appointed manager of a Scottish Championship team.