Senior Database Administrator (Microsoft SQL)

About Inovatec by Solifi

Inovatec, now part of Solifi following its recent acquisition, is a growth company based in Vancouver, BC, established in 2006. We are North America's leading provider of cloud-based software solutions for the automotive, motorcycle, powersports, and equipment financing industries. Our solutions are used by some of the largest banks, credit unions, and finance companies in Canada and the U.S.

At Inovatec, we foster a diverse and inclusive environment that encourages collaboration where we grow together and win as a team. We thrive by challenging the status quo to push the industry forward, and we know when to have fun! With team members across North America and Europe, we're committed to investing in the development of our team, no matter where they're located.

Key Responsibilities

• Administration and maintenance of Microsoft SQL Server and Azure SQL Database environments in production and non-production systems

• Installation, configuration, patching, upgrading, and lifecycle management of SQL Server environments

• Monitoring database performance, availability, and health, and proactively resolving issues

• Database performance tuning, query optimization, and troubleshooting using T-SQL and Microsoft performance tools

• Investigating and resolving database performance incidents, including blocking, deadlocks, long-running queries, wait statistics analysis, Extended Events tracing, Query Store analysis, and SQL Server trace flag-based troubleshooting where applicable

• Managing backup, recovery, and business continuity procedures

• Planning, implementing, and maintaining High Availability (HA) and Disaster Recovery (DR) solutions

• Working with SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), Azure SQL Failover Groups, and other Microsoft technologies for high availability and business continuity

• Managing database security, users, roles, permissions, encryption, and access control

• Collaborating with system administrators, cloud engineers, network and security teams, developers, and other IT teams

• Participating in database migration, consolidation, modernization, and infrastructure improvement projects

• Creating and maintaining technical documentation, operational procedures, and standards

What We Expect from the Candidate

We are looking for someone who can independently take ownership of the database platform's operation while also collaborating with other IT teams on complex projects.

From a Senior DBA, we expect the ability to:

• Propose improvements to database architecture, scalability, security, and performance