SQL Database Engineer

• Experience of infrastructure and cloud database engineering

• Cloud DBA experience (Azure SQL – must have)

• Experience as a senior SQL DBA

• In-depth technical knowledge of the following:

• MS SQL 2005 – 2019 and onwards

• SQL query/workload performance tuning/troubleshooting

• Partitioning, In memory OLTP, Resource Governor, Query Store- atleast 2 skill

• SSRS and SSIS

• High Availability using SQL AlwaysOn Availability Groups and Failover Clustering Instances

• Experience of delivering improvement through debugging code and optimising queries

• Creation and development of scheduled database maintenance routines

• In-depth knowledge of Active Directory in relation to databases (least privilege access concept)-good to have

• In-depth technical knowledge of PowerShell, TSQL scripting, python and automation in relation to databases-Expert

• Managing large SQL databases (10TB+)

• In-depth knowledge of security and vulnerability-based approach to security hardening

• Very good understanding of the importance of metrics and statistics when measuring database performance and capacity

• Experience of working with development/delivery stakeholders on cloud application migrations or large scale/complex infrastructure initiatives

• Experience in building and delivering services via APIs

• Experience with modern DevOps tooling (e.g., GIT, Azure DevOps, Terraform, Azure ARM, Jenkins, Ansible, Puppet, Docker, Kubernetes)-

• Strong Infra knowledge - Virtualisation, Database, Networks, Windows, Linux, Storage

• Understanding of PaaS, Infra-As-Code, Compliance-as-Code, and when/how to use & enable

• Experience with modern engineering and agile practices as well as shift left CI/CD

• Experienced with scripting and/or ideally one language, (e.g., PowerShell, TSQL, Python, .NET, Nodejs, Ruby, Java)

• Proven ability to collaborate with multi-disciplinary teams of business analysts, developers, infrastructure engineers, data scientists, and subject matter experts

• Deep understanding of broader cloud ecosystem including Cloud Computing Technologies, business drivers and leading-edge cloud emerging technologies and trends.

• Solid interpersonal and communication skills and the ability to self-manage

• Vendor relationship management experience

The knowledge, experience and qualifications that will help

• Working knowledge of any of the following database engines would be beneficial

• Oracle, MySQL, PostgreSQL, MariaDB

• Azure: Cosmos DB, MySQL Flexible, PostgreSQL Flexible

• AWS: Aurora, DynamoDB

• Experienced in designing, engineering, and implementing cloud database solutions on Azure/AWS RDS

• Hands on experience of designing, engineering, supporting Kubernetes

• Experience of cloud transformation and change programs across technology organizations

• Cloud database certifications for at least Azure SQL (AWS RDS beneficial)

• Understanding Cloud Service capabilities and relative strengths (AWS, Azure, GCP, Ali)

• Knowledge of database backup solutions, including native cloud backup options

• Experience of Power BI, Azure Power Platform

• Experience of working in the financial sector

What you’ll be like

A passionate engineer/technologist

An engineer who has the hunger and desire to learn new technologies

An advocate of cloud, cloud adoption and cloud transformation

Someone who embraces collaboration and change

SQL DBA, Azure,