Job
Description
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 Required Skills SQL DBA, Azure,
