I am looking for a very good MySQL optimizimer and developer to biuld a fairly complicated user ranking and social networking system.
Some basic elements of the work needed are:
Users can join groups. And invite their friends to join that group. At certain member confirmed invites, users go up a rank. After a certain rank, they are able to create their own group. If they do not wish to they can stay in that group and continue to get promoted up levels by voting of users of levels above them.
As owners of the group, they are able to see all stats of everyone in their group below their control.
There is the usual signup, add profile photos, create a full profile, message everyone in their groups etc,e tc for users.
Will need full admin to control all users, groups.
We will need owners of groups, or high level users to be able to create chatrooms to recruit for new users or speak to their current users in their group.
There is many other elements that will need to be added after the basic site is working, so the database needs to be designed in such a fashion as to allow very flexible enhancements down the road.
Although this is not a big project to start it could easily turn out to be a lot of additional work (paid extra) after the basics are in place. So for the right person, this could mean lots of on going work.
PLEASE ONLY VERY EXPERIENCED DATABASE OPTIMIZERS AND DESIGNERS APPLY.