Senior Web Developer

Flexstaf IT; Toronto; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

Flexstaf IT is seeking an experienced Database Administrator to join the Platform Operations team in a hybrid role based in Downtown Toronto. You will deploy, monitor, optimize, and troubleshoot large-scale databases and data processes to ensure reliability and performance for clients.

You will collaborate with Infrastructure, Product Development, Analytics and other teams, applying DevOps practices to automate deployments and ETL/ELT components, while contributing to database standards and

Qualifications

• 5+ years of professional experience in database engineering roles.
• Post-secondary education in Computer Science or a similar discipline.
• Proven success as database administrator/engineer for large-scale databases.

Responsibilities

• Monitor, optimize, and resolve reliability, performance, and security of large-scale databases.
• Collaborate with Infrastructure to provision servers and storage.
• Collaborate with Product Development to optimize SQL and DB design.
• Identify improvements for deployment, configuration, and maintenance of databases.
• Explain benefits and costs of changes to non-technical and senior stakeholders.
• Contribute to SQL coding standards and perform code reviews.
• Create and maintain technical documentation.

Skills

Advanced SQL

Azure data services

SQL Server expertise

Database performance

DevOps for databases

Education

Bachelor's degree in Computer Science

Tools

Microsoft SQL Server

Azure

Job description

About The Role

Our client is seeking an experienced database administrator to join the team that operates the SaaS platform.

We will be responsible for the reliability and performance of the databases and data processes that deliver service to their clients. You will deploy, monitor, optimize and troubleshoot issues with code and infrastructure related to our large-scale databases and data processes. As part of the Platform Operations team, you’ll collaborate with colleagues in Infrastructure, Product Development, Analytics and other teams.

This is an active posting for an open position. Candidates must be available to work in a hybrid setting in Downtown Toronto, 2-3 days/week.

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 They 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
• An annual personal development allowance
• An office walking distance to Union Station