Database Administrator

Database Administrator Glasgow Outside IR35 Our Public Sector client is looking for a Database Administrator to join the team on an initial 6-month basis.

Main Duties:

• Work closely with engineering teams and stakeholders to design schemas
• Monitor, diagnose and remediate query performance issues
• Peer-review operational SQL and propose and implement improved operational mechanisms - e.g. where SQL can be parameterised and moved to a Stored Procedure
• Monitor, diagnose and remediate database related issues

Essential Skills,

• Experience of InnoDB in MySQL or MariaDB
• Working knowledge of AWS data storage solutions, e.g. Aurora, RDS, DynamoDB
• 3yrs + experience of performance management and tuning, with regards to database schemas, indexes and SQL queries
• Demonstrable experience of creating and reviewing SQL as part of a SCM-backed development lifecycle
• Demonstrable experience of database, table, index, constraints schema creation and lifecycle Demonstrable experience of creating Stored Procedures and Functions

Desirable Skills

• Oracle experience
• Designing high availability solutions
• Backup and restore procedures and strategy
• Experience of data migration within secure environments
• Experience of working methods within change controlled environment
• Experience of configuring and installing database instances on different operating systems

We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation, gender reassignment, marriage and civil partnerships, pregnancy or maternity or age