Seeking MySQL DBA to optimize database performance
3645
$$
- Posted:
- Proposals: 3
- Remote
- #456920
- Archived
Description
Experience Level: Intermediate
General information for the business: We are an Internet creative services firm
Database management system (DBMS): MySQL
Description of requirements/functionality: For the purposes of optimizing our existing CMS installation with large tables, Satdaya Studios is seeking a qualified MySQL DBA. We have an immediate need for a contractor to optimize the database serving the backend for an ExpressionEngine instance, populated with millions of rows of data.
Project Details:
ExpressionEngine stores data from several different “channels” into two one-to-one tables, sharing a common entry_id column as a joining key. Our site (which is still in development) contains several of these channels, each with hundreds of thousands of rows, if not more so (totaling millions of rows in these tables). Currently, doing a select query on just one of these tables takes an inordinate amount of time, let alone when joining the two tables or joining with other tables. We need to optimize the data in every way possible to make the site usable, from adding indexes to partitioning data to any other method available.
We actually have 3 projects of this nature, with one being the most immediate and largest-scale. If all goes well, we can bring you in on the other two.
Requirements:
Must:
* Be certified MySQL DBA.
* Be skilled in analyzing data structures (schemas)/understanding complex joins
* Be skilled in optimizing large tables and joins between large tables
* Understand MySQL explain syntax, other MySQL analysis tools, how to interpret results and implement optimizations such as indexes, etc.
* Have deep knowledge of various ways MySQL can partition data, how to create/manage these partitions, when to use them for maximal performance
* Be able to operate in UNIX environment, i.e. shell and MySQL command line tools
* Create optimizations that use current queries that are in existing third-party software (i.e. we cannot rewrite queries/code)
* Be a team player and able to effectively communicate and discuss solutions before implementing
* Work within strict NDA, to be signed before work begins
Please submit your bid with the following.
Time and Cost Estimate for:
1. Analysis & Diagnosis—Log in and look around under the hood, performing select/explain queries, reviewing logs/debug files, etc. Re-review step two below and update estimate.
2. Problem Solving—Do the fixes once approved. We understand that this is going to be a rough estimate (best guess) until step #1 is completed.
3. Documentation—The amount of time it will take for you to clearly document the structure for yourself or any future DBAs or developers to reference as needed to maintain optimizations.
Answer:
When will you be able to start & when is the best/worst case deadline you can meet?
What will you need from us and how can we help get the project completed sooner (we have staff available to test, do any repetitive tasks, etc.)?
What are your usual/preferred communication methods, work methodology, and typical hours + time zone?
Specific technologies required: MySQL, Linux
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/functionality: For the purposes of optimizing our existing CMS installation with large tables, Satdaya Studios is seeking a qualified MySQL DBA. We have an immediate need for a contractor to optimize the database serving the backend for an ExpressionEngine instance, populated with millions of rows of data.
Project Details:
ExpressionEngine stores data from several different “channels” into two one-to-one tables, sharing a common entry_id column as a joining key. Our site (which is still in development) contains several of these channels, each with hundreds of thousands of rows, if not more so (totaling millions of rows in these tables). Currently, doing a select query on just one of these tables takes an inordinate amount of time, let alone when joining the two tables or joining with other tables. We need to optimize the data in every way possible to make the site usable, from adding indexes to partitioning data to any other method available.
We actually have 3 projects of this nature, with one being the most immediate and largest-scale. If all goes well, we can bring you in on the other two.
Requirements:
Must:
* Be certified MySQL DBA.
* Be skilled in analyzing data structures (schemas)/understanding complex joins
* Be skilled in optimizing large tables and joins between large tables
* Understand MySQL explain syntax, other MySQL analysis tools, how to interpret results and implement optimizations such as indexes, etc.
* Have deep knowledge of various ways MySQL can partition data, how to create/manage these partitions, when to use them for maximal performance
* Be able to operate in UNIX environment, i.e. shell and MySQL command line tools
* Create optimizations that use current queries that are in existing third-party software (i.e. we cannot rewrite queries/code)
* Be a team player and able to effectively communicate and discuss solutions before implementing
* Work within strict NDA, to be signed before work begins
Please submit your bid with the following.
Time and Cost Estimate for:
1. Analysis & Diagnosis—Log in and look around under the hood, performing select/explain queries, reviewing logs/debug files, etc. Re-review step two below and update estimate.
2. Problem Solving—Do the fixes once approved. We understand that this is going to be a rough estimate (best guess) until step #1 is completed.
3. Documentation—The amount of time it will take for you to clearly document the structure for yourself or any future DBAs or developers to reference as needed to maintain optimizations.
Answer:
When will you be able to start & when is the best/worst case deadline you can meet?
What will you need from us and how can we help get the project completed sooner (we have staff available to test, do any repetitive tasks, etc.)?
What are your usual/preferred communication methods, work methodology, and typical hours + time zone?
Specific technologies required: MySQL, Linux
Extra notes:
Laurence W.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
30 May 2014
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies