SQL DBA ON SITE, HYBRID, DERBY The successful candidate must be a sole British national and eligible to gain SC clearance The successful candidate will join a highly skilled team of project delivery engineers responsible for delivery of complex projects across multiple secure clients. The role will require a flexible working ethic and a pragmatic approach to IT project delivery. Successful candidates will have experience in the delivery of infrastructure projects along with a broad understanding across a range of capabilities. They will have a keen interest in innovation combined with a willingness to implement new ways of working and automation. This role predominantly requires an in-depth knowledge of the implementation of SQL technologies. Role responsibilities: Designs database activity and file usage and ensures necessary resources are present. Determines data to be collected and analyse information as appropriate. Builds for operations to ensure high quality performance of databases post implementation by considering informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases. Recommends and implements tuning opportunities to improve system response and run times. Defines logical attributes and data inter-relationships and designs complex data structures to accommodate database production implementation, storage, maintenance, and accessibility to enhance performance. Optimises database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. Implements automation to limit database accessibility based upon information security level and ensures data spillage from more secure to less secure databases do not occur. Implements database security regulations, policies, and guidelines. Proactively monitors security bulletins to obtain information of potential threats for consideration in new services. Plans and installs first-of-type upgrades of database management systems (DBMS) software as necessary to enhance database performance. Research various hardware and software products; recommends solutions and implements approved products. Functions as a technical complex project leader for our portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment. Assists project managers and Scrum teams in the development of project plans including detailed project estimates and tasks required for database activities. Utilises standard corporate tools to record change and problem activities for tracking purposes. Integrates databases and commercial of the shelf software; resolves conflicts between databases and of the shelf software, operating systems, and open-source applications. Designs and tests database installation, implementation, and recovery scenarios. Determines test to use and collects appropriate data according to established guidelines. Participates in analysis, development, and implementation of unique database recovery plans in response to client-impacting outages. Essential Knowledge and Skills Required: SQL Server 2008R2 2022 Transact SQL Processing Language Stored Procedure Development Transaction Processing Configuration and Security Maintenance Reporting Services Data Warehousing Desirable skills and knowledge/certifications Strong programming skills for database management and general software Great communication skills Ability to work in a team environment. Ability to anticipate problems and take decisive action. Education and Experience required: 5 years experience working in DB environment with a least 2 years in a project delivery role. Must have analytical skills and be able to solve technical problems across different platforms.