At the heart of a professional software system resides a database which is modeled for best performance, data integrity and scalability.
Most developers neglect to spend adequate time on database design/modeling, with the attitude that the database is only used as a storage location.
Poor database design or choice of database engine can lead to the following: Loss of data, data integrity violations or even a very slow database.
A badly designed database will eventually effect the front-end that utilizes it i.e. your website. This can all be avoided by properly planning the database model based on the technical specification, and following good database design practices in terms of normalization, indexes etc.
It becomes significantly difficult to correct a poorly designed database after it has gone into production and started collecting data - its a good idea to get it right the first time!
I’ve been working extensively with the MySQL database for the last few years and have modeled relational databases with up to 100 tables, 100% normalized. I also have good experience with the EAV model as used by Magento commerce, 200+ tables. Additionally I also have adequate knowledge of MS SQL Server and SQLite to accomplish most things, although MySQL remains my favorite.
Some database services I offer:
- Custom Database design.
- Altering of existing database.
- Data mining.
- Database optimization and profiling



