Cloud Database Administrator - Azure Cloud | Legal Firm
London
£40,000 - £50,000 per annum
My client is a Global Legal Firm who are looking to appoint a Cloud Database Administrator to join their Data Management Team in supporting the implementation of their data platforms in the cloud and on-premises.
Role:
* Support the Senior Data Platform Engineer and the Datacentre Transformation Project team in the implementation of a successful transition of the firm's on-premises infrastructure to the Cloud
* Ensure that databases meet performance, scalability, and availability requirements
* Implement solutions and infrastructure with appropriate levels of security and encryption
* Implement an effective backup and recovery strategy under guidance of Senior Data Platform Engineer.
* Maintain adequate and up-to-date documentation on the firm's data infrastructure and platforms
* Ensure that backups are tested on a regular basis and that any failures are investigated and resolved
* Ensure that SQL and related servers are patched and maintained while minimising downtime
* Implement high-availability solutions to computing infrastructure under the guidance of the Senior Data Platform Engineer
* Optimise the use of hardware and software SQL instances to streamline resource utilisation
* Carry out performance monitoring and tuning of SQL instances and cloud-based database platforms, and implement measures to improve performance and reduce costs
Skills Needed to be successful:
* Good experience with SQL server and related technologies (T-SQL, SSIS, SSAS, SSRS)
* Experience with cloud platforms, specifically Microsoft Azure, and related services (Azure SQL database, Azure Data Factory, Azure Backup)
* Strong problem-solving skills and experience with troubleshooting and root cause analysis
* Knowledge of database design, performance optimisation, and troubleshooting
