Website Overhaul (Smarty, PHP, MySQL)

We are looking for a freelancer to help us overhaul, modernise and improve a website ([login to view URL]) We use it to capture freelance suppliers info - i.e. translators, interpreters, etc. The site needs some work done to it in the following areas: 1) Look - the look is dated and needs modernising. This will include full incorporation of Social Media icons linking to FB, Twitter, LinkedIn, etc. 2) CMS - at the moment there is no CMS and we need one moving forward that is quick and easy to use. 3) Bug Fixing - there are a number of small bugs that need fixing in the coding, i.e. the backend which captures information. Changes vary from needing to add in fields to making certain fields mandatory. The flow of the process also needs re-thinking and re-doing to make it a lot more painless than it is now. 4) Once completed the website will need new "Sign-up Guide" videos (as shown on the home page). It would be ideal if this could also be done (minimum one for translators and one for interpreters). 5) Migrate the database interface to the mysqli_* interface (instead of the currently used mysql_* interface). You will need... • Good graphic design skills. • Knowledge of Smarty template engine and PHP. • MySQL is the database engine used by the website.