PostgreSQL Engineer

emagine Polska; Kraków; Hybrid; PLN 170,000 - 243,000; Full time

Benefits offered by this job

Hybrid work from Kraków

On-site 2 days/week in Kraków

Job summary

emagine Polska seeks a PostgreSQL Engineer (Expert Level) in Kraków for a full-time hybrid role. You will lead replication strategies, performance tuning, and DevOps automation to support banking applications. English is the project language; start ASAP with a B2B assignment.

You will collaborate with cross-functional teams, implement HA/DR solutions, and work with Google Cloud and other cloud platforms.

Qualifications

• 10+ years of hands-on PostgreSQL administration and replication experience.
• Strong WAL archiving, streaming replication, and logical decoding expertise.
• Experience automating DB tasks with Ansible, Jenkins, and scripting.
• Familiarity with Google Cloud and other cloud platforms is a plus.

Responsibilities

• Design, implement, and manage PostgreSQL replication for high availability and DR.
• Optimize performance, tuning, and query optimization.
• Automate deployment and management with Ansible and Jenkins; implement scripting (Bash/Python).
• Develop and maintain backup, restore, and failover strategies.
• Collaborate with development and infra teams to ensure scalability and reliability.
• Monitor DB health, security, and replication issues.
• Apply HA/DR best practices across environments.
• Work with Google Cloud (Cloud SQL for PostgreSQL, GKE, IAM, networking).

Skills

PostgreSQL administration

Replication (logical & physical)

Database performance tuning

Automation scripting (Bash/Python)

DevOps tooling (Ansible/Jenkins)

Cloud platforms knowledge (GCP/AWS/AZ)

Troubleshooting and problem solving

Monitoring (Prometheus/Grafana)

Tools

Ansible

Jenkins

Google Cloud

Kubernetes

Job description

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

Remuneration: up to 150 PLN/h

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.