PostgreSQL Administrator

O projekcie:
Location: Hybrid from Kraków ( 2x week from office
B2B rate: 140-160 PLN netto
Experience Level: Senior / Expert (10+ years)

About the Role

We are looking for an experienced PostgreSQL Engineer to join our team and take ownership of designing, implementing, and maintaining highly available PostgreSQL environments. The ideal candidate will possess expert-level knowledge of logical and physical replication, database performance optimization, high availability (HA), disaster recovery (DR), and automation using modern DevOps tools.

This role requires a hands-on professional who can ensure the reliability, scalability, and security of mission-critical database systems while collaborating closely with development, infrastructure, and DevOps teams.

What We Offer

- Opportunity to work on large-scale, business-critical database environments.
- Exposure to modern cloud-native and DevOps technologies.
- Collaborative and highly skilled engineering teams.
- Professional growth and certification opportunities.
- Competitive compensation package.
- Flexible working arrangements.
- A supportive environment focused on innovation, knowledge sharing, and continuous improvement.
- Benefits: Luxmed and Karta Multisport

If you are passionate about PostgreSQL and have deep expertise in building resilient, high-performance database platforms, we would love to hear from you.

Wymagania:
- 10+ years of hands-on experience in PostgreSQL database administration.- Expert knowledge of PostgreSQL logical and physical replication.- Strong experience with WAL archiving, Streaming Replication, and Logical Decoding.- Proven expertise in database performance tuning, indexing strategies, and query optimization.- Experience automating database operations using Ansible, Jenkins, Bash, and/or Python.- Strong understanding of database security, auditing, and access management.- Hands-on experience with Google Cloud Platform (Cloud SQL, IAM, VPC, GKE).- Excellent troubleshooting, analytical, and problem-solving skills.- Strong communication skills and ability to work effectively in cross-functional teams.- Professional proficiency in English.Preferred Qualifications- PostgreSQL certification.- Experience with Kubernetes and Docker.- Experience building and supporting CI/CD pipelines.- Familiarity with monitoring and observability tools such as Prometheus, Grafana, and ELK Stack.- Knowledge of additional database technologies, including MySQL, Oracle, or NoSQL databases.- Experience with other cloud platforms such as AWS and Microsoft Azure.

Codzienne zadania:
- Design, implement, and manage PostgreSQL replication (logical and physical) to support High Availability (HA) and Disaster Recovery (DR) requirements.
- Administer, monitor, and optimize PostgreSQL databases to ensure high performance and reliability.
- Perform database performance tuning, indexing optimization, and query optimization.
- Automate database deployment, configuration, and operational tasks using Ansible, Jenkins, and scripting languages such as Bash and Python.
- Develop, implement, and maintain backup, recovery, and failover strategies.
- Configure and manage EDB Failover Manager (EFM) and other HA solutions.
- Monitor database health, security, and performance, proactively identifying and resolving issues.
- Troubleshoot replication, performance, and operational problems in complex database environments.
- Collaborate with development, infrastructure, and cloud engineering teams to ensure database scalability and operational excellence.
- Implement database security, auditing, and access control best practices.
- Work with Google Cloud Platform services, including Cloud SQL for PostgreSQL, GKE, IAM, VPC networking, and monitoring solutions.