Used to be no deer up near Huntsville many years ago. The population up north has steadily increased over the years, though, and some very nice deer are taken up around Huntsville now.
As joedav31 says, the black belt is very good. Anywhere around Greensboro, Eutaw, etc. is prime country. Hale and Greene county have lots of river bottom land and the hunting is great.
While there are some opportunities to hunt public land, the competition is heavy. Most places consist of hunting "clubs" that lease private land or timber company land. Long-term is common there, and many of the better clubs are expensive and you practically have to be born into them to get in.
Lots of good hunting and good folks, word of mouth is your best bet. Let your coworkers know you are a responsible hunter looking for a slot and it should work out.