About the project

• We are seeking an experienced PostgreSQL Administrator to manage and optimize our PostgreSQL database environments. The ideal candidate will ensure the high availability, performance, and security of our PostgreSQL databases. This role involves collaborating with development and operations teams to support data-driven applications and business processes.
• This role offers the opportunity to work on critical database systems and contribute to the stability and performance of data-driven applications. If you are passionate about PostgreSQL and thrive in a fast-paced environment, we encourage you to apply.
• MD rate: 140 - 180 EUR

Your responsibilities

• Install, configure, and maintain PostgreSQL databases across development, testing, and production environments.
• Monitor database performance and optimize queries, indexes, and configurations to ensure high efficiency.
• Implement and manage backup, replication, and disaster recovery solutions.
• Perform regular maintenance tasks such as vacuuming, indexing, and partitioning.
• Ensure database security by implementing access controls, data encryption, and regular audits.
• Troubleshoot and resolve database issues, ensuring minimal downtime and maximum availability.
• Collaborate with development teams to design and optimize database schemas and queries.
• Plan and execute database migrations, upgrades, and patches.
• Maintain documentation for database configurations, processes, and best practices.
• Provide on-call support for database-related incidents.

Our requirements

• 3+ years of experience managing PostgreSQL databases in production environments.
• Strong proficiency in SQL and query optimization techniques.
• Experience with PostgreSQL replication (logical and streaming) and backup strategies (e.g., pg_basebackup, pgBackRest).
• Familiarity with PostgreSQL extensions such as PostGIS, pgAudit, or pgBouncer.
• Knowledge of partitioning, indexing, and query optimization in PostgreSQL.
• Hands-on experience with Linux systems for database management and troubleshooting.
• Strong understanding of data security and compliance requirements.
• Experience with monitoring tools like Prometheus, Nagios, or Grafana for PostgreSQL performance tracking.

Optional

• Experience with cloud-based PostgreSQL solutions such as Amazon RDS, Google Cloud SQL, or Azure Database for PostgreSQL.
• Familiarity with automation tools like Ansible, Terraform, or Shell scripting for database management.
• Knowledge of big data integrations and tools like Apache Kafka or Spark.
• Experience with containerized environments using Docker and Kubernetes.
• Exposure to Agile/Scrum methodologies.
• Certification in PostgreSQL administration (e.g., EDB Certified PostgreSQL Associate).

Technologies we use

This is how we work on a project

• Continuous Deployment

• Continuous Integration

• active monitoring

• documentation