Data Architect

Peninsula

City of Westminster

On-site

GBP 90,000 - 120,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Peninsula Group is seeking an experienced Data Architect to lead the design, implementation and tuning of enterprise SQL Server environments in London. The role combines strategic architecture with hands-on administration to ensure highly available, secure and scalable data platforms.

You will oversee on‑premises and cloud databases, drive DR strategies, and collaborate with development, security and infrastructure teams to deliver robust data solutions that support business growth.

Qualifications

  • Experience designing and implementing scalable SQL Server architectures.
  • Strong skills in performance tuning, indexing, and query optimisation.
  • Proven ability to lead database projects and migrations.

Responsibilities

  • Design and maintain scalable, secure SQL database architectures.
  • Administer and support Microsoft SQL Server environments across dev, test, and prod.
  • Develop standards and governance for databases.
  • Monitor performance and optimise proactively.
  • Implement security controls, access management, and encryption.
  • Plan HA/DR solutions including backup, clustering, and replication.
  • Support cloud and hybrid database platforms (Azure).
  • Collaborate with developers on schemas, queries, and indexing.
  • Lead incidents and provide technical direction during outages.
  • Plan upgrades, patches and platform enhancements.
  • Ensure data integrity and recoverability across systems.
  • Create technical docs and architecture diagrams.
  • Conduct capacity planning and roadmap contributions.
  • Mentor DBAs and development teams.
  • Participate in architecture reviews and technology roadmaps.

Skills

SQL Server architecture
Azure SQL / cloud databases
T-SQL performance tuning
Disaster recovery planning

Tools

SQL Server Management Studio
PowerShell
Azure DevOps

Job description

Data Architect

Department: IS

Employment Type: Full Time

Location: London

Reporting To: James Kirby

Description

We are seeking an experienced SQL Database Architect Administrator to lead the design, implementation, optimisation, security, and administration of enterprise database environments. This role combines strategic database architecture with hands‑on database administration, ensuring that business‑critical systems remain highly available, secure, scalable, and aligned with organisational objectives.

The successful candidate will be responsible for designing robust database solutions, managing SQL Server environments, supporting cloud and hybrid database platforms, implementing disaster recovery strategies, and driving database performance improvements. You will work closely with application development teams, infrastructure specialists, cybersecurity professionals, and business stakeholders to deliver reliable data solutions that support business growth and innovation.

This is an excellent opportunity for a database professional who thrives in complex environments and enjoys balancing architectural leadership with operational excellence.

Key Responsibilities
  • Design and maintain scalable, secure, and high-performance SQL database architectures.
  • Administer and support Microsoft SQL Server environments across development, testing, and production platforms.
  • Develop database strategies, standards, policies, and best practices to ensure consistency and governance.
  • Monitor database performance and proactively identify opportunities for optimisation.
  • Implement and maintain database security controls, access management, encryption, and compliance requirements.
  • Design and manage high‑availability and disaster recovery solutions, including backup, restore, clustering, and replication technologies.
  • Support cloud‑based database services, including Microsoft Azure SQL and hybrid database architectures.
  • Collaborate with developers to design efficient database structures, queries, stored procedures, and indexing strategies.
  • Troubleshoot complex database issues and provide technical leadership during incident resolution.
  • Plan and execute database upgrades, migrations, patches, and platform enhancements.
  • Ensure data integrity, availability, and recoverability across all database systems.
  • Create and maintain technical documentation, architecture diagrams, operational procedures, and support knowledge bases.
  • Conduct capacity planning and forecasting to support future business requirements.
  • Provide technical mentoring and guidance to database administrators and development teams.
  • Participate in architecture reviews and contribute to technology roadmaps and strategic initiatives.
Skills, Knowledge & Expertise
  • Advanced expertise in Microsoft SQL Server administration and architecture.
  • Strong knowledge of database design principles, data modelling, normalisation, and performance tuning.
  • Experience with SQL Server Always On Availability Groups, Failover Clustering, Replication, and Log Shipping.
  • Proficiency in T-SQL, stored procedures, triggers, and query optimisation.
  • Experience managing Azure SQL Database, Azure Managed Instance, or other cloud database services.
  • Knowledge of ETL processes, data integration, and data warehousing concepts.
  • Familiarity with PowerShell scripting and database automation tools.
  • Experience with database monitoring and performance management platforms.
  • Understanding of backup, recovery, business continuity, and disaster recovery planning.
  • Database security frameworks, encryption technologies, and access control methodologies.
  • Data governance, regulatory compliance, and information security best practices.
  • Enterprise architecture principles and database lifecycle management.
  • Infrastructure concepts including Windows Server, networking, storage, and virtualisation technologies.
  • DevOps, CI/CD pipelines, and Infrastructure-as-Code concepts.
  • Proven experience in both database architecture and database administration roles.
  • Demonstrated ability to manage large‑scale, mission‑critical database environments.
  • Strong analytical, problem‑solving, and troubleshooting capabilities.
  • Excellent stakeholder engagement and communication skills.
  • Ability to translate business requirements into effective technical database solutions.
  • Experience leading database projects, migrations, upgrades, and transformation initiatives.
  • Relevant certifications such as Microsoft Azure Database Administrator Associate, Azure Solutions Architect Expert, or equivalent are advantageous.

This role is ideal for a senior database professional who can provide architectural leadership while ensuring the ongoing stability, security, and performance of enterprise SQL environments.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect
Data Architect

Peninsula Group • Greater London

On-site
GBP 90,000 - 120,000
Competitive salary
Career progression
Bonus scheme
Data Architect
Data Architect

Peninsula • Greater London

On-site
GBP 90,000 - 130,000
Data Architect
Data Architect

Reed Talent Solutions • Manchester

On-site
GBP 56,000 - 61,000
Public sector pension
Data Architect
Data Architect

La Fosse • Greater London

Hybrid
GBP 90,000 - 130,000
Senior Data Architect
Senior Data Architect

Myn • Salisbury

On-site
GBP 90,000 - 135,000
Data Architect
Data Architect

Ceox Services Ltd • Guildford

Remote
GBP 120,000 - 185,000
Data Architect
Data Architect

Morson Edge • Greater London

On-site
GBP 90,000 - 130,000
Data Architect
Data Architect

Morson Edge • Greater London

On-site
GBP 90,000 - 130,000
Data Architect
Data Architect

Harvey Nash UK • Greater London

On-site
GBP 70,000 - 110,000
SQL Database Administrator (DBA)
SQL Database Administrator (DBA)

Datacareers • England

Hybrid
GBP 46,000 - 56,000