Remote Network And System Administration Job In IT And Networking

SQL-Vacuum Expert needed

Find more Network And System Administration remote jobs posted recently Worldwide

We have a Ruby code base that runs multiple jobs on our website. We deployed a piece of code and saw that it bloated up one table in our database because of several updates that happened in this table - We checked that database table and server logs. We suspect that 2 columns in that table are taking up the most size.

We need to remove the bloat in our database (82% bloat in the biggest table) and prevent such bloat from being created in the future. We have auto-vacuum enabled in PostgreSQL v11.

We need a database/SQL expert who Has removed bloat before through partial/full vacuum and knows how to vacuum analyze databases and tables. We are under a strict deadline so need someone who talks less and gets the job done within a day.
About the recuiter
Member since Mar 14, 2020
Jianguo Chang
from Razavi Khorasan, Iran

Skills & Expertise Required

PostgreSQL Programming sql Database Administration 

Open for hiringApply before - Jul 9, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$95.97

Cost

Offer to work on this project closes in 49 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

Similar Projects

SAGE 100 - SUITECRM INTERGRATION

NEED SOMEONE WHO HAS INTEGRATED SAGE 100 ON-PREMISE WITH SUITECRM. GIVE ME A QUOTE TO INTEGRATE THE TWO.

Need MSBI developers

Hi,
I need MSBI developers who are good at SSIS, SSRS and SSAS for an ongoing project

Developer for MicroStrategy Reports needed

Supporting the team with building reports in MicroStrategy incl. setting up DWH, schemas, etc.
Databases are running on AWS, MicroStrategy Server is running with Linux on AWS

Experience with the energy market or timeseries would be goo...read more

Zoho Analytics Developper

I am looking for a freelancer who can create a cash budget report in Zoho analytics.

The report must use the actual data from zoho finance to start the cash budget then make a projection base on some assumptions.

I want to be able t...read more

integration with stock library

hi
i have website with golang backend showing stock markets
need to install charting library and heatmap to the website
i have the library ready
thanks