ASA Recruitment’s client, a Public Sector organisation in Glasgow, are currently looking to recruit a DBA on a hybrid basis, for an initial 6 month contract (with potential extensions) on a rate of up to £572/day outside of IR35 (based on experience).
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 – e.g. where SQL can be parameterised and moved to a Stored Procedure
* Monitor, diagnose and remediate database related issues
* 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 Experience
* 5 yrs + experience of InnoDB in MySQL or MariaDB
* Working knowledge of AWS data storage solutions, e.g. Aurora, RDS, DynamoDB
* 5 yrs + 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
YOU SEEK WE FIND
#J-18808-Ljbffr