Database Performance Engineer - PostgreSQL

................

For our client in the banking sector based in Basel, we are looking for an experienced, motivated, and open-minded Database Performance Engineer with strong expertise in PostgreSQL.

Your tasks:

• Analyze ingestion and transformation workloads to identify performance bottlenecks and inefficiencies
• Evaluate the use of Citus vs. native PostgreSQL features, especially in single-node setups
• Conduct performance experiments comparing columnar and row-based storage
• Optimize query planning, indexing, parallelization, and memory/I/O usage
• Develop improved ingestion and transformation patterns using PostgreSQL and Citus features
• Set up and enhance observability tools (e.g., pg_stat_statements, auto_explain, pgBadger)
• Deliver actionable recommendations to improve performance, scalability, and maintainability

Your profil:

• Deep expertise in PostgreSQL internals and query handling
• Strong understanding of database performance, data management, and SQL optimization
• Experience with analytical workloads and update-heavy scenarios
• Hands-on experience designing and interpreting performance experiments
• Familiarity with observability tools and performance metrics
• Strong SQL and data modeling skills
• Experience with Citus, including columnar storage, is a strong plus
• Fluent in English