Get the latest updates on AI-powered hiring, career growth, and technical deep-dives delivered to your inbox.
LRO Staffing
City: Waterloo
Salary: $100,000.00+/yr
Added: July 22, 2026
SQL Database Administrator, DBA - Permanent - 19299
Our client is seeking an experienced Microsoft SQL Database Administrator to join our IT team. Reporting to the Vice President, Information Technology, this role is responsible for the performance, availability, security, and integrity of SQL Server database environments, which underpin our core insurance administration and claims platforms.
You will work closely with development, infrastructure, and cybersecurity teams to support ongoing initiatives including a claims system re-write, claims auto-adjudication enhancements, and a new renewals system, while ensuring our production databases remain secure, resilient, and performant. This is a replacement role.
Install, configure, upgrade, and maintain Microsoft SQL Server instances across production, test, and development environments platformed in Microsoft Azure
Monitor database performance, proactively tune queries, indexes, and stored procedures, and resolve performance bottlenecks affecting claims and administration systems
Design, implement, and test backup, restore, and disaster recovery strategies to meet defined RPO/RTO targets for business-critical systems
Implement and maintain high-availability and replication where applicable
Develop and maintain automated jobs, maintenance plans, and monitoring/alerting for database health using tools such as SQL Server Agent and our batch scheduling tool (JAMS)
Perform capacity planning and forecasting for database growth
Troubleshoot and resolve production incidents, including participation in on-call support and root-cause analysis for database-related issues
Maintain documentation for database architecture, standards, procedures, and change management records
Support internal and external audits by providing evidence of database controls, security configurations, and change history
Evaluate and recommend new tools, technologies, and best practices to continuously improve the reliability and efficiency of data platform
3–5+ years of hands-on experience administering Microsoft SQL Server in a production enterprise environment
Strong knowledge of SQL Server internals, T-SQL, indexing strategies, and query performance tuning
Experience with high-availability/disaster-recovery technologies
Solid understanding of database security best practices, including encryption, access control, and compliance considerations relevant to insurance or financial services data
Experience with backup/recovery tools and job scheduling/automation platforms (e.g., SQL Server Agent, JAMS, or similar)
Familiarity with Windows Server administration as it relates to SQL Server (2016 or later)
Experience supporting SQL Server in cloud or hybrid environments (Azure SQL, Azure VMs, or AWS RDS) is an asset
Working knowledge of PowerShell or other scripting languages for automation of routine DBA tasks is an asset
Post-secondary diploma or degree in Computer Science, Information Systems, or a related field, or equivalent experience
Microsoft certification (e.g., Azure Database Administrator Associate, or equivalent SQL Server certification) is an asset
Strong analytical and problem-solving skills, with the ability to manage competing priorities and work independently
Hybrid position in Waterloo
$110,000 to $130,000/yr DOE
3 days a week in the office in Waterloo
Work for a great leader
Please apply by clicking the “” button below and follow the instructions to submit your résumé. You can also apply by submitting your résumé directly to jpbaragwanath@lrostaffing.com. If you are already registered with us, please contact your Senior Recruiter. Please quote job 19299.
LRO Staffing values fairness, confidentiality, and human judgment in every stage of our hiring process. We do not use automated or AI-driven screening tools to assess applications. Each submission is reviewed by an experienced recruiter to ensure a thoughtful and equitable evaluation of every candidate.
Thank you for your interest in this role. One of our Recruiters will be in touch with you if your profile meets the requirements for the role and the expectations of our clients. Please note that all candidates must be permitted to work in Canada to be considered for this opportunity.
#LI-CA1 #LI-Hybrid
Most resumes get rejected by the ATS before a human sees them. Check yours free in 30 seconds.
Matched to your profile
We surface this role because it matches profiles like yours, not because we vet the employer. Always confirm the pay, location, and remote details on LRO Staffing's official site before you apply.
Most large employers screen resumes with software before a recruiter ever sees them. Check yours against this role in seconds. Free, no sign-up.
See the exact keywords from this posting your resume is missing, with an instant ATS score.
Open free toolUpload your CV for an instant 0-100 score and the fixes recruiters and ATS look for.
Open free toolGenerate a clean, single-column resume that parses correctly and gets past the filters.
Open free toolOther live openings in the same field. All are still accepting applications.
Mindwire
Victoria, BC
Brainhunter
Victoria, BC
Weir Group
Halifax, NS
CGI Inc.
Halifax, NS
Integrated Staffing Limited
Dartmouth, NS
New Flyer
Winnipeg, MB