Senior DBA PostgreSQL

The position is for an experienced PostgreSQL Engineer to join a team working with a leading international bank. The role involves managing PostgreSQL replication and database administration with a focus on automation and cloud platforms. The project is stable and long-term, based in Kraków with hybrid work arrangements.

• 7+ years of hands-on experience with PostgreSQL administration and replication (logical & physical)
• Strong expertise in WAL archiving, streaming replication, and logical decoding
• Proficiency in database performance tuning, indexing strategies, and query optimization
• Experience in automating database tasks using Ansible, Jenkins, and scripting
• Solid knowledge of database security, auditing, and access control mechanisms
• Strong troubleshooting and problem-solving skills

Nice to have:

• PostgreSQL certification
• Experience with Kubernetes, Docker, and CI/CD pipelines
• Knowledge of other databases like MySQL, Oracle, or NoSQL databases
• Experience with monitoring tools like Prometheus, Grafana, or ELK Stack
• Familiarity with Google Cloud (Cloud SQL, IAM, VPC, GKE) and other cloud platforms (AWS, Azure)

• Design, implement, and manage PostgreSQL replication (logical and physical) for high availability and disaster recovery
• Optimize database performance, tuning, and query optimization
• Automate database deployment and management using Ansible, Jenkins, and scripting (Bash/Python)
• Develop and maintain backup, restore, and failover strategies, including experience with EDB Failover Manager (EFM)
• Work closely with development and infrastructure teams to ensure database scalability and reliability
• Monitor database health, security, and troubleshoot replication issues
• Implement best practices for high availability (HA) and disaster recovery (DR) solutions
• Work with Google Cloud (Cloud SQL for PostgreSQL, GKE, GCP networking, IAM, monitoring) and other cloud platforms

Hybrid work arrangement: 6 days per month from the office in Kraków