Create a Wordpress Template - optimize Sahifa

I need to re-engineer a WP website, have multiple challenges: 1) out dated theme running on the site, re-work the theme 2) DB is over sized ~ 1.5 GB, we have huge number of posts going in, split DB implementation 3) slow query log fixing 3) Archiving strategy to sustain the growing DB size 4) Hosting suggestions and architecture to scale from .24 million views to 3 million views a month 5) Page load time optimization 6) Backup & monitoring setup let me know if you want to take the discussion ahead.