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
PROSTAFF vermittelt und besetzt Informatik- und Data Science-Projekte in der Schweiz mit Freiberuflern, Freelancern, Contractors und temporären Mitarbeitern.