MySQL DBA - Percona Server, Percona Xtrabackup, Percona Toolkit

Recruiter
Anonymous
Location
Somerset, UK
Salary
Competitive
Posted
20 May 2019
Closes
28 May 2019
Ref
1148420110
Contract Type
Permanent
Hours
Full Time
MySQL DBA - Percona Server, Percona Xtrabackup, Percona Toolkit, Bash, Amazon RDS, Amazon Aurora, Amazon CLI, Red Hat Cluster

My client, a leader in their field are looking to take on a MySQL DBA on an initial 3 month contract with an extremely strong likelihood of extension thereafter paying up to £495 per day on an OUTSIDE IR35 basis in Somerset with 1 day per week working from home.

You will work together with developers, devops and sysops to help maintain database availability and deliver smooth and quick shopping experience for our online customers.

You should be experienced with backup and restore procedures using Percona Xtrabackup.

You should possess knowledge how to tackle slow queries, aware of impact of the indexes and other DDL commands.

You should be familiar with Amazon RDS and Amazon Aurora and migrating into the cloud.

Responsibilities:

l Maintain production, staging and test database servers

l Verify databases changes for each release and estimate time required to execute them

l Optimize and validate and adjust MySQL configuration

l Collect, aggregate, report and provide advice on slow queries

l Apply indexes to prevent full table scans (covering, composite)

l Find and advice on referendum not used indexes

l Backup and restore of MySQL using Percona Xtrabackup (compressed, streamed)

l Run multiple MySQL instances on the same server.

Must have:

l Good knowledge of MySQL 5.6

l Comfortable with managing and updating all indexes types (primary, unique, secondary, covering, composite)

l Percona Server

l Percona Xtrabackup (backup, restore, compress, xbstream, qpcrybt)

l Percona Toolkit

l Bash scripting

l Stored procedures

l Query execution plans

l Red Hat

Nice to have:

l Amazon RDS

l Amazon Aurora

l Amazon CLI

l Red Hat Cluster

If you meet the above requirements and would like to find out more please apply with your up to date CV ASAP as they are looking to move very quickly with this opportunity.

MySQL DBA - Percona Server, Percona Xtrabackup, Percona Toolkit, Bash, Amazon RDS, Amazon Aurora, Amazon CLI, Red Hat Cluster

Similar jobs

Similar jobs