Remote Network And System Administration Job In IT And Networking

Redesign of postgresql DB very specialised usage / big tables / few big queries than need to be fast

Find more Network And System Administration remote jobs posted recently Worldwide

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 recuiter
Member 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.16

Cost

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

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

Other jobs by this client

I need a resource of microservice,azure ,kafka and spark - Hourly
LA Based Crestron Programmer - Hourly
Front End Developer - Hourly
Expert Shopify eCommerce Consultant Needed - Hourly
Web Designer needed - Hourly
Data Entry- Company Expense Report (Looking at pictures of receipts and entering info into sheet) - Hourly
Web design/ Branding/ UX - Fixed
Developer needed to make a small game in HTML 5 - Hourly
Need data dumped into 3rd party processing and line items labeled - Hourly
Build a website - Fixed
Help to choose development architecture for Rental Marketplace that has nonordinary complexities. - Fixed
Scripting & Automation - Fixed

Similar Projects

Looking for ML engineer with atleast 2 years of experience with experience in NLP and deep learning

Looking for an experience data scientist to deliver a running and self-improving AI engine using deep learning with the data corpus provided. Data corpus has lot of text hence a knowledge of NLP will help.

Matlab machine learning algorithm EASY WORK

Looking to classify images using a simple dataset derived from CIFAR-10 dataset and classify the images using 1 or maybe 2 machine learning models.

You are provided with an image dataset, where there are 10 different categories of objects,...read more

Implement pairs trading algorithm using Random Forests

Implement pairs trading algorithm using Random Forests.
No overfitting.

Acceptance test: Metrics for 2000-2017:
Sharpe Ratio: 2
Performance: 30%

Preferred platform: Quantconnect.

Social Listening and Analytics Report for Facebook Page

I have a current client that would need social listening. They basically want a report where they can get an advantage over competitors and how we can be better to stay ahead of the competitors. Need someone to analyze these data, KPIs needed, recomm...read more

Creation of Data Analytics System from Extracted Data

We are currently manually receiving a lot of data for the port business. We want to be able to create a system where all this data is stored in a proper manner where it allows either personnel or in the near future AI to re analyses it so we can spot...read more