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
Anton Wijaya
from Issyk-Kul, Kyrgyzstan

Skills & Expertise Required

PostgreSQL Programming sql Database Administration

Candidate shortlisted and hiredHiring open till - Sep 4, 2020

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$69.49

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

Article & Blog Writing - Fixed
PDF Design - Fixed
Creative Cartoon Character Illustration / Icons Design (Ongoing Job) - Fixed
Create HTML Page from PSD Files - Hourly
Ranked Dating IOS / Android App - Hourly
Aws custom metrics cloudwatch expert needed - Fixed
ECS Installation Technician - Fixed
Terms of Service and Privacy Policy Documents Review - Hourly
Image reconstructions using fragments (opencv, c++) - Fixed
Quickbooks Proficient Bookkeeper Needed for Business - Hourly
Proofreader of English text. - Hourly
Developer needed quickly for sweepstakes landing page! - Hourly

Similar Projects

Transportation related - Robotic Process Automation (RPA)

Experienced in Designing, Developing and Implementing of Robots to automate repetitive and manual business processes using (RPA) Kofax Kapow.
Experienced in automating data extraction and validation of paper-based PDF document processing using...read more

Python Data Engineer needed

We are looking for a python developer who has good experience with ETL, SQL and AWS. The candidate will be creating data engineering solutions and migrating data. The engineer should be a self-driven problem-solver who loves taking on new challenges...read more

Dev Ops Security Advisor (Cloudflare, GCP, K8s)

Our small team is currently searching for a dev ops expert in GCP / Kubernetes / Cloudflare.

Tasks including:
- Documentation update
- Security review
- Being sure of the scalability of the system
- Troubleshoot some dev-obs...read more