Senior Database Administrator (Microsoft SQL)

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.

• 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
• Reference: 1Eq1olhgdIhcPc9AkQ0U9Nq4M_I4sAASlnbNB7HV3K4NSxQ5W_j4fiSNK820V8Ut

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.

• Propose improvements to database architecture, scalability, security, and performance
• Participate in defining technical standards, governance policies, and operational procedures
• Identify and mitigate potential issues before they impact production systems
• Mentor less experienced team members and share knowledge across teams

• Minimum 5 years of experience as a Database Administrator, with significant experience in Microsoft SQL Server
• Advanced knowledge of Microsoft SQL Server and related Microsoft data platform technologies
• Experience administering large-scale and mission-critical SQL Server production environments
• Strong knowledge of T-SQL, database design principles, and query optimization
• Experience with SQL Server backup and recovery strategies and tools
• Experience with SQL Server performance troubleshooting, including deadlock analysis, blocking investigation, wait statistics, Extended Events, Query Store, and execution plan analysis
• Experience with Always On Availability Groups, Failover Clustering, and disaster recovery solutions
• Experience with Azure SQL Database, Azure SQL Managed Instance, or other Azure data services
• Strong understanding of database performance tuning and troubleshooting methodologies
• Experience with monitoring and management tools such as SQL Server Management Studio (SSMS), Azure Monitor, Azure Log Analytics, Extended Events, Query Store, and SQL Server DMVs

• Microsoft certifications such as:Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Azure Solutions Architect Expert
• Other relevant Microsoft data platform certifications
• Experience with Azure SQL Managed Instance, Azure SQL Database, and Azure Synapse Analytics
• Experience working with Microsoft Azure cloud services
• Familiarity with Azure DevOps.

What we offer

• Long term, full-time employment with competitive salary
• Flexible work environment (Belgrade: hybrid, Tuesday and Wednesday in office; Kragujevac: in office every day)
• Opportunity to be part of a highly talented, professional and friendly team in a dynamic working environment
• The ability to use cutting edge technologies
• Excellent working conditions and equipment
• Further professional development and career growth
• Private health insurance
• Private pension
• Fully covered sick leave
• All benefits paid pursuant to relevant Serbian laws