A good database developer who can speak and write good English required to write optimized, highly performant (heavily stressed) queries for various cloud based databases that we use - PostgreSQL on AWS Aurora, Apache Directory Server (ADS) (for LDAP), S3 (for flat files), MongoDB (for NoSQL), Google Cloud Storage (to store encrypted compressed JSON) and AWS Quantum (which uses PritiQL - slightly modified SQL). We are using GraphQL to connect the databases.
1. Convert an existing PostgreSQL database into ADS, S3 and NoSQL. Only the part of the application that must remain in RDBMS must remain in PostgreSQL on AWS Aurora.
2. Apache Directory Server (ADS) (for LDAP)can be configured with the included Directory Studio. You need a good understanding of LDAP directories use and optimization. You will create directories for 3 applications. One is very basic, another is slightly more complex and a third has more data elements.
3. Write a few scripts for interactions with AWS Quantum through API's. PritiQL is almost 100% SQL-like but will need SQL generated by any DB management tool e.g. DBeaver to be tweaked to run correctly. This link and other pages in this heading, take you to how to write queries to write and read data in Quantum [login to view URL]
DBeaver writes SQL. PritiQL is a modification of SQL. The code produced by DBeaver (or any DB management tool) must be hand coded.
Likely 2 weeks of concentrated work
29 freelancers are bidding on average $652 for this job
Hi i m very interested for this kind of job and i am an expert database developer and i have all avobe skills and i can help you on that task. just knock me via chat. Thanks Rashedul
Hi, I have 10 years experience of SQL development and working as team lead in MNC.I can help you in writing [login to view URL] also will help you i teaching the [login to view URL] can pay later once you are satisfied. regards