Cloud Database Engineer

Must Have

 

• Experience of infrastructure and cloud database engineering
• Cloud DBA experience (Azure SQL, AWS or GCP)
• Experience as a senior SQL/Oracle DBA
  
   

Technical Knowledge Of The Following SQL

 

• MS SQL 2005 2019 and onwards
• SQL query/workload performance tuning/troubleshooting
• Partitioning, In memory OLTP, Resource Governor, Query Store
• SSRS and SSIS
  
   

Technical Knowledge Of The Following ORACLE

 

• 5 years oracle administration for Oracle V11 and onwards
• High availability using Oracle Dataguard
• Solaris/Linux administrative skills
• SQL query/workload performance tuning/troubleshooting
• Experience of delivering improvement through debugging code and optimising queries
• Creation and development of scheduled database maintenance routines
• In-depth technical knowledge of Shell scripting, PLSQL scripting and automation in relation to databases
• In-depth knowledge of security and vulnerability-based approach to security hardening
• Experience with modern DevOps tooling (e.g., GIT, Azure DevOps, Terraform, Azure ARM, Jenkins,
  
   

Ansible, Puppet, Docker, Kubernetes)

 

• Good English level (B2-C1).
  
   

Nice To Have

 

• High Availability using SQL AlwaysOn Availability Groups and Failover Clustering Instances
• In-depth knowledge of Active Directory in relation to databases (least privilege access concept)
• In-depth technical knowledge of PowerShell, TSQL scripting and automation in relation to databases
• 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

 

• 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