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
Saurabh Garg
from Baden-Wurttemberg, Germany

Skills & Expertise Required

PostgreSQL Programming sql Database Administration

Open for hiringApply before - Nov 4, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$95.25

Cost

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

Cyber Security Online Course - Fixed
One of a kind logo/icon needed - Fixed
AP Integration: MIcrosoft GP 2010 - Hourly
Translate content from English to Arabic - Fixed
Replicate an existing website - Hourly
From Adobe XD to the programming back end website. - Fixed
Need 3D Auto Cad expert - Fixed
install and configure Jasmin SMS gateway required - Fixed

Similar Projects

Python script to upload CSV files to Bigquery

CSV files are generated in other processes. Python script is needed to upload the data from these files into a Bigquery table.

Script Language:
Python

Scrip should do:
The script is run in a specific folder.
Scan that fo...read more

Migrate web app from Server 2008r2 to Server 2016

We have a web app that has a mobile app tied to it that was written many years ago. It is hosted on 08r2 with sql 08r2 along with crystal reports for web reporting. It needs to be migrated to Server 2016 and sql 2017. It is not very complex at all...read more

ACT! CRM consultancy work

I need to import alot of excel spreadsheets into ACT! and sort into Groups. However, Im having big problems, so need someone with alot of experience on ACT! and EXCEL to help import and sort data. ACT! tell me theres something wrong with the excel s...read more

Database and cloud administration

Looking for database administrator with skills in various tools for automation. Please specify your skills and work history.

CRM development

We are looking for a full-stack developer, preferred with over two years experience, for a CRM project. We are working on with Laravel7.0 and Javascript mostly, but every new technology is welcomed. The project we are working on is rated as easy sinc...read more