CONTRACT
Direktlink: https://www.prostaff.ch/de/jobs/25166

We are looking for a Database Performance Engineer to support a financial industry client.

• Workload Profiling & Bottleneck Analysis: Analyze ingestion and transformation workloads to identify performance bottlenecks, inefficiencies, and resource constraints.
• Architectural Evaluation: Assess the continued use of Citus in the current setup and compare with native PostgreSQL features.
• Storage Experiments: Run targeted experiments on columnar vs. row-based tables, focusing on query performance, update handling, indexing strategies, and optimization.
• Performance Optimization: Investigate query planning, indexing, parallelization, batching, memory, and I/O optimization.
• Optimization Patterns: Develop and document improved ingestion and transformation patterns using PostgreSQL and Citus features (e.g. indexing, partitioning, parallelization).
• Tooling & Observability: Set up or enhance monitoring and profiling tools (e.g. pg_stat_statements, auto_explain, pgBadger).
• Guidelines & Recommendations: Deliver actionable recommendations and best practices for performance, maintainability, and scalability of the platform.

-->Remote (within switzerland) setup possible, with occasional onsite presence (max. 1 day/week)

• Deep expertise in PostgreSQL internals and query handling
• Strong knowledge of database performance and data management
• Solid SQL and data modeling skills
• Familiarity with analytical workloads and update-heavy scenarios
• Experience designing and interpreting performance experiments
• Proficiency with observability tools and performance metrics