On May 6, 1987, O'Brien was appointed Auxiliary Bishop of Ottawa and Titular Bishop of Numana by Pope John Paul II.
Pope Benedict XVI, on June 3, 2007, named O'Brien to succeed the late Anthony G. Meagher as Archbishop of Kingston.