Please read the job description carefully, particularly the Google Doc with the link. All the information is there
[login to view URL]
Our main transactional data will be on CockroachDB, and we will save the compressed JSON on Couchbase NoSQL. Couchbase will have almost as many writes as the number of reads. Experience with high load NoSQL DB situations will be good.
We were in development mode and everything was done on PostgreSQL. We want to replace PostgreSQL with GraphQL + CockroachDB + Couchbase + SQLite (on mobile device).
Your job is to design db structure for the NoSQL and RDBMS, and make them work through GraphQL.
Optimize queries, schemas, tables, stored procedures if required to reduce load and speed performance
If you have the expertise, you get a bonus point if you can use Redis PubSub feature as a message broker for loosely coupled integration.
Our senior developer will give the schema and tables for each db as well as we understand them. You are the DB expert and you will make the final decision
The frontend developer will do the mobile part with the help of the senior developer.
The database developer will make sure everything works properly through GraphQL client
Our data is mostly numerical (numbers) but unstructured and not relational. We want to run machine learning on the data later to identify patterns.
Another bonus point is if you have used OrientDB before, a graph+document+key-value NoSQL, and can implement it instead of Couchbase, a document+key-value NoSQL, if OrientDB is better for machine learning on our data type.
We expect the work should be completed in 2 weeks.
No syncing between distributed db.