Are you a SQL Server DBA who can take an environment that has grown quickly and put the right structure under it?

We're hiring a Database Administrator to join an established recovery-audit firm that helps large corporations find and recover overpayments in their accounts payable. The role looks after a large on-premises SQL Server estate, with databases of 30 to 40 terabytes on Pure Storage FlashArray, and brings order to how it is permissioned, monitored, backed up and tuned.

The company has grown fast and is investing heavily in AI, and the position is expected to recommend and lead improvements to the environment, not only handle the day-to-day requests.

Comfortable being the escalation point when a database issue comes up, and steady while working it through
Someone who uses AI tools in their own work and is curious about what they can do for a database team
Location: Remote (Toronto)
Install, configure, patch and upgrade SQL Server instances in a primarily on-premises environment, keeping downtime to a minimum
Tune performance through indexing, query optimization, partitioning and compression, including on 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 (moves, archives, permission requests) and the monthly deployment, alongside an offshore DBA
Assess how AI tools such as Claude and Copilot connecting to the environment affect its databases and applications
Work with the infrastructure-as-a-service provider, data engineering and development on promotions to production
⭐ 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
- Advanced performance tuning, including indexing, query optimization, partitioning and compression on very large databases
- Scripting and automation with PowerShell or Python
- Experience designing permission and access models, security policies and database standards
- A track record of assessing a database environment and leading the changes that improve it
- Clear communication with infrastructure, data engineering and development teams

Experience with Azure SQL Database or Azure SQL Managed Instance
PostgreSQL experience, particularly on AWS
Microsoft SQL Server or Azure database certifications
Experience with Azure DevOps deployments
Room to Improve: The hiring manager wants someone who will recommend changes to the environment and see them through, from permissions to backups and monitoring
Databases of 30 to 40 terabytes, where partitioning, compression and indexing decisions make a visible difference
Growth into PostgreSQL and AWS: A new product is being built on AWS with PostgreSQL, and the role is expected to pick up those skills within six months to a year
Team: An easygoing group that works closely across infrastructure, data engineering and development, with colleagues in the Toronto area who meet up occasionally
Paid Time Off: Competitive vacation and personal days to maintain a healthy work-life balance
Health Benefits: Competitive Vacation with Comprehensive Health Perks
Ready to Bring Structure to a Large SQL Server Estate? At STACK IT Recruitment, we connect top talent with standout opportunities. If you meet at least 70% of the qualifications, we encourage you to apply — we'd love to chat!
Share it with your network — you might just help someone take the next big step in their career.
✨ We're proud to support diversity and inclusion. AI Use Disclosure: STACK IT uses AI-enhanced tools to support initial candidate screening and interview note analysis.

📌 Database Administrator REMOTE (Vaughan)
🏢 STACK IT Recruitment
📍 Vaughan