I am looking for a database expert who will work to optimize my website database, in order to increase efficiency and performance. My website is hosted at a VPS, its size is around 845 MB, and the required tasks are:
1) Review the database design and structure, enhance its design and structure (Normalization, fine-tune MySQL configuration, caching, buffering, access security, and also to revise table structures, indexes and optimize them as well).
2) Monitor MySQL processes, logs and identify the queries that need to be optimized or simplified.
3) Ensure that MySQL settings are at optimal configuration, and identify potential server and database problems that could decrease the performance.
4) Create cron jobs for mysql backup operation and preventive maintenance, and make synchronized backup to another server.
MySQL Database Administration, Linux, PHP, System Admin