The former Brighton boss has a proven track record in England's second tier and his appointment could reignite Forest's promotion dream