Senior Database Administrator (MariaDB PostgreSQL)

at  Avenga x Qinshift

THIS IS US

Qinshift and Avenga merge together to start a new era of technology that matters. Leveraging the power of innovations, we are on a journey to shape the future of work, and we are inviting you to co-create it with us.

THIS IS THE JOB

In The Hague, Netherlands within the Law enforcement industry, we are actively seeking a professional to strengthen our team dedicated to ICT Operations and Infrastructure.

• Database Administration: performing day-to-day Database Administration tasks for Microsoft SQL Server databases as well as for other DBMSs including MariaDB, PostgreSQL, MongoDB and Cassandra Databases.
• 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, Bash.
• DevOps: define, create, implement DevOps pipelines for deploying database changes into production using AzureDevops, FlyWay, Puppet.
• Data modelling: 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.
  We take pride in the diverse skills and character of our teams, welcoming everyone to apply and contribute to our collective strength