Senior Data Architect

AGNTX; Manchester; On-site; GBP 112,000 - 147,000; Full time

Job summary

Agntx is seeking a Senior Data Architect to lead the migration of a legacy debt management database to Azure PostgreSQL. The role is hands-on, focusing on understanding the old database behavior and delivering a scalable, fast solution.

You will tune performance, implement data governance, security, and modelling across conceptual, logical and physical layers, with on-site Manchester work one day per week and the rest from home, inside IR35.

Qualifications

• Strong PostgreSQL performance tuning, replication and HA.
• Experience with database indexing and query plan analysis.
• Hands-on data migration to Azure including AKS.
• Proven data modelling (conceptual, logical, physical).
• Experience with data governance and data lineage.
• Knowledge of data security, access control and encryption.

Responsibilities

• Analyze and tune the legacy database for performance.
• Maintain stability via proactive monitoring and optimisation.
• Deliver the migration to Azure and modernisation strategy.
• Design scalable data models at all levels.
• Create data governance documentation and lineage artefacts.
• Apply data security controls, auditing and compliance.

Skills

PostgreSQL tuning

Replication/HA

Query optimization

Azure data migration

AKS

Data modelling

Data governance

Data security

Tools

Azure

AKS

Job description

Senior Data Architect — Manchester, one day a week — £700 per day — Inside IR35

A UK central government programme is replacing a large legacy debt management system, and is hiring a senior data architect to take the data across.

This is a hands-on seat. The job is understanding how an old database actually behaves, then migrating it onto Azure PostgreSQL and keeping it fast and stable once it is there.

What you will do

• Analyse and tune the legacy database — indexing, query plan optimisation, integrity checks and stored procedure behaviour
• Keep database environments stable and healthy through proactive monitoring, maintenance and optimisation
• Deliver the migration onto Azure, including AKS, managed services and the modernisation strategy
• Design scalable conceptual, logical and physical data models
• Create and maintain data governance documentation, standards and data lineage artefacts
• Apply data security measures across access control, encryption, auditing and compliance

What you need

• Advanced PostgreSQL, including performance tuning, replication and high availability
• Database performance tuning expertise — indexing, query plan optimisation, integrity checks, stored procedure behaviour analysis
• Hands-on data migration to Azure — AKS, managed services, modernisation strategies
• Proven conceptual, logical and physical data modelling
• Data governance documentation, standards and data lineage
• Data security — access control, encryption, auditing, compliance

The package

• Inside IR35
• One day a week on site in Manchester, four from home
• Duration being confirmed and will be shared before application