Key Facts

Remote From:

Full time

Expert & Leadership (>10 years)

English

Hard Skills

PostgreSQL PostgreSQL SQL (Programming Language) Stored Procedure Database Management Data Partitioning Vacuum Engineering Transactional Replication Indexing Kubernetes +3 more

Other Skills

•
Plan Execution
•
Troubleshooting (Problem Solving)
•
Analytical Skills
•
Communication
•
Mentorship

Roles & Responsibilities

10+ years in PostgreSQL Administration and Performance Tuning
Expert knowledge of PostgreSQL internals, MVCC, WAL, optimizer, locking, and replication
Strong hands-on experience with PostgreSQL 12+ and Aurora PostgreSQL
Expert SQL tuning and EXPLAIN ANALYZE interpretation

Requirements:

Perform advanced PostgreSQL and Aurora PostgreSQL tuning
Optimize SQL, execution plans, indexes, partitioning, and storage layouts
Troubleshoot slow SQL, deadlocks, blocking, WAL contention, CPU/I/O bottlenecks, and replication issues
Manage vacuum, bloat remediation, indexing, replication, and database maintenance activities

Job description

This is a remote position.

Database Performance Tuning Expert (PostgreSQL / Aurora PostgreSQL) – Offshore
Experience
10+ years in PostgreSQL Administration and Performance Tuning

Role Overview
Seeking a senior PostgreSQL Performance Tuning Expert with deep expertise in PostgreSQL and Aurora PostgreSQL optimization, query tuning, partitioning, execution plan analysis, stored procedure tuning, statistics management, and large-scale database performance engineering.

The candidate should independently troubleshoot complex database bottlenecks and improve scalability, throughput, concurrency, and platform stability.

Key Responsibilities

Perform advanced PostgreSQL and Aurora PostgreSQL tuning.
Optimize SQL, execution plans, indexes, partitioning, and storage layouts.
Tune memory, WAL, checkpoints, autovacuum, planner, caching, and parallel query parameters.
Troubleshoot slow SQL, deadlocks, blocking, WAL contention, CPU/I/O bottlenecks, and replication issues.
Optimize PL/pgSQL Stored Procedures, Functions, and batch workloads.
Improve statistics collection, planner behavior, partition pruning, and query performance.
Manage vacuum, bloat remediation, indexing, replication, and database maintenance activities.
Conduct workload analysis, capacity planning, root-cause analysis, and performance benchmarking.
Collaborate with Engineering and Infrastructure teams on enterprise performance improvements.

Requirements

Mandatory Skills
PostgreSQL / Aurora PostgreSQL

Expert knowledge of PostgreSQL internals, MVCC, WAL, optimizer, locking, and replication.
Strong hands-on experience with PostgreSQL 12+ and Aurora PostgreSQL.

Performance Tuning
Expertise in:

shared_buffers
work_mem
maintenance_work_mem
effective_cache_size
wal_buffers
checkpoint/autovacuum tuning
planner and parallel query optimization

SQL & Database Optimization

Expert SQL tuning and EXPLAIN ANALYZE interpretation.
Strong PL/pgSQL and stored procedure optimization skills.
Expertise in joins, CTEs, window functions, indexing, and large-volume workloads.

Partitioning & Maintenance

Deep expertise in PostgreSQL partitioning and partition pruning.
Experience with VACUUM, ANALYZE, REINDEX, WAL optimization, and bloat remediation.
Ability to handle multi-billion-row datasets.

Preferred Experience