Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Big Data,Machine Learning,PostgreSQL Administration freelancer for Redesign of postgresql DB very specialised usage / big tables / few big queries than need to be fast job

Posted at - Dec 8, 2023

Toogit Instant Connect Enabled


deliverable : tables design, configuration file, query much faster than today
we are a nice startup doing automated operations sstems ( ordering and business insights)

We are a startup
We are noobs in postgres and for sure someone with experience will laugh at our challenge but for the first time in years uncle google proved not enough
We do not fear any challenge, we just do it :-)
attached the probably poor design of our main table, around 300 unique dates , for each date 25k indexes and for each index around 10 names, that makes around 40 M rows. Also i will share our typical query that takes 35 seconds in postgres to execute, 55 seconds from script in RStudio.

We would like to grow now so the just do it approach has its limits and would like you to advice us on proper desing of tables and DB archi

About the recuiterMember since Nov 11, 2022 Wide Web Technology
from Kerewan, Gambia

Skills & Expertise Required

Big Data Machine Learning PostgreSQL Administration 

Open for hiringApply before - Dec 7, 2024

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$19.31
Cost

Offer to work on this project closes in 280 days!
Are you interested in this Opportunity?

Apply Now

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Network And System Administration category.


Related Jobs


Latest In Big Data Jobs


Latest In Machine Learning Jobs


Latest In PostgreSQL Administration Jobs