Solr Expert Nedeed: Setup + DB Integration + Model + GUI

I need a real and demonstrable Solr Expert for a 3 table mysql search job.

JOBS MUST BE DONE
Setting up sorl in our server and configure it for a 3 table search in one unique result.

The result must be integrated with our frontend jquery autocomplete script, crons should be set up to keep the sorl index updated.

The site is in SPANISH so the Solr should be optimized for the Spanish language search.

SEARCH MODEL

Search in 3 different tables (usernames, post title ,tags) and output in one some result in our frontend jquery autocomplete script.

EXAMPLE
if I search for “house” in the frontend jquery autocomplete, it should return results matching results in 3 different tables.

EXAMPLE RESULTS FOR “house”
post title result: Dr. house is a very interesting
category result: house building
username result: Amy_whinehouse
post title result: The white house is in Washington
post title result: I don

Search All Jobs:

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • $250-$750
  • Start Date
  • 12/23/2011 01:34:53 AM
  • Job Status
  • Job Expired