Database Administrator MariaDB PostgreSQL
Database Administrator MariaDB PostgreSQL
Posted on :
26-12-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
26-12-2024
Job Description
- Database Administration: performing daytoday Database Administration tasks for Microsoft SQL Server databases as well as for other DBMSs including MariaDB PostgreSQL MongoDB and Cassandra Databases. The following tasks are within the context of these DBMSs:
- Database server deployment: installing configuring patching and upgrading Database servers Database Management systems and Databases.
- Virtual server configuration: configuring patching and upgrading virtual Servers and operating systems underlying the DBMSs including Microsoft Windows Server.
- Health monitoring: defining gathering and 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 and schedule database backup plans and strategy ensure restorability integrate Databaselevel backups with Operating Systemlevel backup systems like NetBackup and 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 meeting SLAs by configuring High Availability & Disaster Recovery defining implementing configuring and monitoring technologies including AlwaysOn Availability Groups and Windows Server Failover Clusters.
- Automation: define implement schedule and monitor scripts for the automation of repetitive recurring tasks using Powershell and Bash.
- DevOps: define create and implement DevOps pipelines for deploying database changes into production using AzureDevops FlyWay and 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 selfsufficiency in routine tasks.
- Assigned ticket handling: Promptly address incidents 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 :
- Bachelor plus 10 years of relevant experience.
- Working knowledge of English B2 or higher Common European Framework of Reference for Languages (selfassessment).
- A minimum of 8 years of experience as an ICT Consultant in largescale enterprise environments tasked with systems administration of missioncritical production systems
- A minimum of 6 years of experience in Database Administration with sensitive data in complex highsecurity environments
- A minimum of 5 years of experience in Database Administration with the following tools and technologies: MariaDB and/or MySQL MySql Workbench maria backup mysqlbinlog
- A minimum of 5 years of experience in Database Administration with the following technologies: PostgreSQL pgAdmin pgBackRest Patroni
Desirable:
- A minimum of 3 years of experience in Database Administration with technologies for: High Availability and Disaster Recovery Clustering solutions Data replication Galera MaxScale WSFC
- Experience in Database Administration with the following technologies: MongoDB Cassandra
- Experience in working with the following technologies: VMWare virtualization Containerization with Kubernetes
- Experience in Database Administration with the following technologies: Microsoft SQL Server AlwaysOn Availability Groups
- Experience in working with tools and technologies for the implementation of Business Intelligence solutions including ETL OLAP Reporting
- Experience in Database Administration with all mentioned DBMSs and technologies: for onpremise 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 :
Fulltime
Employment Type
Full-time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
