Prison chief who oversaw botched execution of Christa Pike resigns