Michael McArdle, the Scottish FA's head of elite women's football and former interim head coach of Scotland, is appointed Northern Ireland manager.