Database Performance Tuning Expert (PostgreSQL / Aurora PostgreSQL)
Posted 2 hours ago
Worldwide
⭐
10+ years experience
Please mention DailyRemote when applying
AI Summary
Perform advanced performance tuning and optimization for PostgreSQL and Aurora PostgreSQL databases. Troubleshoot complex bottlenecks, optimize stored procedures, and manage large-scale database stability and scalability.
This is a remote position.
Database Performance Tuning Expert (PostgreSQL / Aurora PostgreSQL) – Offshore
Experience
10+ years in PostgreSQL Administration and Performance Tuning
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.
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
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:
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
- AWS RDS PostgreSQL and Aurora PostgreSQL
- Kubernetes/containerized PostgreSQL
- Linux performance tuning
- PgBouncer, HA architectures, and logical replication
- Monitoring tools such as pg_stat_statements, Prometheus, Grafana, and pgBadger
- Data Warehousing and large analytical platforms
Soft Skills
- Strong troubleshooting and analytical capability
- Excellent communication and stakeholder management
- Ability to work independently in offshore delivery models
- Strong documentation and mentoring skills
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
