SQL DBA - Nigel Wright Group : Job Details

The CompanyWe are working with a company who're building a technical team who'll be based out of a new office in Newcastle city centre. Supporting customers in financial services and wealth management sector this will be a demanding work environment,  The RoleBased in Newcastle city centre you'll join a newly established, highly skilled team supporting customers in financial services and wealth management. You'll be required to solve complex problems, working closely with a wider technical team and customer stakeholders.Core responsibilities are around database administration and will include;

• Database Management: Maintain on-premise and Azure SQL databases, including upgrades, high availability backup administration, monitoring, and optimization of DB servers and SQL/Procedures.
• Cloud Technologies: Work with Cloud Azure SQL Server, Data Lake, and related cloud data storage technologies.
• SQL Expertise: Demonstrate strong MS SQL knowledge, including the ability to interrogate data stores and schema, investigate results, and provide solutions to improve performance.
• Collaboration: Work with developers, support, and business teams to improve the use of SQL Server through better schemas and performant stored procedures, views, and functions.

The PersonCandidates will need to be capable of thriving in a fast-paced and intellectually demanding environment. The client are looking for excellent academics, A/B grades at A-levels and a 2.1 or better from a Russell Group university, in addition to some good commercial experience. Desired skills and experience;

• High Availability: Experience with Always-On and Basic Availability Groups.
• Backup and Restore: Knowledge of DB and transaction log backup and restore processes.
• Automation: Proficiency with PowerShell, including dbatools or SqlServer modules.
• Performance Optimisation: Ability to optimize SQL server performance.
• Maintenance: Experience with SQL Server Maintenance, including Agent Jobs and Monitoring.
• Configuration: Understanding of SQL server configuration.
• Advanced Features: Familiarity with partitioning, SQL snapshots, change data capture, and SAN arrays (Nimble preferred, PURE or others acceptable).

This role will require candidates to be based in the office, Newcastle city centre, 4-5 days per week so you will need to be based locally. The role comes with an excellent salary and benefits package as you would expect of one with such demanding requirements.