Remote Network And System Administration Job In IT And Networking

PostGreSQL-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 due to the code.

We need 3 things in this project:

1. Immediately remove the bloat in our database (82% bloat in the biggest table) through partial/manual/FULL vacuum as the bloat is causing certain processes to slow down on our app. We have Auto-Vacuum settings enabled and the settings - We also find that auto-vacuum is not being run on our biggest table (Candidate_Project_Matchings table), so that probably caused the bloat in this table and needs to be fixed.

2. Prevent such bloat from being created in the future and editing database features in a way that auto-vacuum is run on all tables effectively, including the biggest table

3. Re-indexing our index tables, if needed, to remove existing bloat and prevent future bloat

Our DB Size is 53GB, and the biggest table takes up 26GB (Out of which 22GB is bloat). We have total disk space of 160GB right now an EC2 instance. We are using PostGreSQL v11.
About the recuiter
Member since Mar 14, 2020
Roopa Selvanaya
from Hessen, Germany

Skills & Expertise Required

Database Administration PostgreSQL Programming sql

Open for hiringApply before - Jan 7, 2025

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$95.52

Cost

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

Building media acq server. Usenet, couch potatoe, sickbeard archive files for my plex server. - Hourly
Looking for a fashion designer for shopping bags - Hourly
NetSuite implementation assistance - Hourly
Looking for an interior designer for a coffee shop 130m2 - Fixed
Wordpress Coder Needed - Hourly
Graphic designer - Hourly
Edit logo for transparency - Hourly
Microsoft Flow Development - Fixed
Write scripts to get web traffic data from SOPHOS XG firewalls - Fixed

Similar Projects

Management of Data Visualization Tool and Database

Our project has a group of crawlers in Python that do some researches on the web. Our main database used is Mongo DB, and the crawlers made this connection through an API.
Nowadays, we are using PowerBI as data visualization tool (weve used Met...read more

Implement Apple

We are looking for a highly experienced developer to help integrate Apple Pay as well as Klarna into our custom PhP Website. The ideal candidate will have done Apple Pay integration before and have a complete understanding of custom payment integrati...read more

SQL expert needed for financial reporting project

My company is a financial services firm in the business of issuing asset backed securities. Im looking for a SQL expert that can help create variables within SQL Queries (I believe this is called dynamic SQL) to create a user friendly report.

I need experienced DevOps person to manage AWS server for a high traffic website.

We have a website which has more than 1 million visitors per month. Currently the website is hosted on Amazon AWS server and we are looking for a DevOps person to manage the server tasks for us. Please share your previous experience in this domain.

Build Transport function from dropbox to s3 bucket

What were looking for:
An experienced web developer to help kick-start/build code that will stitch together various AWS services. We need someone to work on a file transport utility that takes audio files from a dropbox folder or ftp folder and...read more