Database Engineer / Administrator
Database Engineer / Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Database Administration: performing day-to-day Database Administration tasks for Microsoft SQL Server databases as well as for other DBMSs including MariaDB MySQL PostgreSQL and other.
The following tasks are within the context of these DBMSs:
- Database server deployment: 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.
- 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.
- 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 AlwaysOn Availability Groups and Windows Server Failover Clusters.
- Automation: define implement schedule monitor scripts for automation of repetitive recurring tasks using Powershell etc.
- DevOps: define create implement DevOps pipelines for deploying database changes into production using AzureDevops FlyWay etc.
- Data modelling: design reverse engineer document conceptual and physical database models and define and update standard operating procedures.
- Change management: implement database Changes and Releases into production and other environments in compliance with standards and procedures.
- Coordination: Coordinate and/or participate with multiple teams to coordinate activities from Development Architecture Applications Security Networks and Service Management in case of troubleshooting and problem resolution.
- Communication: communicate opposing views to stakeholders and facilitate compromise solutions display and enable teamwork.
- Training and Knowledge Transfer: Provide technical training or knowledge transfer to internal teams ensuring smooth handovers and self-sufficiency in routine tasks.
- Assigned ticket handling: Promptly address incident and change tickets assigned through the ITSM tool ensuring they are handled immediately upon assignment. This includes following up prioritizing tasks and resolving them within the established timeframes and according to SLAs.
Qualifications :
Mandatory:
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:
- Microsoft SQL Server Standard & Enterprise Edition
- Experience with a wide range of versions of the DBMS from v2008 until v2022
- Azure SQL Database Azure SQL Managed Instance
- Business Intelligence: OLAP Cubes (SSAS) ETL (SSIS) Reporting (SSRS PowerBI)
Minimum of 5 years of experience in Database Administration with the following technologies:
- Business continuity High Availability Disaster Recovery
- AlwaysOn Availability Groups
- Windows Server Failover Clustering
Desirable:
A minimum of 3 years of experience in Database Administration with technologies for:
- PostgreSQL
- MariaDB and/or MySQL
- Associated database administration tools e.g. pgAdmin MySqlWorkbench
Experience in Database Administration with the following technologies:
- MongoDB
- Cassandra
- Neo4J
Experience in working with the following technologies:
- VMWare virtualization
- Containerization with Kubernetes
Experience in Database Administration with the following technologies:
- PostgreSQL HA&DR solutions
- Streaming replication Patroni Etcd HAProxy
Experience in Database Administration with the following technologies for:
- MariaDB HA&DR solution
- Galera Clustering MaxScale
- Load balancing data replication failover
Experience in Database Administration with all mentioned DBMSs and technologies:
- for on-premise environments
Experience in the development of scripts and solutions for:
- DevOps pipelines
- Automated Deployment
- Database schema versioning and deployment
- Puppet AzureDevOps/TFS FlyWay
- Bash Powershell TerraForm
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time
