Left-leaning President Dilma Rousseff has been re-elected in the tightest race Brazil has seen since its return to democracy 30 years ago.