SEO EXPERT needed to fix my meesy website

Closed - This job posting has been filled and work has been completed.

Job Description

The job is bit complicated, my domain is already indexed in google and now I want to upload my website all over again with a new database which means that all my urls on google are now 404 or inconsistent with their pages.
So I need someone to fix this mess and to boost up my ranking for various keywords to the top 3 serp (US / UK based), only serious white hat seo experts are needed for a long term work.