I have a database of several hundred thousand profiles that include names, careers info, and contact info. I was thinking of creating a teaser webpage for each profile that could be indexed by search engines. But I am not sure if this is the best way. Thoughts?
Search engines will only index that many pages from your site if your site has very high reputation. Facebook or LinkedIn could probably get that many pages indexed, but your site won't be able to.
Google doesn't like sites that publish tons of pages with very little content on each. If you publish that many pages and then users don't find them useful, you will likely find your website punished under Google's Panda algorithm.
I would recommend testing the waters by testing out 1000 or 10,000 of the highest quality pages. Find the ones where you have the most data and publish those first. If you find those get search engine traffic and can satisfy the searchers that land on them, then expand from there.
I don't really understand what you mean by teaser webpage. Are you actually going to show the profile data on the teaser page?
IF you mean the profile info is used as a teaser to get you to enter into your site. I'd probably start that operation by collecting a bunch of profiles into some sort of useful classification and showing larger lists of the database results. Hundreds of thousands of think little profile pages that do not lead to a directly relevant site are gonna get bounced, with negative ramifications for your whole site.