Microsoft SQL Database Administrator

About RWAM RWAM Insurance Administrators Inc. is a leading Canadian third-party administrator providing group benefits, retirement, and insurance administration solutions to plan sponsors, advisors, and members across the country. Our Information Technology team supports mission-critical systems that process claims, adjudicate benefits, and manage sensitive member data, and is currently investing in a multi-year modernization program spanning our claims system, renewals platform, and spending accounts capabilities. The Opportunity RWAM 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 RWAM's 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. Key Responsibilities 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. Manage database security, including role-based access control, encryption at rest and in transit, and auditing, in alignment with RWAM's cybersecurity standards and applicable regulatory requirements (e.g., PHIPA/PIPEDA). 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 RWAM's data platform. What You Bring 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. Exposure to insurance, group benefits, or other regulated financial services environments 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. Excellent communication skills, with the ability to translate technical concepts for non-technical stakeholders. What RWAM Offers A collaborative IT team supporting meaningful, high-impact modernization projects. Competitive compensation and comprehensive group benefits, reflecting our own expertise as a benefits administrator. Opportunities for professional development, training, and certification. A supportive, flexible work environment based out of our Elmira, Ontario office. The salary range for this role is $100,000 to $130,000 per year. Compensation is determined by a combination of factors including a candidate’s experience, job-specific knowledge, and skills. Interested candidates are invited to submit a resume and cover letter outlining their relevant experience. Navacord, and all our Broker Partners are actively committed to supporting diversity, equity, and inclusion. We serve and recognize and respect human differences and similarities. We value the diversity of people and actively encourage women, indigenous peoples, members of visible minorities, people with disabilities, and lesbian, gay, bisexual, transgender, and queer (LGBTQ2+) persons to apply. We are committed to providing accommodation upon request for applicants and employees with disabilities. If you require accommodation, we will work with you to meet your needs. Interested candidates are invited to submit a resume and cover letter outlining their relevant experience. Navacord DOES NOT utilize artificial intelligence in the screening, assessment, or selection of applicants for this position.

The Microsoft SQL Database Administrator is responsible for the performance, availability, security, and integrity of RWAM's SQL Server database environments. This includes installing, configuring, and maintaining SQL Server instances, monitoring performance, and managing database security.

Candidates should have 3-5+ years of experience administering Microsoft SQL Server in a production environment, with strong knowledge of SQL Server internals and database security best practices. A post-secondary diploma or degree in Computer Science or a related field is preferred, along with relevant certifications.

• Health Insurance • Comprehensive Group Benefits • Professional Development • Training • Certification

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Microsoft SQL Server
• T-SQL
• Indexing Strategies
• Query Performance Tuning
• High-Availability
• Disaster Recovery
• Database Security
• Encryption
• Access Control
• Backup Recovery Tools
• Job Scheduling
• Automation
• Windows Server Administration
• Cloud Environments
• PowerShell
• Scripting Languages

• Technology
• Software
• Data & Analytics
• Finance & Accounting
• Administrative

Formation minimale

Études secondaires

Expérience minimale

5+ ans

Postuler avant le

15 août 2026

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Niveau d’expérience

Mid-Senior level

Mode de candidature

La candidature directe est offerte