C005199 MySQL / PostgreSQL DBA (NS) - FRI 4 Sep

EMW, Inc.; Brussel; Sur place; EUR 90 000 - 120 000; Plein temps

Résumé du poste

EMW, Inc. in Brussels is seeking an experienced MySQL/PostgreSQL DBA for on-site operations. You will install, configure, and maintain standalone and clustered instances, manage backups, replication, and high availability, and ensure security and audit controls.

A NATO SECRET clearance is required, with duties spanning performance tuning and capacity planning. The role emphasizes cross-team coordination, RCA for incidents and robust lifecycle management, with a start date in October 2026 and an

Qualifications

• Active NATO SECRET security clearance.
• 5+ years hands-on experience with at least one DB technology (MySQL or PostgreSQL).
• 2+ years experience in the second DB technology (MySQL or PostgreSQL).
• MySQL architecture, InnoDB, backup tools like mysqldump, MySQL shell, Percona, XtraBackup.
• PostgreSQL internals, large datasets, autovacuum and index maintenance; WAL/archiving.
• SQL optimization, indexing and query execution plans.
• Strong Linux administration for database performance.
• Automation mindset: Bash/Python/Perl scripting.
• Security best practices: TLS, privilege management, audit/logging.

Responsabilités

• Install, configure, maintain and upgrade PostgreSQL 12+ and MySQL 8.0+ clusters.
• Perform routine maintenance including schema housekeeping and statistics updates.
• Manage users, roles, privileges, and authentication per least-privilege rules.
• Forecast storage growth and partitioning/archiving recommendations.
• Troubleshoot production issues: data corruption, replication, performance.
• Coordinate with application and infra teams; ensure environment consistency DEV/UAT/PROD.
• Perform RCA for critical incidents; implement backup/recovery strategies.

Connaissances

Database administration

SQL optimization

Performance tuning

Linux administration

Automation scripting

Outils

MySQL

PostgreSQL

Percona XtraBackup

pg_basebackup

Description du poste

Deadline Date: Friday 4 September 2026

Requirement: MySQL / PostgreSQL DBA

Location: Brussels, BE

Full Time On-Site: Yes

Time On-Site: 100%

Total Scope of the request (hours): 418

Required Start Date: 11 October 2026

End Contract Date: 31 December 2026

Required Security Clearance: NATO SECRET

Duties & Role:

Operational DBA Duties

• Install, configure, maintain and upgrade standalone and/or clustered instances: PostgreSQL 12+, MySQL 8.0+
• Perform routine maintenance (schema housekeeping, index maintenance, statistics updates, data retention support).
• Manage users, roles, privileges, and authentication methods according to least-privilege principles.
• Manage storage growth and capacity forecasting (disk usage, table growth trends, partitioning/archiving recommendations).
• Troubleshoot complex production issues including data corruption, replication failures and performance degradation
• Maintain environment consistency across DEV/UAT/PROD where applicable.
• Perform Root Cause Analysis (RCA) for critical incidents
• Coordinate with application and infrastructure teams

Advanced monitoring and performance tuning

• Monitor and analyse database health and performance metrics: Lock contention, deadlocks, wait events; Replication lag; Resource utilization (CPU, memory, I/O)
• Query performance analysis and optimization: o PostgreSQL: EXPLAIN (ANALYZE, BUFFERS); MySQL: Query optimization, execution plans, InnoDB tuning
• Index strategy design and maintenance
• Identification and remediation of locking, contention, and deadlocks
• Capacity planning and workload growth forecasting Implementation and management of backup and recovery strategies
• PostgreSQL: Physical backups (pg_basebackup); Logical backups (pg_dump, pg_dumpall); WAL archiving and Point-in-Time Recovery (PITR)
• MySQL: Logical and physical backups (mysqldump, MySQL shell, Percona, XtraBackup); Point-in-Time Recovery (binlog-based)
• Both Platforms: Backup strategy implementation and validation; Periodic backup and recovery testing

Design and operate High Availability & Disaster Recovery solutions

• PostgreSQL: Streaming replication (physical and logical); Synchronous and asynchronous replication
• MySQL: Asynchronous and semi-synchronous replication; High availability architectures (InnoDB Cluster, Group Replication)
• Both Platforms: Automated failover and switchover support; Disaster recovery documentation and runbooks

Enforce database security best practices

• Role-based access control and privilege management
• Authentication and password policy enforcement
• TLS/SSL encryption
• Audit logging and compliance support
• Security hardening and vulnerability remediation

Maintenance & Lifecycle Management

• Patch management and minor version upgrades
• Major version upgrade planning and execution
• Schema change review and deployment support
• End-of-life planning and platform recommendations

Skills, Knowledge & Experience:

• The candidate must have a currently active NATO SECRET security clearance
• 5+ years hands-on experience in at least one of the above database technologies (MySQL or PostgreSQL) and 2+ years of experience in the second database technology (MySQL or PostgreSQL)
• MySQL: Strong knowledge of MySQL architecture, storage engines (InnoDB); Hands-on experience with backup tools like mysqldump, MySQL shell, Percona, XtraBackup
• PostgreSQL: Deep understanding of PostgreSQL internals; Experience managing large datasets, storage growth, autovacuum and index maintenance; Experience with WAL and archiving; Experience managing PostgreSQL extensions
• Experience with SQL optimization, indexing, and query execution plans.
• Strong Linux administration skills (system resources, I/O, file systems, network basics) relevant to database performance.
• Knowledge of security best practices (TLS, privilege management, audit/logging, secure configuration).
• Automation mindset: experienced with scripting (Bash/Python/Perl).

Preferred/Advanced skills:

• MySQL: Experience with cloud-managed MySQL platforms (AWS RDS/Aurora, GCP Cloud SQL, Azure Database for MySQL); Familiarity with MySQL Shell, Orachestrator, ProxySQL or HAProxy
• PostgreSQL: Practical experience with pgvector; Knowledge of HNSW and IVFFlat indexes and their tuning parameters; Experience with containerized or Kubernetes-based database deployments; Understanding of pgvector upgrades and compatibility with PostgreSQL versions