Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Database Administrator role.
Rezi rewrites your resume against STACK IT Recruitment's job description. Free.
Tailor your resume to this Database Administrator role.
Rezi rewrites your resume against STACK IT Recruitment's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Database Administrator posting at STACK IT Recruitment — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Database Administrator posting at STACK IT Recruitment — free, in seconds.
About the Role
This 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.
Responsibilities
- Install, configure, patch and upgrade SQL Server instances in a primarily on-premises environment, keeping downtime to a minimum
- Implement and maintain high availability and disaster recovery with Always On availability groups, failover clustering and replication
- 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
Requirements
- 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, including indexing, query optimization, partitioning and compression on very large databases
- Scripting and automation 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 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 Redgate tools
- Experience with Azure DevOps deployments
Skills
- SQL Server
- Pure Storage FlashArray
- PowerShell
- Python
- AI tools
- Always On availability groups
- Failover clustering
- Replication
- Indexing
- Query optimization
- Partitioning
- Compression
- Azure SQL Database
- Azure SQL Managed Instance
- PostgreSQL
- AWS
- Redgate tools
- Azure DevOps
Location
- Remote (Toronto)
Work Type
- Remote
- Full-time
Experience Level
- 5+ years of experience as a SQL Server Database Administrator
Education Level
- Microsoft SQL Server or Azure database certifications
Salary/Compensations
- $100,000 – $130,000
Benefits
- Competitive vacation and personal days to maintain a healthy work-life balance
- Competitive Vacation with Comprehensive Health Benefits
About the Company
- An established recovery-audit firm that helps large corporations find and recover overpayments in their accounts payable.
- The company has grown fast and is investing heavily in AI.
Equal Opportunity
- We're proud to support diversity and inclusion. Need accommodation during the hiring process? Just let us know — we're here to support you!