logo

View all jobs

DBA/Data Services Engineer

Toronto, ON

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.

More Openings

Helpdesk Level 2 Support
System Admin
Deployment Supervisor

Share This Job

Powered by