Open Source DBA — PostgreSQL and MySQL (Replication, Tuning, RCA) for NATO with security clearance

WLG; Brussel; Sur place; EUR 60 000 - 90 000; Plein temps

Résumé du poste

WLG in Brussels is seeking a production DBA with strong PostgreSQL and MySQL experience to manage standalone and clustered deployments across development, test and live environments.

The role emphasizes tuning, replication, recovery, capacity planning and close coordination with application and infra teams to keep systems healthy and incidents minimal.

On-site, full-time in Brussels, you will restore from backups, analyse root causes, and produce post-incident reports to prevent recurrence.

Qualifications

• Production experience on PostgreSQL and MySQL.
• Experience with replication, clustering and recovery.
• Real query optimisation practice.
• Capacity planning and monitoring instincts.
• Coordination with application and infra teams.

Responsabilités

• Install, configure, maintain and upgrade PostgreSQL 12+ and MySQL 8+, standalone and clustered.
• Run routine maintenance properly — schema housekeeping, index maintenance, statistics, retention.
• Manage users, roles, privileges and authentication on least-privilege lines.
• Forecast storage growth and advise on partitioning and archiving before capacity becomes an incident.
• Troubleshoot production problems: data corruption, replication failures, performance degradation.
• Monitor database health — lock contention, deadlocks, wait events, replication lag, resource use.
• Analyse and optimise query performance, with execution plans and InnoDB tuning as everyday tools.
• Produce root cause analysis for critical incidents and keep environments consistent.

Connaissances

PostgreSQL

MySQL

Replication

Clustering

Query optimisation

Monitoring

Root cause analysis

Description du poste

This is a production DBA post on open source engines: PostgreSQL and MySQL, standalone and clustered, across development, test and live. It is the unglamorous half of database work — the half where replication lag, lock contention and a badly planned query decide whether anyone else can do their job today.

It suits someone who tunes rather than guesses, who has restored from backup in earnest, and who writes the root cause analysis afterwards because the next incident depends on it.

What You Would Be Doing

• Install, configure, maintain and upgrade PostgreSQL 12+ and MySQL 8+, standalone and clustered.
• Run routine maintenance properly — schema housekeeping, index maintenance, statistics, retention.
• Manage users, roles, privileges and authentication on least-privilege lines.
• Forecast storage growth and advise on partitioning and archiving before capacity becomes an incident.
• Troubleshoot production problems: data corruption, replication failures, performance degradation.
• Monitor database health — lock contention, deadlocks, wait events, replication lag, resource use.
• Analyse and optimise query performance, with execution plans and InnoDB tuning as everyday tools.
• Produce root cause analysis for critical incidents and keep environments consistent.

What you would bring

• Solid production experience on both PostgreSQL and MySQL.
• Replication, clustering and recovery experience that has been tested rather than documented.
• Real query optimisation practice on both engines.
• Capacity planning and monitoring instincts.
• The habit of coordinating with application and infrastructure teams rather than around them.

The work is full time on site in Brussels.