DataOps Engineer

The Data Ops Engineer is responsible for the reliability administration automation release management and continuous improvement of Shawbrooks database and data platform services. The role requires strong core SQL DBA capability across production SQL Server and Azure SQL database platforms including performance tuning backup and restore security availability capacity management monitoring and incident/problem resolution. This is combined with SQL PaaS Azure SQL Database Cosmos DB Power Shell automation and modern Dev Ops tooling.

Working within the Data Ops function the role supports engineering data platform and application teams by providing robust database administration deployment automation performance tuning monitoring and operational governance. The Data Ops Engineer will help ensure that database changes are delivered safely and consistently through source control CI/CD pipelines and database deployment tools such as Git and Redgate Flyway.

The role suits a hands-on engineer who can combine strong SQL DBA fundamentals with cloud platform knowledge automation skills and structured Dev Ops delivery while collaborating effectively across technical and non-technical teams.

Key Responsibilities

• Administer monitor maintain and optimise Microsoft SQL Server Azure SQL Database and SQL PaaS services to ensure performance resilience security recoverability and availability.
• Perform core SQL DBA activities including database maintenance planning backup and restore validation recovery testing access/security administration index and statistics management database integrity checks and operational health reviews.
• Support the design operation and governance of cloud data platform services including Cosmos DB and Azure SQL Database in line with architectural and operational standards.
• Develop and maintain Power Shell automation for database administration operational tasks environment management monitoring reporting and repeatable platform processes.
• Implement and support database release management using Dev Ops practices including Git-based source control branching strategies pull requests code review and deployment pipelines.
• Use Redgate Flyway and related database Dev Ops tooling to manage schema changes version-controlled migrations repeatable deployments and release traceability across environments.
• Work with engineering teams to embed CI/CD practices for data-driven applications ensuring database changes are tested approved and deployed safely.
• Provide core SQL DBA support across performance tuning capacity management query optimisation indexing strategy execution plan analysis blocking/deadlock investigation statistics maintenance and database health checks.
• Implement monitoring alerting and operational controls for database platforms ensuring incidents and problems are identified investigated and resolved effectively.
• Maintain data platform standards documentation runbooks and automation scripts to improve operational consistency and reduce manual effort.
• Ensure compliance with Shawbrook data governance information security access control and audit requirements.
• Collaborate with Data Platform Engineering Architecture Information Security Service Operations and Change teams to support delivery and platform stability.
• Contribute to continuous improvement by identifying opportunities to automate simplify secure and standardise database and data platform operations

Qualifications :

Skills & Experience

Essential

• Strong core SQL DBA skills across Microsoft SQL Server and Azure SQL Database including T-SQL troubleshooting performance tuning indexing query plans backup/restore recovery models high availability/disaster recovery database security monitoring maintenance and operational support.
• Proven ability to diagnose and resolve production SQL issues including slow-running queries blocking deadlocks failed jobs storage/capacity constraints integrity issues and restore/recovery scenarios.
• Experience working with SQL PaaS services in Azure including operational management configuration scaling resilience and cost/performance considerations.
• Hands-on experience with Cosmos DB including data modelling considerations partitioning indexing throughput management monitoring and operational support.
• Strong Power Shell scripting skills with proven experience using Power Shell to automate database platform deployment or operational processes.
• Experience with Dev Ops practices and tooling including Git repository management pull requests CI/CD pipelines and automated deployment workflows.
• Experience using Redgate Flyway or equivalent database migration tooling to manage version-controlled database changes and deployments.
• Good understanding of database release management change control environment promotion and deployment governance in a regulated or controlled environment.
• Ability to troubleshoot complex data platform issues across databases scripts deployments infrastructure and application dependencies.
• Strong documentation communication and…