Well, you have covered the major hurdle for moving to Augusta; you have a job and seems the finances to go along with it. You will be happy here!
My suggestion is to find a realtor and communicate your desires to him/her. I have always been an advocate of neighborhoods in the proximity of Patriots Park in Columbia County. This is due to the fact that you can hit any store/restaurant for any need within 10 mins or less; Wal-Mart, Target etc. It is also close to Clark Hill (Strom Thurmond Lake); a good picnic/camp site. Again, this depends on your likes/dislikes.
I don't know much about SC neighborhoods so I can't comment.
I like Hephbizah in Richmond County but when you get into the nicer areas, it also means that you are further away from the everyday conveniences.
Your thread is new. Mine is just a single opinion. There are other folks on this site that will be able to provide you with a better insight to the area.
I am not an advocate of any particular real estate site but the following was pulled from Meybohm. If you hit their site you can also see SC neighborhoods.
Georgia Neighborhoods
Representing some of Augusta’s finest new home communities. Click on any of the our new homes communities to view its location and available inventory of new homes.
Ansley Place (broken link)
ArcadiaAshbrookeBerkley Hills (broken link)
BrandimereCornerstone Creek (broken link)
Creek Farms (broken link)
Cross Creek Estates (broken link)
ElderberryGrove Landing (broken link)
Hardy Station (broken link)
Heathers Glenn (broken link)
High Meadows (broken link)
Jones Creek (broken link)
Jones Creek Plantation (broken link)
Knob Hill (broken link)
Magnolia Villas (broken link)
Mayo Townhomes (broken link)
Mill Branch (broken link)
New Hope Estates (broken link)
NorthlakeOakridge Plantation (broken link)
Pamir Place (broken link)
Pepper Hill (broken link)
Reynolds Pond (broken link)
Rhodes Farm (broken link)
Riverwood Plantation (broken link)
Sumter Landing (broken link)
The Brownstones at Rae’s Creek (broken link)
The Cottages @ West Lake (broken link)
The Enclave on James Brown (broken link)
The Highlands @ Ivy Falls (broken link)
The Lakes at Spirit Creek (broken link)
The Orchard (broken link)
The Preserve @ Stevens Creek (broken link)
The White’s Building (broken link)
Walker Hill (broken link)
Walton Acres (broken link)