Database Administrator
Posted on:
10 hours ago
Vacancies:
1 Vacancy
Job Summary
About The Role
We are seeking an experienced database administrator to join the team that operates theSaaS platform.
You will be responsible for the reliability and performance of the databases and data processes that deliver service to our clients. You will deploy monitor optimize and troubleshoot issues with code and infrastructure related to our large-scale databases and data processes. As a member of the Platform Operations team you will collaborate with colleagues in Infrastructure Product Development Analytics and other teams.
An industry leader in data analytics we provide opportunities to develop your leadership and technical skills. We offer a combination of working in our office in downtown Toronto and at home.
Key Responsibilities
Monitor optimize and resolve issues related to the reliability performance and security of large-scale databases and complex data processes
Partner with Infrastructure team in monitoring provisioning and right-sizing of servers and storage
Collaborate with Product Development team on enhancements and resolving nonfunctional issues: provide insights from UAT and Production environments; share expertise in optimizing SQL and physical aspects of databases
Proactively identify and advocate for improvements to technology and methods used to deploy configure and maintain databases and data processes
Effectively communicate business benefits costs and implications of proposed
changes to non-technical and more senior colleagues
Contribute to SQL coding standards and conduct code reviews
Create and maintain technical documentation
Knowledge and Skills
Expertise in physical schema and infrastructure for databases and data processing: compute and storage for IaaS and PaaS resources in Azure; partitioning and indexing of data
Advanced SQL coding and applied knowledge of relational database engines including Microsoft SQL Server and Azure data services
Experienced in database maintenance performance monitoring and debugging
Apply DevOps practices to automate deployment of databases and ETL/ELT components
Knowledge of data warehousing is desirable
Objectively assess potential solutions by balancing business value and technical complexity
Highly organized and able to balance parallel tasks
Collaborate effectively with colleagues that span a broad range of roles
Effectively communicate complex topics to technical and non-technical
colleagues
Qualifications
Proven success as database administrator/engineer for large-scale databases and complex data processes
5 years of professional experience in applicable roles
Post-secondary education in Computer Science or a similar discipline
What We Can Offer
A competitive base salary and variable annual bonus.
A flexible hybrid working policy. Most people come into the office 2-3
days/week.
A healthy work-life balance.
25 days annual leave plus 4 wellness days and public holidays
Comprehensive benefits program
Generous employer RRSP contribution
An annual personal development allowance
An office walking distance to Union Station
We are seeking an experienced database administrator to join the team that operates theSaaS platform.
You will be responsible for the reliability and performance of the databases and data processes that deliver service to our clients. You will deploy monitor optimize and troubleshoot issues with code and infrastructure related to our large-scale databases and data processes. As a member of the Platform Operations team you will collaborate with colleagues in Infrastructure Product Development Analytics and other teams.
An industry leader in data analytics we provide opportunities to develop your leadership and technical skills. We offer a combination of working in our office in downtown Toronto and at home.
Key Responsibilities
Monitor optimize and resolve issues related to the reliability performance and security of large-scale databases and complex data processes
Partner with Infrastructure team in monitoring provisioning and right-sizing of servers and storage
Collaborate with Product Development team on enhancements and resolving nonfunctional issues: provide insights from UAT and Production environments; share expertise in optimizing SQL and physical aspects of databases
Proactively identify and advocate for improvements to technology and methods used to deploy configure and maintain databases and data processes
Effectively communicate business benefits costs and implications of proposed
changes to non-technical and more senior colleagues
Contribute to SQL coding standards and conduct code reviews
Create and maintain technical documentation
Knowledge and Skills
Expertise in physical schema and infrastructure for databases and data processing: compute and storage for IaaS and PaaS resources in Azure; partitioning and indexing of data
Advanced SQL coding and applied knowledge of relational database engines including Microsoft SQL Server and Azure data services
Experienced in database maintenance performance monitoring and debugging
Apply DevOps practices to automate deployment of databases and ETL/ELT components
Knowledge of data warehousing is desirable
Objectively assess potential solutions by balancing business value and technical complexity
Highly organized and able to balance parallel tasks
Collaborate effectively with colleagues that span a broad range of roles
Effectively communicate complex topics to technical and non-technical
colleagues
Qualifications
Proven success as database administrator/engineer for large-scale databases and complex data processes
5 years of professional experience in applicable roles
Post-secondary education in Computer Science or a similar discipline
What We Can Offer
A competitive base salary and variable annual bonus.
A flexible hybrid working policy. Most people come into the office 2-3
days/week.
A healthy work-life balance.
25 days annual leave plus 4 wellness days and public holidays
Comprehensive benefits program
Generous employer RRSP contribution
An annual personal development allowance
An office walking distance to Union Station
Required Experience:
Unclear Seniority