Job Title: Mid:level / Senior SQL Server DBA
Location: Completely Remote role, can be Located anywhere in the UK
Salary: GBP50k : GBP65k per annum Depending on Experience, 26 days annual leave, 10 pension contribution, Life Insurance.
Were proud to be a trusted leader in database administration managed services. Our expertise keeps some of the nations most recognisable household brands running smoothly, securely, and efficiently. At the heart of everything we do is a passion for solving complex challenges, ensuring our clients stay connected, supported, and ready for the future. The Mid / Senior SQL Server DBA will be responsible for ensuring the performance, security, and effective administration of client databases.
Principal Accountabilities:
* Configure and maintain a range of client environments including monitoring system health and proactively managing performance to ensure high levels of performance, availability and security.
* Extensive experience managing SQL Server Infrastructure
* Understand the needs of multiple clients and their users.
* Combine high customer service standards with a strong commercial awareness.
* Take a proactive approach to assessing clients current and future requirements, providing advice and recommendations to clients technical teams and promoting additional WellData services.
* Represent WellData in a technical role in discussion with clients as needed, with the confidence to lead technical meetings where appropriate.
* Install, upgrade and manage database applications.
* Undertake performance tuning of databases
* Develop processes for database security.
* Optimise performance and mitigate risk.
* Diagnose and troubleshoot database errors.
* Refine and automate regular processes.
* Perform scheduled maintenance and release deployment activities after:hours.
* Reviewing database architectures and provide guidance on implementing best practice
* Hands on experience of monitoring SQL Server
* Research into areas of technical interest and support colleagues by documenting and sharing technical know:how and providing advice and guidance to peers and helping to train and mentor colleagues.
* Track issues and record and document work undertaken
* Take part in an on:call rota to provide 24/7 on:call support as needed to any WellData client.
Knowledge and experience:
* Expert understanding of the principles of database design and maintenance.
* Expert knowledge and extensive experience of database technologies.
* Proven ability to fully administer critical and complex database environments.
* Extensive knowledge of security and database maintenance with experience of monitoring, troubleshooting and resolving database issues.
Experience in database installation, back:up, restore and maintenance including extensive practical experience of the following:
* Database back:ups, restores and recovery models
* Management of database access and security
* Database performance tuning and maintenance : identifying performance bottlenecks and index tuning
* Configuring and troubleshooting Replication
* Proficient in T:SQL and PowerShell scripting (desirable)
* Experience with SQL Server high availability and provisioning and configuring : highlight availability groups, log shipping, failover clustering, mirroring
* Knowledge of hardware and server configuration
* Experience with cloud platform technologies (Azure, AWS)
* Good knowledge of IaaS, PaaS and Managed instance database offerings
* Hands on experience with database migrations : on premise and into the cloud
* Experience with other database technologies e.g. PostgreSQL, Oracle, MySQL
Qualifications:
Relevant certifications (e.g. Microsoft, Oracle etc) : desirable but not a requirement.
Skills:
* Excellent planning and organisational skills with the ability to work on own initiative and organise own work at an operational level and deliver work