Database Performance Engineer (Postgres, english speaking)
Database Performance Engineer (Postgres, english speaking)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
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. pgstatstatements autoexplain 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
Employment Type
Full Time
