Database Administrator DBA

Friday Media Group
Brighton, Brighton and Hove
£30000 - £35000/annum 25 + 8 days Holiday PA
14 Jul 2017
13 Aug 2017
Contract Type
Full Time

Friday Media Group, utilizes a number of database and search technologies. Primarily Percona MySQL however we also have investments in MariaDB, SQL Server, MongoDB and Solr.

The Database Administrator will work closely with the Data Manager to ensure that data and servers are available, monitored, optimized, updated and secured.

They will also be responsible for data integrity, making sure that the appropriate backups are in place and routinely verified.

They will play a key part in helping to develop and maintain best practices around database design, documentation, standards and database deployments.

Key Duties & Responsibilities:
:: Ensure availability of databases implemented across the Friday Media Group
:: Ensure that all automated and scheduled tasks complete successfully
:: Implement, document and monitor appropriate backup and restore verification procedures
:: Proactively monitor database and Solr servers for faults and decreases in performance, highlighting query or database inefficiencies to product owners, development and operations staff as necessary
:: Make recommendation of software patches and upgrades as they become available
:: Ensure that data integrity and security is maintained at all times
:: Translate user requirements into an appropriate report or data export/feed as required
:: Produce and maintain documentation about databases and disaster recovery procedures
:: Administer changes to production and development database servers and databases as required
:: Monitor and produce reporting on data growth in line with group data strategy
:: Implement data archive scripts as required in line with group data strategy
:: Be an escalation point for IT in troubleshooting database server issues.

Required Skills and Experience:
:: SQL
:: MySQL 5.5+, MariaDB or Percona
:: Linux
:: Performance Testing, Monitoring and Optimization

Any Experience of the Following Would be Beneficial:
:: Sharding
:: Clustering
:: Partitioning
:: MongoDB
:: DevOps
:: SQL Server
:: Solr/ Solrcloud
:: ETL
:: Data Migration

Generous Benefits Package:
:: 25 Days Holiday plus bank holidays
:: 37.5 hour working week
:: Company Pension Scheme
:: Discounted holiday accommodation in Wales and Spain