Upwork Test Answers: Get all the correct answers of most recent and possible Upwork Tests A to Z (Updated on Jan, 2016)
Cover Letter Templates: These cover letter samples are not only for Upwork job, but also you will have some idea about your real life job
 
Freelance Profile Overviews: Different Profile samples and overviews of experts, advanced and intermediate level freelancers
For Newbie of Upwork: Upwork Help - How to apply for a job in Upwork with 10 most important articles about Upwork

A to Z View - All Upwork Test Answers

Cover Letter Sample for MySQL Database Optimization Needed

Please Don't Just Copy and Paste: Read the Important Note before preparing a cover letter for the job you are applying

Important Note: Your cover letter depends on the job description of the job you are applying for, this is just a sample, don't just copy and paste them. This is just an example and idea about your cover letter, read this cover letter carefully and make your own one.

Upwork Cover Letter Sample for MySQL Database Optimization Needed:

Hello

Let me help you with this task. I designed, optimized and support databases for such projects like: mailcast system - more than 10mln recipients/100mln sent emails, custom developed stats for more than 500 projects - processes 100000 pages every day.

I know much about optimization. Before doing any optimization need to decide, where is a problem. Performance issues can be:
  - on database side, on database + server/client side (so I can help here);
  - on server, client and network side (I cannot help here) 

If problem related to database then my steps are:
- gather stats when site operates in regular mode. It means that users open the same pages as they usually do. Maybe make sense to write some automated scripts (by JMeter, for example) to emulate user behavior;
- analyze queries;
- possible solutions: 
1) simple one - create missing indexes; 
2) rewrite queries; 
3) move logic into stored procedures; 
4) create indexed views; 
5) work together with a development team if the issue is partially related to the server side - for example, developer runs one query many times; 
6) separate table on static and dynamic data -  static/history data can be processed automatically by schedule; 
7) use shards - complicated part, but also possible.
8) other - can be provide after detailed analyses

My name is Xaiver

I did jobs where other specialist gave up. 

My rate is $25/hr and I can spent 10h/week. 

I need more details about your site to estimate approximate timelines/time. The details I need: programming language, DB version, hosting and the problem description.

Looking forward to hearing from you.

Best wishes, Xaiver

No comments:

Post a Comment