PostgreSQL Administrator

Antal is hiring for a PostgreSQL Administrator role based in Kraków, Poland, working in a hybrid model. The position involves managing large-scale, business-critical PostgreSQL database environments with exposure to modern cloud-native and DevOps technologies.

• 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.

Nice to have:

• 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.

• 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, 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.