Rory Gallagher ratified as new Derry manager