Database Developer - Cache/Iris

Job Description

The role will be responsible for the development, maintenance and operational support of the InterSystems Caché and IRIS databases underpinning NBSS.

The service operates across a large number of geographically distributed sites, making stability, performance and continuity critical. The role will also play a key part in supporting a wider supplier service transition and migration, providing the technical expertise needed to understand the existing environment, manage technical dependencies and ensure a smooth transition into the new managed service arrangements.

Key responsibilities include:

• Database Support: Managing, maintaining and troubleshooting the Caché/IRIS databases, ensuring the live service remains stable, secure and performant.
• Caché to IRIS Migration: Leading the technical migration from Caché to IRIS, helping us understand the existing setup, identify any risks and manage the transition with minimal disruption.
• Releases and Patching: Supporting NBSS releases, database updates and patches across multiple sites, ensuring changes are deployed safely and consistently.
• Application Compatibility: Working closely with the VB6 development and Crystal Reports teams to ensure the applications continue to work effectively with the underlying database environment
• Technical Support and Knowledge Transfer: Providing specialist technical input during the transition, helping us build our understanding of the existing platform and establish the knowledge needed to support it going forward.

Qualifications

Essential

• Strong hands-on experience with InterSystems Caché and/or IRIS, including database administration, configuration, troubleshooting, security settings and the Management Portal.
• SQL Querying and Reporting: Strong hands-on SQL experience, with the ability to query and analyse data, understand and troubleshoot existing reports, and develop custom SQL queries and reports to support operational and business requirements.
• Experience working with Windows Server environments, ideally 2016, 2019 and 2022.
• Understanding of enterprise infrastructure, including RAID storage and backup solutions such as Veritas.
• Experience supporting multi-site deployments, ideally within a live, business-critical service.
• Ability to investigate and resolve technical issues independently, particularly within legacy environments.

Desirable

• Experience with Visual Basic 6 (VB6) and its integration with Caché/IRIS databases.
• Familiarity with Crystal Reports and associated database dependencies.
• Previous involvement in a Caché to IRIS migration.
• Experience working within the NHS or other complex, business-critical environments.
• Knowledge of InterSystems ObjectScript.

Additional Information

We pride ourselves on our entrepreneurial spirit and our capacity for doing things differently. Our culture is built on fostering low bureaucracy, emphasizing high agility and promoting flexibility, enabling everyone to contribute their best.

We are a Disability Confident Employer and are committed to creating an inclusive and diverse environment that celebrates every individual. Our recruitment processes are based on individual merit. If you require any reasonable adjustments or additional support during the interview process, please email HR Team at [email protected] for assistance.

#LI-JD1