Role

This role will build on that work validating findings, tying data structures back to application functionality, and driving safe, incremental change to reduce risk, improve performance, and strengthen reliability.

This is not a documentation or governance role. It is a delivery-focused engineering position requiring deep technical capability, strong analytical thinking, and the ability to move changes safely through environments into production.

You will operate in alignment with Azure Well-Architected principles for reliability, performance efficiency, and security applied pragmatically to a largely on-prem / hybrid environment.

Key Responsibilities

• Analyse and rationalise a 1TB+ SQL Server database, identifying redundant, obsolete, or high-risk tables and data structures.
• Map database objects back to application functionality to determine what is required, what can be archived, and what can be safely removed.
• Document and implement data retention and archival strategies aligned to business and regulatory requirements.
• Improve performance through indexing, partitioning, query optimisation, and schema refinement.
• Reduce single points of failure and improve database-level resilience.
• Strengthen database security (encryption, access control, auditing).
• Collaborate with developers to improve data access patterns and eliminate inefficient queries.
• Work closely with architects and SREs to ensure database design supports system reliability objectives.
• Safely promote database changes through development, test, and production environments using controlled release strategies.
• Ensure rollback and recovery mechanisms are in place for structural changes.
• Build on previous analysis rather than restarting discovery work.