Database Performance Engineer - PostgreSQL

• 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

Do you have experience in SQL?, 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., * 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