RMM Consulting Group

For our client – An International Institution we are looking for DBA – Home office

Freelance Opportunity, (B2B), Long term contract, Attractive daily RATE

Location: Home Office / The Hague

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