Sql Dba
Posted 1 day ago by 1769250909
Negotiable
Outside
Hybrid
Edinburgh
Summary: The SQL DBA role is a 6-month contract position based in Edinburgh, requiring expertise in database administration and performance management. The successful candidate will collaborate with engineering teams to design schemas, monitor database performance, and implement improvements. This position is classified as outside IR35 and offers a hybrid working arrangement, starting as soon as possible. The role demands a strong background in MySQL or MariaDB, along with experience in AWS data storage solutions.
Key Responsibilities:
- 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
- Monitor, diagnose and remediate database related issues
- 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
- Maintain Database Security including creation of users and groups
- Perform quality assurance of data solutions provided by external suppliers
- Set standards for database administration and ensure procedures are followed
- Plan for backup and recovery of database information
- Manage database resources and plan for future storage requirements
- Investigate, diagnose and resolve database problems
- Bring existing operational SQL under SCM source control
- Support engineering and release colleagues in ensuring successful deployments
- Carry out full impact analysis of new software releases and recommend upgrade plans
- Design and develop user code to enhance or customize system software
Key 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
- Demonstrable experience of creating and reviewing SQL as part of a SCM-backed development lifecycle
- Demonstrable experience of database, table, index, constraints schema creation
- Demonstrable experience of creating Stored Procedures and Functions
- Experience of working with wider engineering function to design improvements
Salary (Rate): undetermined
City: Edinburgh
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
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.