Database Administrator

Almaviva Group; Den Haag; On-site; EUR 90,000 - 130,000; Full time

Job summary

Almaviva Group seeks an experienced database administrator to design, install, and manage enterprise databases in virtualized and containerized environments. You will ensure security, perform health monitoring, backups, and disaster recovery, and drive CI/CD release processes for database changes.

Responsibilities include incident management, performance tuning, and maintaining data integrity across on-premise, air-gapped infrastructures, using tools such as Kubernetes, VMware, SCOM, and

Qualifications

• Minimum 11 years of IT experience.

Responsibilities

• Database administration in virtualized environments (VMWare).
• Containerized DB administration with Kubernetes.
• Enforce data security and access policies.
• Incident management and resolution using ITSM tools.
• Plan and validate releases for production databases.
• Health monitoring and performance optimization.
• Backup, recovery and data retention planning.
• High availability and disaster recovery configurations.

Skills

ITIL

DevOps

Data modelling

Backup/DR planning

Security management

Performance tuning

Incident management

Automation scripting

Tools

VMware

Linux (RedHat/CentOS)

Kubernetes

SCOM

SolarWinds DPA

NetBackup

Galera/MaxScale/Data Replication

Puppet

Azure DevOps

Flyway

Job description

The ideal candidate will be responsible for creating, installing and managing our databases. You Job description

Database administration in Virtualized environments: database administration in virtual environments, e.g. VMWare, and virtual machine administration of operating systems underlying the DBMSs, including Linux RedHat, CentOS.

Database administration in Containerized environments: database administration in containerized environments including Kubernetes

Security management: Enforce data security and data protection policies by managing security and database access, identifying and auditing user access of sensitive databases in compliance with procedures and regulations.

Incident management: follow structured processes for rapidly detecting, diagnosing, and resolving service disruptions to restore availability and ensure data integrity. Manage incidents using ITSM tools, e.g. ServiceNow

Change and Release management: follow controlled processes for planning and validation for deploying releases of new database systems or changes to existing database into (pre-)production environments, minimizing downtime and preventing data loss.

Health monitoring: defining, gathering, managing metrics for monitoring databases, operating systems and servers to ensure systems remain healthy; checking error logs, system events, database events, disk space and storage events use monitoring tools including SCOM to identify, prevent and resolve issues.

Database maintenance: installing, configuring, scheduling, monitoring Database Jobs for Backups, Integrity checks, Index maintenance, Update Statistics, etc.

Backup and recovery: define, create, schedule database backup plans and strategy, ensure restorability, integrate Database-level backups with Operating System-level backup systems like NetBackup, manage Data Retention.

Performance monitoring, tuning, and optimization: define and gather critical performance metrics for DBMSs and OSs to ensure fast database performance using tools like SolarWinds DPA; assess data access patterns and query plans for improving performance by tuning and optimizing database queries.

Business Continuity: ensure to meet SLAs by configuring High Availability & Disaster Recovery, defining, implementing, configuring, monitoring technologies including Galera, MaxScale, and Data Replication.

DevOps: define, create, implement DevOps pipelines for deploying database changes into production using Puppet, AzureDevops, FlyWay.

Automation: define, implement, schedule, monitor scripts for automation of repetitive, recurring tasks using Bash, Puppet, Python, Powershell, etc.

Data modelling: design, reverse engineer, document conceptual and physical database models and define and update standard operating procedures.

REQUIREMENTS:

Mininum 11 years of IT experience

A minimum of 6 years of experience in Database Administration of mission critical production databases with sensitive data in high-security environments

A minimum of 5 years of experience in Database Administration with the following tools and technologies: MariaDB (or MySQL)

A minimum of 5 years of experience with the following technologies: PostgreSQL

A minimum of 2 years experience in Database Administration with Kubernetes

Above mentioned experiences must be in environments: On-premise, air-gapped

Knowledge of methodologies for:

Knowledge of ITIL processes for systematic management of complex IT environments