................
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
Coopers iET AG ist eine agile Schweizer Recruiting Agentur, die Spezialisten und Führungskräfte in den Bereichen IT, Life Sciences, Engineering und Finance vermittelt. Mit flexiblen Ansätzen bringen wir Kandidat:innen und Unternehmen zusammen, die nicht nur fachlich, sondern auch menschlich zusammenpassen.