Database Administrator

STACK IT Recruitment

9d•Remote

About The Position

The Database Administrator will manage and improve a large, primarily on-premises Microsoft SQL Server environment for an established recovery-audit firm that helps large corporations identify and recover accounts-payable overpayments. The estate includes databases ranging from 30 to 40 terabytes running on Pure Storage FlashArray. The role will establish and maintain deliberate approaches to database access, permissions, standards, monitoring, backups, recovery, and performance, while also handling operational requests and serving as an escalation point for database issues. The position is expected to assess the environment, recommend improvements, and lead those changes through implementation. Responsibilities include SQL Server administration, high availability and disaster recovery, performance tuning, automation, storage-supported database copying and promotion, and coordination with infrastructure, data engineering, development, an infrastructure-as-a-service provider, and an offshore DBA. The company is investing in AI; the DBA will assess how tools such as Claude and Copilot connecting to the environment affect databases and applications. The role is also expected to develop PostgreSQL and AWS skills as a new product is built on AWS with PostgreSQL, within six months to a year. The job is remote in Toronto. The company describes the team as easygoing and collaborative, with Toronto-area colleagues who meet occasionally. Compensation is a base salary of $100,000–$130,000, with competitive vacation and personal days and comprehensive health benefits.

Requirements

At least 5 years of experience as a SQL Server Database Administrator.
Deep Microsoft SQL Server expertise across installation, configuration, patching, SQL Server Agent, tempdb, and transaction log management.
Hands-on experience with high availability and disaster recovery, including Always On availability groups, failover clustering, and replication.
Advanced performance-tuning experience, including indexing, query optimization, partitioning, and compression on very large databases.
Scripting and automation skills with PowerShell or Python.
Working knowledge of Pure Storage FlashArray, including snapshots and creating and mounting volumes.
Experience designing permission and access models, security policies, and database standards.
A track record of assessing a database environment and leading changes to improve it.
Clear communication with infrastructure, data engineering, and development teams.

Nice To Haves

Experience with Azure SQL Database or Azure SQL Managed Instance.
PostgreSQL experience, particularly on AWS.
Microsoft SQL Server or Azure database certifications.
Experience with Redgate tools.
Experience with Azure DevOps deployments.

Responsibilities

Install, configure, patch, and upgrade SQL Server instances in a primarily on-premises environment while keeping downtime to a minimum.
Implement and maintain high availability and disaster recovery using Always On availability groups, failover clustering, and replication.
Tune performance using indexing, query optimization, partitioning, and compression, including for databases of 30 to 40 terabytes.
Manage SQL Server Agent jobs, transaction logs, and tempdb, and automate routine work with PowerShell or Python.
Use Pure Storage FlashArray snapshots, volumes, and mounts to copy and promote databases from development to production.
Design and enforce database security, permissions, naming conventions, and standards.
Build and test backup and recovery procedures and set up database monitoring.
Handle database tickets, including moves, archives, and permission requests, and work on the monthly deployment alongside an offshore DBA.
Assess how AI tools such as Claude and Copilot connecting to the environment affect databases and applications.
Work with the infrastructure-as-a-service provider, data engineering, and development teams on promotions to production.
Assess the database environment, recommend improvements, and lead those changes through implementation.
Develop PostgreSQL and AWS skills to support a new product being built on AWS with PostgreSQL.