Database Administrator

Blackfluo.ai; Paris; À distance; EUR 45 000 - 70 000; Plein temps

Résumé du poste

A technology firm is seeking a Database Administrator responsible for the health, security, and performance of multiple databases. The ideal candidate will have extensive experience in database administration, strong understanding of cloud services, and skills in scripting and automation. This role involves supporting infrastructure, managing backups, and ensuring data integrity.

Qualifications

• Extensive experience in database administration, including upgrades and patching.
• Good understanding of cloud services like Oracle OCI, AWS, Azure, and GCP.
• Experience with automation of database administration activities.

Responsabilités

• Ensure overall health and performance of databases.
• Design, install, configure, and support database infrastructure.
• Implement backups and monitoring.

Connaissances

Database administration

Cloud services understanding

Scripting skills

Automation technologies

Troubleshooting

Performance tuning

Outils

Oracle

MS SQL Server

Postgres

MySQL

Ansible

Description du poste

Overview

Location: Fully remote, Central Europe Time Zone

Languages: English is mandatory

The Database Administrator (DBA) is responsible for the overall health, security, and performance of databases, including tasks like database design, implementation, maintenance, backup, recovery, and security, while also ensuring data integrity and user access control.

This position covers multiple database technologies such as Oracle, MS SQL Server, Postgres, MySQL, and other open databases.

Duties and Responsibilities

• Provide support for all Database Hosting SDAs
• Design, install, configure and support database infrastructure
• Administer and support database systems including storage provisioning, VM provisioning, patching and upgrading
• Implement backups, standby databases and monitoring
• Assist in the design, development, implementation and maintenance of database automation tasks using Ansible or any other automation tool
• Provide support for setup/architecture including setup of monitoring, alerting and scripts/interfaces to Help Desk systems
• Manage NAS/LUNs for use with relational databases and related systems
• Co-ordinate with Vendor Database Support for resolution of problems and incidents related to databases
• Perform troubleshooting and performance tuning activities as required
• Apply database patches, updates and perform upgrades
• Assist in the planning and running of disaster recovery tests
• Perform capacity management and reporting as required
• Produce documentation as required
• Perform support activities during planned maintenance windows outside of normal working hours

Junior Database Administrator

• Participating in database testing and validation activities.
• Supporting backup, replication, restoration and performance tuning tasks.
• Providing first-level user support and troubleshooting basic issues.
• Learning and developing expertise in database technologies.
• Assist in automation of routine DBA tasks.

Database Administrator

• Run disaster recovery and validation tests
• Ensure availability and security of all databases.
• Implement backup/replication of databases.
• Undertake performance tuning tasks to ensure optimal performance of databases.
• Implement, patch and upgrade all databases in coordination with database service users.
• Implement and maintain database automation routines
• Providing guidance to junior team members.

Senior Database Administrator

• Lead DBA initiatives for improving all aspects of the database service.
• Design and implement database security policies.
• Design and implement database backup, replication and restoration solutions.
• Plan, coordinate and execute database implementations, patching and upgrades.
• Coordinate database activities with junior team members.
• Provide guidance to junior team members.

Required Qualifications & Experience

• Extensive Database administration experience, including upgrades and patching
• Good understanding of one or more cloud services - Oracle (OCI), Amazon (AWS), Microsoft (Azure), Google (GCP), etc.
• Familiar with Cloud products such as Oracle Database Cloud, Oracle Exadata Cloud, Oracle
• Integration Cloud, Azure SQL database, Azure SQL Managed Instance and AWS RDS, etc.
• Extensive knowledge and support experience in three or more of the following products:
  • Oracle Exadata
  • Oracle Real Application Clusters (RAC)
  • Oracle DataGuard
  • Oracle RMAN
  • High availability solutions including SQL Server Always On technology
  • Failover Clustering (FCI), and Availability Groups (AG).
  • Disaster recovery technologies including database mirroring and transaction log shipping.
  • SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), and Master Data Services.
  • Latest version of Oracle Enterprise Manager including installation, configuration, patching and upgrading
  • SQL Server Replication technology including snapshot, merge and transactional replications.
  • Database recovery procedures including the ability to recover user and system databases from failed processes and engine crashes.
• Experience in automating database administration activities
• Good scripting skills using Linux shell, PowerShell, Oracle, Transact-SQL and/or other automation tools
• Experience with service management systems (ServiceNow or similar) and collaboration tools
• Experience in integrating with Oracle Cloud products such as Oracle
• Oracle OVM administration and support on Exadata
• Networking configuration on Exadata
• Oracle Enterprise Linux or RedHat Linux administration and support
• Oracle Direct-NFS experience
• Experience with Ansible or other automation technologies
• Experience with NetApp NAS (or similar) hosting Oracle databases
• Experience data storage virtualization technologies.
• Experience with Windows failover clusters.
• Experience with MySQL replication.
• Experience with Ansible or other automation technologies.