PostgreSQL Engineer w Kraków, Polska

Job Title: PostgreSQL Engineer (Expert Level) Experience: 10+ years Industry: banking Work model: full-time, hybrid from Krakow: 2 days/week on-site Project language: English Business trips: n/a Project length: open-end contract Start: ASAP / Flexible Assignment type: B2B Job Description: We are seeking an experienced PostgreSQL Engineer with expert-level knowledge in logical and physical replication to join our team. The ideal candidate should have a strong background in database administration, replication strategies, and automation using DevOps tools like Ansible and Jenkins. Experience with Google Cloud and other cloud platforms is a plus. Main Responsibilities: 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. 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. Key Requirements: 10+ 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. Familiarity with Google Cloud (Cloud SQL, IAM, VPC, GKE) and other cloud platforms (AWS, Azure) is a plus. Strong troubleshooting and problem-solving skills. Experience with monitoring tools like Prometheus, Grafana, or ELK Stack is a plus. Preferred Qualifications: PostgreSQL certification is a plus. Experience with Kubernetes, Docker, and CI/CD pipelines. Knowledge of other databases like MySQL, Oracle, or NoSQL databases is a bonus.