DBA - Edinburgh

IT roles
Ref: 131 Date Posted: Tuesday 24 Nov 2020
LinkedIn ShareShare
More

As a member of the Information Systems team, the DBA is part of a key group of dedicated in-house developers maintaining applications that both deliver and integrate many of the core business functions. Information Systems are responsible for everything from the entire back-end and integration of systems, to front-end interfaces including customer facing websites and tools.

 

The DBA will have ownership over the backend database (currently MySQL, future SQL Server) and data transfer layers, working to deliver outcomes using waterfall and agile methodologies while interacting with many parts of the business.

 

Key Responsibilities:

 

  • Ownership of existing databases. Ownership of the project to migrate the database to a more robust platform
  • Management of the existing database cluster, backups and development databases
  • Regular verification of onsite and offsite backups. Regular verification of cluster resilience due to node failure or Data centre failure
  • Ensure data integrity through design of the database and reporting of anomalies
  • Manage the change process for enhancements to the database, ensuring documented, tested, peer reviewed scripts are used
  • Enhance existing performance of the database and ensure efficiency in future changes. Troubleshoot and optimise the performance in any areas of concern
  • Assist in business requirements gathering and propose solutions for all data collection, transfer and data interfaces

 

Skills & Experience

 

  • Considerable experience as a DBA in the IT / Technology sector.
  • Considerable experience of running databases in a commercial environment.
  • Database and data warehouse design experience
  • Experience working with multiple programming languages.
  • Experience working with multiple database environments.

Database

  • MariaDB / MySQL
  • SQL Server

Database Management

  • Clustering (MMM, Galera)
  • Backups
  • Veeam

Reporting

  • PowerBI