Senior PostgreSQL Architect / Database Reliability Engineer (DBRE)

O projekcie: Senior PostgreSQL Architect / Database Reliability Engineer (DBRE) Mission of the Role Stability, Scale, and Efficiency 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). Seniority & Collaboration - Senior or higher level. - Join the infrastructure team managing public cloud, on-premises systems, network, OS, and databases. Contract Duration - Engagement planned at least until the end of 2026, with possible extension. Start Date - Planned start: April 1, 2026. 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. Work Culture & Language Skills - Remote-first work with weekly presence in Poznań office (Thursday). - Polish for daily team communication, English for international projects. - Emphasis on a No-Blame Culture: focus on process improvement and automation rather than assigning blame. Codzienne zadania: - Observability & Query Insights - 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. - Performance Engineering & FinOps - 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). - High Availability & Disaster Recovery - 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. - Database-as-Code & Standards - Automate the database lifecycle using Terraform and Ansible. - Define architectural standards and patterns for development teams: schema design, security policies, backup and maintenance standards.