Database Design &amp Build

A Web developer with over 13 year’s experience designing and building applications that utilise database technologies including MySQL and MSSQL.

It is hard to build a web application without utilising a data store. Right from the early days of developing web applications, I have worked with database technologies, including MySQL an MSSQL. As a PHP and Java developer, much of the time I am working with MySQL, but my recent involvement with projects using ASP.NET Core see me working more with MSSQL.

Some say designing a database is easy, but they fail to understand the skills and knowledge required to make a database that is efficient, well structured and quickly expanded. Thankfully I have many years of experience working on projects of varying complexities, some requiring simple databases structures and queries, while others required more complex database structures with many relationships between tables, and complex queries which generate results from multiple tables while requiring to keep response times to a minimum. Sometimes there is a delicate balance to be met.

Once a database has been designed and developed, and it is being used in a production environment, it needs to be regularly backed up, in some cases, you may need to implement database replication where an application receives much traffic, knowing how to do this reliably requires experience. I’ve worked on many projects where new functionality needs to be added to an existing product without breaking backwards compatibility with older versions, the experience I have gathered over many years of web development allows me to identify the risks and implement solutions.

I have worked with many tools and services, including but not limited to MySQL command-line tools, MySQL Workbench, Rackspace Cloud and AWS RDS instances with backups and replication.

Signup to the Newsletter

Get useful tips on web application development and software engineering.