The question is simply "What approach should I take to find the right technology partner?"
Some background for context: I am currently employed full time in my industry and have been for over a decade. I have a compelling business idea which requires advanced skills for database and web application programming. Although I have some basic background in understanding modern web technologies, I clearly need a strong engineer / CTO / programmer partner to work with (or for) me on this project.
Once this startup is launched, I plan on departing from my full time job and spending my time on this new company.
What strategy or approach should I use in sourcing the right partner? Are there organizations or communities where I could find strong technology talent on the flip-side of my scenario?
There are really three ways
You'll probably want to tap your network first, before partnering with a complete stranger. It tends to work out better.
Otherwise invest some time and get to know the local startup and tech scene.
Somebody asked a similar question a couple of days ago and it has a bunch of thoughtful answers.
You sound like my opposite. I am a developer bootstrapping a startup and building the platform myself, but don't have a co-founder to help form relationships with first customers. Since I would never work for another startup for free or for equity (because I have enough failed startups to know this is too risky for my particular personality and balance sheet). My solution has been, honestly, to learn the business area myself, to force myself to connect with potential customers and partners, attend professional development events, and practice my pitch.
It could be that I'm at an advantage somehow because I can do the kind of work that makes the site happen despite customers, but it's probably that our roles are equally needed in a new venture.
One of the users on this site, Alain Reynaud (http://answers.onstartups.com/users/502/alain-raynaud ) is the founder of http://fairsoftware.net, you should check that out. I haven't used it personally but it sounds like a match for what you're looking for.
Try and find an engineer with experience in similar industries as the one you are targeting with experience in a variety of technologies (a jack of all trades) and convince him that your idea is worth investing time and effort in.
A good site to start networking with people from other backgrounds is LinkedIn.