Database Administrator

Role: Database Administrator (MariaDB, PostgreSQL)

Your Tasks

• Installing, configuring, patching, upgrading Database servers, Database Management systems, Databases;
• Virtual server configuration: configuring, patching, upgrading virtual Servers and operating systems underlying the DBMSs, including Microsoft Windows Server;
• 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;
• 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;
• Installing, configuring, scheduling, monitoring Database Jobs for Backups, Integrity checks, Index maintenance, Update Statistics, etc;
• 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;
• 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;
• Ensure to meet SLAs by configuring High Availability & Disaster Recovery, defining, implementing, configuring, monitoring technologies including AlwaysOn Availability Groups and Windows Server Failover Clusters;
• Define, implement, schedule, monitor scripts for automation of repetitive, recurring tasks using Powershell, Bash;
• Define, create, implement DevOps pipelines for deploying database changes into production using AzureDevops, FlyWay, Puppet;
• Implement database Changes and Releases into production and other environments, in compliance with standards and procedures;
• Adress incident and change tickets assigned through the ITSM tool, ensuring they are handled immediately upon assignment.

Requirements

• University Degree and more than 10 years of IT professional experience;
• Minimum of 8 years of experience as an ICT Consultant in large scale enterprise environments, tasked with systems administration of mission critical production systems;
• Minimum of 6 years of experience in Database Administration with sensitive data in complex high-security environments;
• Minimum of 5 years of experience in Database Administration with the following tools and technologies: MariaDB and / or MySQL, MySQL Workbench, mariabackup, mysqlbinlog;
• Minimum of 5 years of experience in Database Administration with the following technologies: PostgreSQL, pgAdmin, pgBackRest, Patroni;
• Knowledge of methodologies for: Conceptual data modelling, Physical data modelling, Data model normalization, Entity-Attribute-Relationship diagramming;
• Knowledge in Database Administration with the following tools and technologies: MariaDB and/or MongoDB and/or Cassandra Databases, mariabackup, mysqlbinlog;
• Knowledge of complex enterprise architectures and advanced ICT Solution designs, including Micro Services;
• Knowledge of ITIL processes for systematic management of complex IT environments;
• Excellent command of the English language.