Remote Network And System Administration Job In IT And Networking

Looking for Postgres expert to help identify and fix performance issues

Find more Network And System Administration remote jobs posted recently Worldwide

I have a Postgres 11 database hosted on Amazon RDS with tables containing millions of rows.
Some queries used to take 10 seconds to complete but now take many minutes. The RDS Current Activity bar is constantly red, indicating heavy load on the DB.

The job consists of:
- Analyzing which queries take long to complete and improving them if possible
- Help create proper indexes. I have created some basic indexes but I feel there is a lot more to gain with using some more complex indexes.
- Log in to the Amazon RDS portal to analyze the DB metrics and possibly change configurations
About the recuiter
Member since Mar 14, 2020
Surtiono Darman
from Podunavlje, Serbia

Skills & Expertise Required

software development

Open for hiringApply before - Jun 27, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.90

Cost

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

Adapt Google Cloud Print as proxy for a dedicated file transfer application - Fixed
V-ray | Maxwll rendering - Hourly
Website Transfer (From Yahoo to Squarespace) - Fixed
Ethical hacking mobile phone - Fixed
Node expert required to review existing ETL code - Fixed
Full Stack WordPress Plugin Developer - Fixed
Need someone to create an Instagram filter (mask). - Fixed
eCommerce Catalogue Management - Hourly
Author's website design - Hourly
Game Development - Fixed
Amazon Web Services help - Hourly
Custom Taco Designs - In need of a designed to turn our concepts into reality - Hourly
Grow instagram followers - Fixed
Looking for Business Development Executive (Staffing) - Fixed

Similar Projects

Pageview tracking for a custom ecommerce website using sql server

I need a skilled asp.net mvc c# developer to create a page view tracking system for my custom built website. You dont have to integrate it into my system - only into my sql server db. The pageview tracking db table should contain as much as possible...read more

Migrate website from squarespace to wordpress

We need someone to move a 12-page website from squarespace to wordpress. You will have access to all of the content and we will provide the hosting for the wordpress. A photo of the front page of the site is provide on request.

News letter for my php front store

I need a sign up new letter on my website front store. so people could sign up and receive new letter automatically on my f php front store.

Speed up Wordpress on Siteground

I want my site to score in the 90s on pagespeed and GTmetrix. Its on sitegrounds shared hosting. I have SG optimizer installed and its caching. Also have cloudflare set up through siteground.

I need someone to help me further optimize it....read more

Custom WordPress plugin

Need a WordPress plugin that would allow jobs to be entered and assigned to outside vendors. It will need to have the availability to notify the vendor and a vendor to create a profile. Geo locate the vendor with information posted in the job. The...read more