PostgreSQL Database Administrator

We are currently looking for a “PostgreSQL Database Administrator” to strengthen the Cronos Europa team.

The ideal candidate will have strong expertise in PostgreSQL administration and automation using Ansible. Additional knowledge of MSSQL and Oracle is a plus. This role involves managing database environments, supporting ITIL processes, working in rotational shifts, and maintaining comprehensive documentation for all tasks and processes.

Responsabilities:

You'd be given the opportunity to join a great European institution and be part of the Databases Operations team (PGSQL 11->16, AWS RDS PGSQL, Oracle 19c and MSSQL 2016 ->2022).

• Administer, monitor, and maintain PostgreSQL databases, ensuring high availability and optimal performance.
• Automate database administration tasks using Ansible, including deployments, updates, and configuration management.
• Perform lifecycle management for PostgreSQL and Red Hat environments, including in-place updates and upgrades.
• Manage database security, grants, permissions, and user roles.
• Handle backup and restoration processes using PostgreSQL Barman.
• Monitor and respond to alerts using tools such as Prometheus, Grafana & Pulse.
• Use administration tools such as pgAdmin and OmniDB for database management.
• Collaborate with Architecture and Development teams to support migrations from Oracle to PostgreSQL on-premises or cloud-based environments (e.g., AWS RDS PostgreSQL).
• Create, maintain, and update clear, detailed, and organized documentation for processes, configurations, and troubleshooting guides.
• Adhere to ITIL processes, including incident, problem, and change management, using a ticketing system (ServiceNow).
• Participate in on-call rotation and ensure timely resolution of incidents.

Technical skills:

• Proficiency with PostgreSQL tools and features, including replication, performance tuning, and backup strategies.
• Strong expertise in Ansible for automation.
• Familiarity with Prometheus, Grafana, pgAdmin, and OmniDB.
• Knowledge of PostgreSQL Barman for backups.
• Understanding of Red Hat Linux lifecycle management.
• Nice to have skills :
• Experience with Oracle and MSSQL databases.
• Knowledge of cloud-based database solutions, particularly AWS RDS PostgreSQL.
• Experience with database migrations from Oracle to PostgreSQL.

Profile :

• 3–5 years of experience with PostgreSQL database administration
• Proven ability to create and maintain clear, concise, and accurate documentation.
• Strong analytical and troubleshooting skills.
• Excellent communication and collaboration abilities.
• Ability to work in rotation shifts (7:00–16:00 or 10:00–19:00)
• B2 level minimum in French & English
• Team spirit and will to share knowledge.

Why Cronos Group?

We’ll propose you:

• An attractive salary package
• A good work-life balance environment
• The assurance of working in cutting-edge technologies in an entrepreneurial spirit.
• The opportunity to develop your skills thanks to tailor-made training courses according to your needs
• A good job in a friendly place

If you wish to integrate a dynamic structure on a human scale while working with the latest technologies, don't wait anymore and join Cronos!