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
Manaharsinh Goh
from Katsina, Nigeria

Skills & Expertise Required

software development 
Open for hiringApply before - Oct 9, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.61

Cost

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

Data Mining - Fixed
Need an expert in HP/HPE - Hourly
Website updates - Hourly
assist in implementation of zoho crm in brisbane queensland - Hourly
Image data to CSV file - Fixed
Fun "Candyland" style infographic design needed for eBook - Topic is Legal Technology (eDiscovery) - Fixed
Looking for good web designers - Hourly
Live ranking site for crypto - Hourly

Similar Projects

Experienced full stack developer at vue.js

What were looking for:
An experienced full stack developer to implement new functionalities into our existing project. We need someone to work on frontend development. The project is based on vue.js, .net core, Postgres DB.
We need to do fol...read more

Set up MS SQL Server 2016 to receive emails

Configure SQL Server 2016 to check a gmail account, and download the messages into a table.

Backend Developer needed to clean MALWARE

There seems to be malware on one of our websites.

It is draining our servers and maxing out the CPU usage. Number of processes shows at 99%

These are Godaddy servers so you must be familiar with the Godaddy platform.

Need API Built for Active Campaign

Need an API connector for Active Campaign.

What I need is for when a transaction goes through for it to send the information as a contact record into Active Campaign

NMI API
Checkout the collect.js documentation

Active...read more

PODIO DEVELOPER

I am looking to get some automation and integrations done to my podio crm. I want to get scraped dats from Zillow (FSBO and Rental) and Craiglist (FSBO). I am also looking for someone who can implement text/email blasting.

Submit A Proposal