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 May 20, 2018
Mark Perlstein
from Torino, Italy

Skills & Expertise Required

Database Administration PostgreSQL Programming sql

Candidate shortlisted and hiredHiring open till - Apr 4, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$143.90

Cost

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

Development expert needed - Fixed
Looking for professional UX/UI designer - Fixed
Need a script or bot built to search our list of phone numbers/addresses and retrieve web URLS - Fixed
Write content - 3.750 - Fixed
Multiple GPS tracker system for vehicles - Fixed
Networking configuration recovery, cisco -> debian server -> magento/odoo - Fixed
Custom Hairbiddy APP Development - Hourly
Android app development for our startup company - Fixed
BluePrism Finance Project - Need urgent help - Fixed
Writing an eBook subject real estate - Fixed
Write a story telling book - Hourly
Symantec Encryption PGP - Hourly
SMTP postfix server setup - Hourly
AWS Site Reliability and DevOps Engineer needed - Fixed

Similar Projects

SQL DBA - LATIN AMERICA ONLY

A major software agency in Virginia, USA is looking for a SQL Database Administrator in Latin America. You would be working as a full-time remote team member with a team of highly talented professionals on an at least 6-months project for a humanitar...read more

Aws custom metrics cloudwatch expert needed

We are looking to setup custom metrics from AWS EC2 instance for disk use and memory use, and need help from someone who has setup AWS cloudwatch metrics for these custom metrics before. We have a strict deadline so we need someone who can setup the...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

Expert Google Data Studio & SuperMetrics.com API Integrator

Connect to PPC, SEO, social, analytics, and other marketing CRMs.

Compare Google Ads, Facebook, Instagram, Twitter, Linkedin and Bing campaigns in the same charts.

Create marketing and sales performance reports.