Senior Lead Database Engineer

Senior Lead Database Engineer

Posted 2 weeks ago by Millbank Holdings

Negotiable
Undetermined
Undetermined
Warrington

Summary: The role of Senior Lead Database Engineer involves designing, developing, implementing, and testing database server solutions within PLC/SCADA control systems, particularly in a highly regulated environment such as nuclear consultancy. The position requires collaboration with various engineering disciplines to ensure efficient data management and system integration. The engineer will also be responsible for producing comprehensive documentation and supporting project delivery schedules. This opportunity is ideal for candidates with significant database experience and a strong background in EC&I engineering.

Key Responsibilities:

  • Design, develop, implement, and test database server solutions using Microsoft SQL Server or similar.
  • Produce high-quality engineering design documentation including requirements capture, system specifications, and test specifications.
  • Support operation and maintenance manuals and database management instructions.
  • Collaborate with PLC and SCADA engineers to develop and test integrated control systems.
  • Ensure efficient data access and retrieval through indexing, query optimization, and database tuning.
  • Identify and resolve server and database-related issues to ensure high availability.
  • Conduct in-house acceptance testing and support site acceptance testing.

Key Skills:

  • Bachelor's Degree in Software or related field, or equivalent experience in EC&I engineering.
  • Membership in a relevant professional institution.
  • Certified training in SQL and Cyber Security.
  • Significant experience in database structure implementation within PLC/SCADA systems.
  • Proficient in SQL, MySQL, Oracle, SQL Server, and Python programming.
  • Strong analytical skills for diagnosing and resolving database issues.
  • Experience in data migrations, archiving, and recovery procedures.
  • Excellent written and verbal communication skills.
  • Strong interpersonal skills for interaction with stakeholders.

Salary (Rate): undetermined

City: Warrington

Country: undetermined

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: Senior

Industry: Other

Detailed Description From Employer:

Do you have proven Database experience within an EC&I or other highly regulated environment? Are you familiar with utilising various database structures within a PLC/SCADA control system design background? Would you be interested in using your design expertise to drive the development of all database systems across a leading nuclear consultancy? If so, this could be an opportunity for you!

The Opportunity

A fantastic opportunity has opened for an experienced Lead Database Engineer 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.

Your duties and responsibilities will be

  • 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 should 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, creating 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.

You will have the following qualifications & experience

  • 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.
  • Certified Cyber Security training.
  • 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.

It’s great if you also have the following

  • 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 client Ltd Mgmt. System (V-Model).
  • Awareness and understanding of client Engineering Standards.

Get in touch now

If you’re seeking a new opportunity that offers career progression, allowing you to continuously expand your skillset and become part of a collaborative team of specialists, then this could be the perfect role for you, so apply today!

Millbank Holdings Ltd is an equal opportunities employer committed to creating an inclusive and diverse workforce. We welcome applications from all suitably qualified individuals, regardless of background, and encourage candidates from underrepresented groups to apply. We are proud to be a member of the Disability Confident Scheme, and we are committed to ensuring an accessible and supportive recruitment process for everyone. If you require any adjustments at any stage, please let us know and we’ll do our best to accommodate.

Millbank operates as both an Employment Agency and an Employment Business.