Dynamic SQL, ASP, AJAX, JS

We're developed an online system for cataloging and searching over 2 million industrial components. Frontend/static html/css is built, we would like to partner with a database architect to help build/optimize necessary tables and indices to allow 10-20K users access to this 2 million row dataset. Exiting SQL table structure exists, but requires optimization and indexing. Feature List includes: (1) User Management (with subscription billing, administrator usge tracking by page) (2) Customized Items, saved and searchable per User (3) Adding items into Item lists (again, per user) Windows servers, IIS, SQL, asp, asp .net. A bonus would be experience with Ruby on Rails, as a major element of our value-add requires some robust ajax implimentation. Tour of static HTML and required feature list available upon request