Data Architect

Peninsula

Greater London

On-site

GBP 90,000 - 130,000

Full time

36 hours 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 is seeking an experienced SQL Database Architect Administrator to lead the design, implementation, and administration of enterprise SQL Server environments in London. You will drive architecture, security, scalability, and availability while collaborating with development, cybersecurity, and infrastructure teams.

You will manage on-premises, cloud, and hybrid SQL platforms, implement DR strategies, optimise performance, and mentor DBAs.

Qualifications

  • Advanced SQL Server design and administration experience.
  • Experience with high availability, disaster recovery, and clustering.
  • Strong knowledge of data modelling, normalisation, and performance tuning.
  • Experience with cloud and hybrid database environments (Azure).
  • CI/CD and DevOps awareness in database changes.

Responsibilities

  • Design and maintain scalable, secure SQL database architectures.
  • Administer MS SQL Server across development, test, and production.
  • Develop standards and governance for database environments.
  • Monitor performance and optimise queries, indexes, and configurations.
  • Implement disaster recovery, backups, and DR strategies.
  • Support cloud services including Azure SQL and hybrid architectures.
  • Collaborate with development, security, and ops teams for data solutions.
  • Lead upgrades, migrations, and platform enhancements.
  • Create architecture diagrams and technical documentation.

Skills

SQL Server
Database Architecture
Azure SQL
T-SQL
PowerShell
Performance Tuning
Security & Compliance

Tools

SQL Server Management Studio
Azure SQL Database
Azure Managed Instance

Job description

Description

Department: IS

Location: London

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.
Technical Skills
  • 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.
Knowledge
  • 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.
Expertise & Experience
  • 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 • City of Westminster

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

Peninsula Group • Greater London

On-site
GBP 90,000 - 120,000
Competitive salary
Career progression
Bonus scheme
SQL DBA / SQL Database Administrator
SQL DBA / SQL Database Administrator

Exalto Consulting • England

On-site
GBP 60,000 - 80,000
Senior Database Administrator
Senior Database Administrator

Intec Select Ltd • City Of London

Hybrid
GBP 77,000 - 94,000
SQL Server DBA/Engineer
SQL Server DBA/Engineer

Advanced Resource Managers Ltd • Greater London

Hybrid
GBP 83,000 - 129,000
SQL Database Administrator (DBA)
SQL Database Administrator (DBA)

Datacareers • England

Hybrid
GBP 46,000 - 56,000
SQL DBA - Kingston, Surrey - Hybrid - £85,000
SQL DBA - Kingston, Surrey - Hybrid - £85,000

Ashdown Group • Staines-upon-Thames

Hybrid
GBP 72,000 - 98,000
Data Architect
Data Architect

La Fosse • United Kingdom

Hybrid
GBP 85,000 - 115,000
Senior SQL Database Architect & Availability Expert
Senior SQL Database Architect & Availability Expert

Peninsula • City of Westminster

On-site
GBP 90,000 - 120,000
SQL DBA - Kingston - Hybrid - £85,000
SQL DBA - Kingston - Hybrid - £85,000

Ashdown Group • Staines-upon-Thames

Hybrid
GBP 77,000 - 94,000