At a Glance
- Tasks: Design and develop database solutions using SQL Server for innovative control systems.
- Company: Join a leading tech firm focused on cutting-edge engineering solutions.
- Benefits: Enjoy competitive pay, hybrid work options, and opportunities for professional growth.
- Other info: Collaborative environment with potential for career advancement in a dynamic field.
- Why this job: Make an impact in the tech industry while working with advanced database technologies.
- Qualifications: Experience in SQL and database management; strong analytical and communication skills.
The predicted salary is between 38250 - 46750 £ per year.
Location
Warrington or Stockton-on-Tees (Hybrid)
Security Clearance
- Must be eligible for BPSS / SC Clearance
- 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 Life Time 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
- 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, My SQL 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.
- 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.
- A Bachelor's Degree in Software or related field, or demonstrable evidence of experience with a high emphasis on EC&I engineering using databases.
- Member of a relevant professional institution.
- Certified training on SQL-related courses.
- #J-18808-Ljbffr
Database Engineer / SQL Server Developer in Warrington employer: First Recruitment Group
First Recruitment Group is an exceptional employer, offering a dynamic work culture that fosters collaboration and innovation in the clean water sector. Located in Peterborough, employees benefit from a supportive environment that prioritises professional growth and development, alongside competitive remuneration and benefits. Join us to make a meaningful impact on vital infrastructure projects while advancing your career in a thriving industry.
