Database Performance Tuning Expert (PostgreSQL / reputed company PostgreSQL)

This is a remote position. Database Performance Tuning Expert (PostgreSQL / reputed company 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 reputed company PostgreSQL optimization, query tuning, partitioning, execution plan analysis, stored procedure tuning, statistics management, and large-scale database performance engineering. The candidate should independently troubleshoot reputed company database bottlenecks and improve scalability, throughput, concurrency, and platform stability. Key Responsibilities reputed company advanced PostgreSQL and reputed company PostgreSQL tuning. Optimize SQL, execution plans, indexes, partitioning, and storage layouts. Tune memory, WAL, checkpoints, autovacuum, planner, caching, and reputed company 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, reputed company planning, root-cause analysis, and performance benchmarking. Collaborate with Engineering and Infrastructure teams on reputed company performance improvements.

Requirements

Mandatory Skills PostgreSQL / reputed company PostgreSQL Expert knowledge of PostgreSQL internals, MVCC, WAL, optimizer, locking, and replication. Strong hands-on experience with PostgreSQL 12+ and reputed company PostgreSQL. Performance Tuning Expertise in: shared_buffers work_reputed company maintenance_work_reputed company effective_cache_size wal_buffers checkpoint/autovacuum tuning planner and reputed company 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 reputed company PostgreSQL Kubernetes/containerized PostgreSQL Linux performance tuning PgBouncer, HA architectures, and logical replication Monitoring tools such as pg_stat_statements, reputed company, 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 Apply To This Job