Remote Network And System Administration Job In IT And Networking

SQL 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 on May 1st 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
Niqefairuz
from England, United Kingdom

Skills & Expertise Required

Database Administration PostgreSQL Programming sql

Open for hiringApply before - Sep 25, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$142.86

Cost

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

Syspro ERP-Product Config and MRP - Hourly
Restaurant screen menu - Fixed
Linux Administrator - Hourly
Outbound agent! - Hourly
small work Revit 2019 - Fixed
Compensation design expert wanted for AdTech business which includes SaaS and managed services - Hourly
Senior Software Engineer - Hourly
Develop software for teachers to live feed video to students with cloud - Hourly
Need to change a Menu - Fixed
Looking for a professional Wikipedia writer - Hourly
AWS BIg Data Developers - EU Passport holders ONLY - Urgent - Hourly

Similar Projects

Landlords Database

First and for most, I looking for a programmer develop / Architect who has already written a similar programme to what I have detailed below. Due to the fact we are only a small business and cant afford to has a database written from scratch. Please...read more

MIS Executive with good analytical capabilities - Excel, SQL, BI

We are looking for an MIS executive to help our team with data analysis.

The role would be to:
1. Collate data from different sources (for e.g. production team over email, amazon, fedex)
2. Create regular reports (daily, weekly, mon...read more

Developer needed STOCK INFO

Goal make a website that scans options for good SELLING PUTS PROFITS.

1. Find a source that lets you download STOCK OPTIONS info
2: Find ALL put options (on us markets) that are expiring in 60 days
3. Divide the bid by the str...read more

SAP HANA data modeler

Looking for an expert SAP HANA data modeler with experience creating complex SQL scripts and Calculation views in Hana; experience using SAP Data Services; and knowledge of SAP modules & tables.

This is a FULL time opportunity and you are re...read more

MySql Database Expert

Job Description:
Designing, developing and re-engineering of SQL data structures and queries
Analyzing and fine-tuning of the architecture, data structures, and queries
Fine-tuning the MySQL DBMS
Monitoring the database servers secur...read more