Open Source DBA — PostgreSQL and MySQL
Il y a 6 heures
Brussels, Brussels, Belgique
WLG
Temps plein
Gratuit avec email ou Google
Enregistrez cette offre et organisez votre recherche
Créez un compte gratuit pour enregistrer des offres d'emploi, créer des alertes et revenir à cette liste depuis votre tableau de bord.
Gratuit avec email ou Google
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.