This project is to set up a database on AWS to support a mobile app.
The database should be a classic rational database (i.e. not no SQL). Part of the task is to suggest what database to use.
The database will contain content used in the app, including translations for all text used in the app. The system will be localized to many different languages. At first to English, Simplified Chinese and Traditional Chinese, but over time to other languages, including Arabic.
The app will have a database, where the AWS one is the master. Part of the task is to work with the app developer to figure out how best to synchronize the databases.
The client database will gather some user data that should be copied back to the AWS one.
The first client is an Android app on a customized IOT device. Later we will add mobile apps on Android and iOS, and then a web site, that uses the data as well. We will be using Json here.
The first market is China, though we will initially be hosting on AWS Singapore (probably) and later on AWS Beijing.
A follow up project to this is to develop a web form to update the database. The markup will be provided, but if you are good at this, then you can offer to do that as well.
The database is small to begin with, including only a few thousand rows of code. We will have around 15-20 tables.