WHAT YOU WILL OWN

 

• Monitor and support Azure SQL, SQL 2019, Cosmos, PostgreSQL and Databricks
• Work on the observability of relevant database metrics and reach our database objectives
• Provide database expertise to engineering teams, e.g. collaborate with developers for performance tuning tasks or data migration projects.
• Automate regular administrative work to reduce toil
• Proactive monitoring and alerting on symptoms and SLOs, not on outages
• Work on automation of database infrastructure and help engineering succeed by providing self-service tools. Script internal automation tools using PowerShell, TSQL, Kusto.Python etc.
• Automate the build, test and deployment of the database via DBUp, SQL Change automation, DACPAC etc. Evaluate new database technologies as required.
• Standardize DB infra via Desired State Configurations scripts and ARM templates
• Document every action, so your learnings turn into repeatable steps and then into automation
• Ensure compliance and assist with various regulatory requirements and internal policies & procedures

Ecosystem

• SQL Server 2019
• Azure SQL Database
• Azure Database for PostgreSQL
• Azure Cosmos DB
• Azure Databricks
• SQL Monitor

Day to day work items could look like:

• Review, analyse and implement database administration solutions (e.g., nightly maintenance jobs, backups)
• Recommend query and schema changes to optimise the performance of database queries
• Jump on a production incident to mitigate database-related issues during the OnCall schedule. Ability to navigate production incidents independently or with minimal supervision.
• Participate actively in the infrastructure design and scalability considerations focusing on data storage aspects
• Work with Terraform and other tools to build mature automation
• Capacity and sustainability planning for datastores
• Design and develop specifications for future database requirements, including enhancements, upgrades, and capacity planning; evaluate alternatives, and make appropriate recommendations.