What you really need is someone that has experience doing it, period. This is not something that you can just "wing it".

If you have to do it with no experience, just expect up front that you'll have to re-do things, sometimes the same thing multiple times.

The next most important thing is to separate the logical and physical design phases -- do NOT allow anyone to skip the logical phase and immediately start designing "tables" or "indexes".