The Cork native worked at some of the biggest yards in British racing and rode winners as a jump jockey in Ireland