A Tamron 90mm or a sigma 100mm are both excelent lenses and very sharp.
The Nikon 105mm is also great, but possibly above budget.
Sigma also have a 150mm which gets very favourable reviews.
Cant rememeber if the D5000 has a focus motor or not, but most macro is manual focus anyway, so shouldnt matter much.