Postgres Advanced Trainings and Application of Performance Optimizations

Search more jobs
Posted
Worldwide
We are looking for an experienced Senior Database Expert/Engineer to:
- Train our team in database advanced topics
- Improve performance of our database models/queries

We will provide full examples of problematic use cases we have, and we expect applicants to either provide training on how our team can address them internally or research and implement possible solutions.
We will go through each topic sequentially and discuss the best approaches for each.

Expected contribuition scope:
- [TRAINING] Latency inconsistency between query executions
- [TRAINING] How to properly read database query plans
- [TRAINING] Different impact of JOIN types on our application performance
- [TRAINING] Types of indexes and best use-case for each one (and apply to some our our use-cases)
- [TRAINING] Slow indexes
- [IMPLEMENTATION|TRAINING] Partition management OR Physical Data Separation
  - [TRAINING] When should we use it?
  - [TRAINING] How to do it?
  - [TRAINING] PROS & CONS
  - [TRAINING] How to apply it to our use-case
- [TRAINING] When to use CTE (materialized or not) vs NON CTE vs Temporary Table
- [TRAINING] Impact of Dead Tuples on our database & Autovacuum
- [IMPLEMENTATION] Performant distance between binary BLOBs
- [OPTIMIZATIONS] How to improve slow queries


Our application requirements. We require serving data fast on our UI while still supporting a few UI filters. We're looking for improvements that can include:
- Pre-computing data using materialized views or similar techniques
- Improving existing queries by changing their logic or improving DB structure (indices, statistics, ...)
- Identifying and improving deeper limitations in our table structure
  • Less than 30 hrs/week
    Hourly
  • 1-3 months
    Duration
  • Expert
    Experience Level
  • $25.00-$80.00
    Hourly
  • Remote Job
  • Ongoing project
    Project Type

Skills and Expertise

Databases
PostgreSQL Amazon Aurora
Database Development Deliverables
Performance Optimization
+ 5 more
Business Size
Business with 10-99 Employees
Other
PostgreSQL Programming

Activity on this job

  • 10 to 15
    Proposals
    10 to 15
  • 8 days ago
    Last viewed by client
    8 days ago
  • 5
    Interviewing
    5
  • 6
    Invites sent
    6
  • 0
    Unanswered invites
    0

About the client

Member since Aug 30, 2019
  • Portugal
    Porto 1:07 pm
  • 56 jobs posted
    100% hire rate, 2 open jobs
  • $331,649 total spent
    185 hires, 76 active
  • $8.56 /hr avg hourly rate paid
    36,078 hours
  • Large company (100-1,000 people)
  • Member since Aug 30, 2019

Explore similar jobs on Upwork

Service Center App
New
Fixed-price ‐ Posted 5 hours ago
Design a database using MongoDB
New
Fixed-price ‐ Posted 8 hours ago
MongoDB Database Design Database NoSQL Database

How it works

Post a job icon
Create your free profile

Highlight your skills and experience, show your portfolio, and set your ideal pay rate.

Talent comes to you icon
Work the way you want

Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.

Payment simplified icon
Get paid securely

From contract to payment, we help you work safely and get paid securely.

Want to get started?

About Upwork

Stars rating
4.9/5
(Average rating of clients by professionals)
G2 2021
#1 freelance platform
49,000+
Signed contract every week
$2.3B
Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by
Microsoft Logo Airbnb Logo Bissell Logo GoDaddy Logo

Other open jobs by this Client (1)