If you are into the arts and culture then I would definitely choose the triangle over charlotte, only because that town is all about its sports.

I'm in Cary right now, which is about two minute's drive away from Morrisville (I'm about to go get some sushi in Morrisville after I complete this posting) which is about a 15 minute (no traffic) commute down I40 into downtown Raleigh. You're also not very far from Durham either.

One drawback is that Morrisville is directly across the highway from RDU. You can't escape the planes. Although the airport shuts down at 11pm, it starts up again at like 5am.

Wish I could help you out as far as finding a job, but it looks like technocoy's better connected in your area of expertise. Unless you know something about Oracle or have worked in the Pharma industry, I can't help ya