Microsoft SQL Database Administrator

RWAM Insurance Administrators Inc.; Elmira; On-site; CAD 100,000 - 130,000; Full time

Benefits offered by this job

Group benefits

Professional development

Elmira office

Job summary

RWAM Insurance Administrators Inc. in Elmira, Ontario, is seeking an experienced Microsoft SQL Database Administrator to join our IT team.

You will ensure performance, security, and availability of RWAM's SQL Server environments across production, test, and development, in both on‑prem and Azure cloud contexts. You will work with development, infrastructure, and cybersecurity teams on modernization initiatives, including a claims system rewrite and auto-adjudication enhancements, while

Qualifications

• 3–5+ years hands-on experience administering Microsoft SQL Server in a production enterprise environment.
• Strong knowledge of SQL Server internals, T‑SQL, indexing, and query performance tuning.
• Experience with high-availability/disaster-recovery technologies.
• Solid understanding of database security best practices for insurance/financial services data.
• Experience with backup/recovery tools and job scheduling/automation (SQL Server Agent, JAMS).
• Familiarity with Windows Server administration as it relates to SQL Server (2016+).
• Experience with cloud/hybrid SQL Server environments (Azure SQL, Azure VMs, AWS RDS) is a plus.
• Microsoft certification (e.g., Azure Database Administrator Associate) is an asset.

Responsibilities

• Install, configure, upgrade, and maintain SQL Server instances across production, test, and development environments.
• Monitor database performance, tune queries, indexes, and stored procedures, and resolve performance bottlenecks.
• Design, implement, and test backup, restore, and disaster recovery strategies to meet RPO/RTO targets.
• Manage database security, including RBAC, encryption, and auditing per regulatory requirements.
• Implement high-availability and replication where applicable.
• Develop and maintain automated jobs, maintenance plans, and monitoring/alerting using SQL Server Agent and JAMS.
• Perform capacity planning and forecasting for database growth.
• Troubleshoot and resolve production incidents, including on-call support and root-cause analysis.
• Maintain documentation for database architecture, standards, procedures, and change management records.

Skills

SQL Server internals

T-SQL

Indexing strategies

Query performance tuning

PowerShell

Azure SQL/Azure VMs

Scripting for automation

Education

Post-secondary diploma or degree in Computer Science/Information Systems or related field

Tools

SQL Server Agent

JAMS

Azure SQL

Job description

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.

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.

Navacord DOES NOT utilize artificial intelligence in the screening, assessment, or selection of applicants for this position.