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
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:
- Conceptual data modelling
- Physical data modelling
- Data model normalization
- Entity-Attribute-Relationship design
Knowledge of ITIL processes for systematic management of complex IT environments
Only Eu Citizens