Database Engineer / SQL Server Developer

Location: Warrington or Stockton-on-Tees (Hybrid) Security Clearance: Must be eligible for BPSS / SC Clearance IR35: Inside Duration: 12 Month Contract Role Description To design, develop, implement and test database server solutions using Microsoft SQL Server (or similar) integrated within PLC/SCADA-based control systems. Producing high-quality and comprehensive engineering design documentation and undertaking activities such as: • Requirements capture and traceability documentation (URS/RTM) • System /Functional Design Specifications (SDD/FDS) • Detailed Software System Specifications (SSS) • Test Specifications (Module/Integration/System/Hardware) • Support Operation& Maintenance Manuals (O&M), including Database Management Instructions/Guidance. • System Rebuild Documentation • Supporting project LifeTime Records of design documentation etc. In addition to the above, the role shall support the Lead Engineer and Project Manager in maintaining the planned delivery schedule, reporting technical issues, changes in scope and variations to the programmed activities where necessary. Work with database management systems, programming languages like SQL and Python, collaborating with other disciplines, to create and administer database structures to meet specific client and system requirements. Ensure efficient data access and retrieval through proper indexing, query optimisation and database tuning. Implementing measures to maintain data accuracy, consistency, and security, including secure access controls and backup/recovery procedures. Work closely with PLC and SCADA engineers to develop and test a fully integrated control system, producing Network Architecture Diagrams and associated interfacing design and test documentation. Identifying and resolving server and database-related issues, ensuring high availability and minimal downtime of hardware and applications. Undertake in-house acceptance testing in a formal, controlled manner of the integrated control system, ensuring change control management is maintained and recorded. Site acceptance testing support (commissioning) may also be required. Experience and Qualifications Essential experience: • Significant experience in creating and implementing database structures, preferably within a PLC/SCADA control system design. • Experienced in the deployment of servers, VMWare and OS configurations in large-scale networked infrastructures. • Proficient in programming and scripting using Microsoft SQL, MySQL Oracle, SQL Server and/or Python. • Strong programming skills for data manipulation, automation and visualisation. • Strong understanding of database concepts, data modelling and indexing. • Strong analytical skills with the ability to diagnose and resolve database issues effectively and efficiently. • Experienced in data migrations, data archiving/backup and recovery procedures. • Experienced in producing database design and logical structure diagrams, such as Entity Relationship Diagrams, database functional specifications and formal Test Specifications to a high-quality level. • Experience in undertaking formal and controlled testing and validation activities, including change management during such activities. • Ability to work as part of an Integrated Delivery Team or individually, working within sometimes restrictive time constraints. • Demonstrate excellent written and verbal communication skills. • Proficient in Microsoft Office with strong technical documentation writing skills. • Have strong interpersonal skills and be able to interact with people at all levels, including customer stakeholders. Desirable experience: • Demonstrable experience in the EC&I industry or highly regulated industries, such as Nuclear, MOD or Pharmaceutical. • Experience with cloud-based platforms such as GCP, AWS or Azure. • Experienced in database clustering, load-balancing and redundancy. • Familiar with integrated SCADA control system applications. • Experience with OT Cyber Security and the development of cyber secure designs. • Experience in delivering in accordance with Sellafield Ltd Mgmt. System (V-Model). • Awareness and understanding of Sellafield Engineering Standards. Essential qualifications: • A Bachelor's Degree in Software or related field, or demonstrable evidence of experience with a high emphasis on EC&I engineering using databases. Desirable qualifications: • Member of a relevant professional institution. • Certified training on SQL-related courses. • Certified Cyber Security training.