PostgreSQL Ownership: Optimize our data platform through advanced SQL (CTEs, window functions), query plan analysis (EXPLAIN ANALYZE), indexing/partitioning strategies, and performance tuning under production load. * Solid hands-on experience with PostgreSQL in production: indexing strategies, partitioning, pg_stat_statements, vacuum/autovacuum tuning, replication, and an understanding of MVCC.
mehr