SQL DBA | 6 Month Contract | (Outside IR35) | Hybrid, Edinburgh| Starting ASAP
Day Rate: £DOE
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
Other Duties:
- To work closely with business users and information systems development stakeholders in order to provide Database specifications in reference to storage, Capacity and planning.
- DBA Maintenance using replication techniques, availability and disaster Recovery
- Perform upgrades, migration and patching
- Monitor Database performance and troubleshoot issues such as job failures and Index fragmentation
- Maintain Database Security including Creation of Users and groups
- Perform quality assurance of data solutions provided by external suppliers
- Sets standards for database administration, ensuring that procedures exist and are followed
- Plan for backup and recovery of database information, ensuring backup is carried out as per plans, planning and managing exercises to prove recovery procedures. Ensure that recovery plans are tested regularly. Implements recovery procedures when necessary
- Manage database resources, including allocation of system storage. Plan for future storage requirements, and prepare cases for additional resources
- Ensure that database problems are investigated, diagnosed and resolved, referring to database users, other staff and suppliers as necessary.
- Bring existing operational SQL under SCM source control, managing its acceptance through the engineering pipeline
- Support engineering and release colleagues in ensuring changes are successfully deployed to live, acting as point of contact on releases with database facing changes
- Carry out full impact analysis of new software releases and recommend upgrade plans. Review upgrades and fixes available from system software suppliers and identify those which merit action.
- Design and develop user code to enhance or customise system software to satisfy business objectives and tailor system software to ensure maximum efficiency. Prepare software implementation procedures with fall back contingency plans. Ensure that new versions of system software are properly installed and thoroughly tested.
Essential Skills
- 5yrs + experience of InnoDB in MySQL or MariaDB
- Working knowledge of AWS data storage solutions, e.g. Aurora, RDS, DynamoDB
- 5yrs + 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
- Experience of working with wider engineering function to design and suggest improvements to new or existing services
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
This role has been deemed Outside IR35 by the client. Applicants must hold, or be happy to apply for, a valid Basic Disclosure Scotland. Please click the link to apply.
