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 OrientDB (option is Couchbase) NoSQL. NoSQL DB 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 + OrientDB (option Couchbase) + SQLite (on mobile device).
Your job is to design db structure for the NoSQL and relations DB (RDBMS), and make them work through GraphQL.
Optimize queries, schemas, tables, stored procedures if required to reduce load and speed performance. Our backend code is in Node.js and frontend in Flutter Dart.
Bonus point if you have expertise AND previous production expertise with:
1. OrientDB, a graph+document+key-value NoSQL, for machine learning on our data type - mostly numerical (numbers) but unstructured and not relational.
2. LDAP. We prefer 389 Directory Server [login to view URL]
3. 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
We expect the work should be completed in 2 weeks.
No syncing between distributed db.