Description

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

Education

Any Graduate