Database and Infrastructure Engineer – UK (12 Month FTC)

Job Title: Database and Infrastructure Engineer – UK (12 Month FTC)

Industry: Banking

Location: United Kingdom

Salary: £75,000 – £90,000 per annum, depending on experience

The Opportunity

Our client, a well-established organisation operating within a highly regulated environment, is seeking an experienced Database and Infrastructure Engineer to join its Technology function on a 12-month fixed-term contract (FTC).

This is a hands-on technical role combining advanced SQL development, database engineering and administration, data integration, Microsoft Fabric and Power BI.

The successful candidate will be responsible for developing, administering and optimising secure, resilient and high-performing database and data solutions supporting critical business operations, management information, reporting and digital services.

The role requires someone who is equally comfortable working with traditional enterprise database environments and modern Microsoft data technologies, with the ability to operate effectively within a demanding production environment.

Key Responsibilities

Database Design & SQL Development

• Design, develop and maintain relational database structures, schemas, tables, views, indexes, stored procedures, functions and triggers.
• Write, test, review and optimise complex T-SQL and, where required, PL/SQL for applications, integrations and reporting workloads.
• Develop robust data models and reusable database components that support accuracy, scalability and maintainability.
• Support application teams with database requirements, release scripts, source control and database deployment automation.
• Establish and maintain appropriate database development and coding standards.

Database Administration, Performance & Resilience

• Install, configure, patch, upgrade and administer Microsoft SQL Server environments.
• Support Oracle database environments where applicable.
• Monitor database availability, capacity and performance and proactively identify potential issues.
• Diagnose bottlenecks and optimise queries, execution plans, indexes and database configurations.
• Implement and test backup, restore, high-availability and disaster-recovery arrangements.
• Provide production support, incident resolution, root-cause analysis and problem management for database and data-service issues.
• Help ensure database environments remain secure, resilient and highly available.

Data Integration & Microsoft Fabric

• Develop, operate and monitor ETL/ELT processes and data pipelines.
• Work with SQL Server Integration Services, Microsoft Fabric Data Factory, dataflows and related technologies.
• Ingest, cleanse, transform and reconcile structured and semi-structured data from multiple enterprise and third-party systems.
• Design and support Microsoft Fabric Lakehouse and Warehouse solutions using technologies including OneLake, Delta Lake and SQL analytics endpoints.
• Support modern data architectures, including medallion architecture and curated data products.
• Use T-SQL and, where appropriate, Spark SQL, Python or notebooks to prepare data for analytics and reporting.
• Implement appropriate data-quality controls, metadata, lineage and reconciliation processes.

Power BI & Reporting

• Develop and maintain Power BI semantic models, dashboards and reports supporting operational, management and reporting requirements.
• Build efficient data models, relationships, measures and calculations using DAX and Power Query.
• Optimise data refresh performance, gateways and DirectQuery or Direct Lake connectivity.
• Implement appropriate row-level security and access controls.
• Work with stakeholders to translate reporting requirements into accurate, governed and reusable data solutions.

Security, Governance & Infrastructure Support

• Implement least-privilege access, database roles, encryption, auditing, masking and appropriate privileged-access controls.
• Protect the confidentiality, integrity and availability of organisational data.
• Support database infrastructure and associated services within a secure and controlled technology environment.
• Maintain technical documentation, data dictionaries, support procedures and architecture records.
• Follow established SDLC, change, release and configuration-management processes.
• Support operational resilience, disaster recovery and technology-control requirements.
• Work closely with application, infrastructure, cybersecurity, data and business teams.
• Provide technical input and supporting evidence for internal and external assurance activities.

Skills & Experience

Essential

The successful candidate should demonstrate:

• Strong hands-on experience as a Database Engineer, Database Developer, SQL Developer, Data Engineer, Database and Infrastructure Engineer or similar.
• Advanced Microsoft SQL Server and T-SQL expertise.
• Strong experience in database design, configuration, administration and performance tuning.
• Experience with stored procedures, functions, views, triggers, indexing and execution-plan analysis.
• Strong understanding of relational database management systems, normalisation and dimensional modelling.
• Practical experience developing and supporting secure and reliable ETL/ELT pipelines.
• Experience integrating data from multiple enterprise applications and systems.
• Practical experience with Microsoft Fabric or closely related Microsoft Azure data technologies.
• Experience with Power BI, including semantic models, DAX, Power Query, dashboards and reporting.
• Experience supporting production environments, including backup, restore, high availability and disaster recovery.
• Good understanding of database security, access controls, encryption, auditing and data governance.
• Strong analytical, troubleshooting and problem-solving capabilities.
• Excellent attention to detail and commitment to data accuracy.
• Ability to work effectively under pressure and manage competing operational and project priorities.
• Strong written and verbal communication, documentation and stakeholder-management skills.

Desirable

Experience in some of the following would be advantageous:

• Oracle database administration and/or PL/SQL.
• Microsoft Fabric Lakehouse and Warehouse.
• OneLake and Delta Lake.
• SSIS and SSRS.
• Azure Data Factory and Azure Data Lake Storage.
• Python, Spark SQL or PowerShell.
• Azure DevOps and Git.
• Automated database deployment and CI/CD practices.
• XML, JSON and semi-structured data processing.
• Data governance, metadata and lineage.
• Experience within banking, financial services or another highly regulated environment.
• Experience supporting management or regulatory reporting environments.
• Operational resilience and cybersecurity controls.

Qualifications

• Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems or a related discipline, or equivalent professional experience.
• Relevant Microsoft certification in Azure Data, SQL Server, Power BI or Microsoft Fabric would be desirable.
• ITIL, DevOps, data-governance or information-security training would be advantageous.

Additional Information

This position is offered on a 12-month fixed-term contract (FTC).

Candidates must have the right to work in the United Kingdom and be willing and able to commute to the London office.

The current working arrangement requires office attendance approximately 3–4 days per week, although working arrangements may be subject to change.

This is an excellent 12-month opportunity for an experienced technology professional who combines deep SQL/database engineering expertise with Microsoft Fabric, Power BI and modern data-infrastructure capabilities, and who is comfortable working in a secure, highly regulated and business-critical environment.