Senior Database Administrator
Role Overview
CIRO seeks a Senior Database Administrator to support the performance, reliability, and integrity of Finance Systems and the enterprise data ecosystem.
The role supports operational resilience, complex finance-system integrations, and reducing a single point of failure in the DBA function.
The work takes place in a hybrid environment.
Key Skills for This Role
Full Job Posting
Role overview
CIRO seeks a Senior Database Administrator to support the performance, reliability, and integrity of Finance Systems and the enterprise data ecosystem.
The role supports operational resilience, complex finance-system integrations, and reducing a single point of failure in the DBA function.
The work takes place in a hybrid environment.
Key responsibilities
- Manage and optimize SQL Server and PostgreSQL databases supporting Finance Systems.
- Support Business Central, Adaptive Insights, MIS_CAM Engine, and related integrations.
- Maintain database encryption and secure connectivity; support Azure Arc, Virtual Networks, and Gateways in hybrid environments.
- Troubleshoot and maintain data pipelines and integration jobs; execute disaster recovery, backup, and restore procedures.
- Support Power Platform workflows and participate in an on-call rotation with the Senior DBA.
- Contribute to automation and modernization; implement secure configurations, encryption standards, and access policies.
- Ensure audit and compliance readiness, automate tasks, and document processes and share knowledge.
- Collaborate with Finance, Support, Business Systems, and Development teams, explaining technical matters to non-technical audiences.
Required qualifications
- At least five years of hands-on SQL Server DBA experience and two years of hands-on PostgreSQL administration.
- Strong SQL tuning, indexing, optimization, production support, incident management, deployment, and configuration experience.
- Experience with integrations such as SSIS, APIs, or ETL tools, and troubleshooting complex database and integration issues.
- Knowledge of security, governance, audit requirements, and database encryption, including TDE, Always Encrypted, or encryption at rest and in flight.
- Practical Azure experience with Azure Arc, Virtual Networks, Gateways, and hybrid connectivity.
- Experience with Master Data Services, SSRS, and on-premises Power BI Report Server.
- Business Central, Adaptive Insights, MIS_CAM Engine, Microsoft Power Platform, PowerShell, and regulated-environment experience are preferred.
Core competencies
- Strong analytical problem-solving skills to diagnose issues, identify long-term solutions, and anticipate risks.
- Accountability for database stability, uptime, and security.
- Collaboration, stakeholder engagement, continuous improvement, and automation.
Benefits
- Competitive base salary and performance-based bonus.
- Employer-paid health benefits and spending account, a defined contribution pension plan with company matching, paid flex and sick days, and vacation days.
- Maternity and paternity leave top-up, and paid continuous learning and professional development.
Hiring range
- The stated hiring range is $92,500–$110,000; placement depends on qualifications and market and internal equity considerations.
- The posting does not specify a salary payment cadence.
About CIRO
CIRO regulates Canadian capital markets with the stated mission of promoting fair and effective regulation and protecting investors.
The organization describes its culture as inclusive, collaborative, accountable, and focused on continuous learning.
Recruitment process
- The posting states that this is an active vacancy and that hiring decisions are made by people, although automated tools assist candidate sourcing and communications.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at CIRO / OCRI
Senior Database Administrator
Vancouver, CAN
CIRO is seeking a Senior Database Administrator to strengthen the reliability, security, and performance of its finance databases and integrations. The role requires substantial SQL Server and PostgreSQL administration e
Director, Innovation
Calgary, CAN
CIRO is seeking a Director of Innovation to lead industry transformation initiatives, its InnovateSafe regulatory innovation program, and its AI and Automation Centre of Excellence. The role combines team leadership, sta
Director, Innovation
Montréal, CAN
CIRO seeks a Director, Innovation to lead its regulatory innovation program and AI & Automation Centre of Excellence. The role requires 10+ years in investment or investment regulation, a related bachelor’s degree, team
Director, Innovation
Toronto, CAN
CIRO seeks a Director of Innovation to lead its regulatory innovation program and AI & Automation Centre of Excellence. The role manages a team, engages industry stakeholders, assesses emerging risks and technologies, an
Director Member Services & Innovation
Vancouver, CAN
CIRO seeks a director to lead its innovation mandate, InnovateSafe regulatory innovation program, and AI & Automation Centre of Excellence. Candidates need 10+ years in investment industry or regulation, a related bachel
Directeur ou directrice de l’innovation
Vancouver, CAN
L’OCRI recherche un directeur ou une directrice pour piloter ses projets d’innovation réglementaire et son centre d’excellence en IA et en automatisation. Le poste requiert au moins dix ans d’expérience pertinente, un ba
Director Member Services & Innovation
Calgary, CAN
CIRO seeks a director to lead its innovation program and AI & Automation Centre of Excellence while managing the Member Services and Innovation team. Candidates need 10+ years in investment or investment regulation, a re
Directeur ou directrice de l’innovation
Calgary, CAN
L’OCRI recherche une personne pour diriger ses initiatives d’innovation réglementaire ainsi que son centre d’excellence en IA et en automatisation. Le poste comprend la direction d’équipe, la gestion de projets complexes
Senior Database Administrator
Vancouver, CAN
Director, Innovation
Calgary, CAN
Director, Innovation
Montréal, CAN
Director, Innovation
Toronto, CAN
Director Member Services & Innovation
Vancouver, CAN
Directeur ou directrice de l’innovation
Vancouver, CAN
Director Member Services & Innovation
Calgary, CAN
Directeur ou directrice de l’innovation
Calgary, CAN