Suljettu

MySQL Database Design, Performance and Optimization Consultant for SaaS application

Currently we are in development of a SaaS application and we need a MySQL database expert.

The person that I am looking for should live and breathe database design, performance and optimization.

Your task will be to work periodically as a consultant with the development team who are currently building the application. We are at the development stage at the moment so designing for database performance is absolutely crucial. You will need to give your expert opinion regarding database design and optimisation.

I need someone with a thorough in depth knowledge of optimizing MySQL databases for performance using an Enterprise level approach with the following in mind:

- Design for performance

o Database admin configuration for performance

o Table Design (Normalisation, Cardinality, Choice of data types)

o Data storage (Disk foot printing)

o Correct indexing

o Partitioning

o Query Caching etc…

- A knowledge of multi-tenant architectures

- Storing user defined values

- Alternatives to EAV to store user defined values

Additional

• Ability to communicate in clear English is required.

• Experience in SaaS applications is highly desirable.

• Solid PHP experience is highly desirable.

When applying:

- Please state your experience clearly

- Please answer the screening questions below

Initial questions

For me to consider you, please answer the following two questions:

1. If you were to design a SaaS application on a LAMP stack, which multi-tenant architecture would you use and why?

2. Assuming your multi-tenant architecture was based on a single database design and you had a TASK table which stores tasks (you’ll need to think for yourself about what a ‘task’ is), how would you store the data with performance in mind? Every tenant might end up having between 5000-25000 tasks... Would this change your approach?

Taidot: Big Data, Tietokannan hallinto, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: team approach database, stage stores, saas expert, mysql query optimization software, mysql database software, mysql database application, how to consultant, how design live, be a consultant, alternatives to up work, eav, what is user experience design, what is lamp stack, lamp software, how to design a database, designing a database, database caching, need a consultant, how to be a consultant, design and printing, saas application, Query optimization, php software architecture mysql, php consultant, performance optimisation

About the Employer:
( 6 reviews ) Sydney, Australia

Projektin tunnus: #4277605

8 freelanceria on tarjonnut keskimäärin 23 $/tunti tähän työhön

cupertinovw

Please see PMB

$25 USD / tunti
(56 arvostelua)
8.2
qualifiedcoders

Hi We have read your [url removed, login to view] are Database experts and have developed some big and complex applications using various databases and have strong expertise in procedures,functions,triggers and other db objects. Lisää

$25 USD / tunti
(18 arvostelua)
6.8
meet2amitvw

Hello Thanks for the sharing requirement. I went through your description and ready to work with you. You will work directly with one person and that's me. No mediators. No managers. No subcontractors. Find yo Lisää

$25 USD / tunti
(45 arvostelua)
5.5
truongngocthanh

Hello, I can do this job. Please check your PM for detail. Thank you.

$12 USD / tunti
(11 arvostelua)
4.3
garhwalsatyapal

ready to work with you

$10 USD / tunti
(10 arvostelua)
3.7
getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Lisää

$25 USD / tunti
(5 arvostelua)
1.3
nihil75

An experienced system architect with vast experience in database design and optimization- Starting with server config, data structure, indexing and even query analysis. I have a passion for benchmarking, its my ho Lisää

$50 USD / tunti
(0 arvostelua)
0.0
bvtgroups

We have PMP certified lead developers who will be guiding you.

$15 USD / tunti
(0 arvostelua)
0.0