Senior PostgreSQL Architect - Database Reliability Engineer

Nasze wymagania: Deep knowledge of PostgreSQL internals: MVCC, WAL, Autovacuum under load, Query Planner. Experience with large-scale databases (2TB+): partitioning, bloat management, zero-downtime operations. Multi-cloud and hybrid environment experience: Azure Database for PostgreSQL, Google Cloud SQL, Linux-based PostgreSQL instances. Software engineering approaches: infrastructure as code, automation via custom tools and scripts. Pragmatic technology mindset: selecting stable, proven solutions and making decisions based on technical and economic justification. O projekcie: We are looking for an engineer capable of designing and maintaining large-scale data systems (2TB+) while ensuring stability and cost efficiency. If your ideal system runs reliably because it was well-architected from the start, this role is for you. Our environment is hybrid (On-premise, Azure, GCP). This is not an incident-response administrator role — we are seeking an architect who will take ownership of the full data ecosystem, implement a Database-as-Code approach, and demonstrate that query optimization is the most effective way to reduce cloud costs (FinOps). Remote-first work with weekly presence in Poznań office (Thursday). Engagement planned at least until the end of 2026, with possible extension. Planned start: April 1, 2026. Zakres obowiązków: Build a central “Single Point of Truth” for database monitoring across the organization (Prometheus / Grafana / pganalyze). Transition from infrastructure-level monitoring to in-depth query analysis. Identify performance issues before they impact end-users. Audit key database instances for resource usage. Optimize costs through: configuration tuning, index design, query optimization, SQL refactoring. Support safe downsizing of cloud infrastructure (SKU Optimization). Design high-availability architectures for distributed systems (microservices). Standardize failover mechanisms. Automate backup and recovery procedures (PITR, pgBackRest). Build an environment with predictable, repeatable operational behavior. Automate the database lifecycle using Terraform and Ansible. Define architectural standards and patterns for development teams: schema design, security policies, backup and maintenance standards.