Database Administrator

Database Administration: performing day-to-day Database Administration tasks for various Database Management Systems including: MariaDB, PostgreSQL and others. The following tasks are to be performed: Database server deployment : installing, configuring, patching, upgrading Database Management systems, Database servers, Databases. 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…