Need a top notch DBA to help us re-design an existing database to make it more flexible and scalable. Database is in MySQL. Would prefer someone with experience designing EAV (entity-attribute-value) model databases.
the application is a web-based project management tool geared towards the architecture/construction business. there are a lot of details that go into each project. right now, the database is designed where (for example) the project table has hundreds of columns that are strictly defined (like sitevisit1,sitevisit2,sitevisit3, etc)
i want to move it to an EAV model (entity attribute value) so that the users can customize which fields they need for their individual projects
users need to be able to add and remove fields, etc.
right now there are about 200 users, this will grow to 2,000 by next year.
think along the lines of basecamp dot com but specific to construction/architecture fields.