93 389
15 233
Technologies-expected : Postgre SQL Prometheus Nagios Grafana technologies-optional : Microsoft Azure Ansible Terraform Shell Apache Kafka Spark Docker Kubernetes about-project : We are seeking an experienced Postgre SQL Administrator to manage and optimize our Postgre SQL database environments. The ideal candidate will ensure the high availability, performance, and security of our Postgre SQL 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 Postgre SQL and thrive in a fast-paced environment, we encourage you to apply. MD rate: 140 - 180 EUR responsibilities : Install, configure, and maintain Postgre SQL 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. requirements-expected : 3+ years of experience managing Postgre SQL databases in production environments. Strong proficiency in SQL and query optimization techniques. Experience with Postgre SQL replication (logical and streaming) and backup strategies (e.g., pg_basebackup, pg Back Rest). Familiarity with Postgre SQL extensions such as Post GIS, pg Audit, or pg Bouncer. Knowledge of partitioning, indexing, and query optimization in Postgre SQL. 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 Postgre SQL performance tracking. benefits : remote work opportunities