Senior Database Administrator

CIRO / OCRI; Toronto, Montreal , Calgary, Vancouver; Hybrid; CAD 93,000 - 110,000; Full time

Benefits offered by this job

Competitive base salary

Performance bonus

Hybrid work environment

Health benefits and spending account

Pension plan with company match

Paid flex days and sick days

Parental leave top up

Continuous learning and development

Job summary

CIRO seeks a Senior Database Administrator to safeguard the performance, reliability, and integrity of our Finance Systems. You will manage SQL Server and Postgres, tune queries, and support hybrid Azure-based infrastructure in a regulated environment.

Collaborate with Finance, Support and Development teams, drive encryption, security standards, and on-call rotation, while contributing to automation and modernization initiatives in a Canadian regulatory setting.

Qualifications

• 5+ years hands-on SQL Server DBA experience.
• 2+ yrs hands on Postgres Administration.
• Experience with integrations (SSIS, APIs, ETL tools).
• Knowledge of security, governance, and audit requirements.
• Proficiency in Azure technologies and hybrid connectivity.
• Hands-on experience with database encryption and secure connectivity.

Responsibilities

• Manage and optimize SQL Server and Postgres databases supporting Finance Systems.
• Support Business Central, Adaptive Insights, MIS_CAM Engine, and related integrations.
• Maintain database encryption and secure connectivity standards.
• Support hybrid environments using Azure Arc, VNets, and Gateways.
• Troubleshoot and maintain data pipelines and integration jobs.
• Execute DR/Backup/restore procedures.
• Participate in on‑call rotation with Senior DBA.
• Contribute to automation and modernization initiatives.
• Implement secure configurations, encryption standards, and access policies.
• Ensure readiness for audits and compliance obligations
• Automate tasks using (PowerShell preferred).
• Collaborate with Finance, Support and Business Systems and Development teams, communicating effectively and translating technical concepts to non‑technical audiences.

Skills

SQL Server

PostgreSQL

Performance tuning

Security & encryption

Azure Arc

ETL tools (SSIS, APIs)

Power BI / BI tools

Power Platform

Data integration

On-call rotation

Tools

SSIS

SSRS

Power BI

MDS

Azure Arc

Power Automate

Business Central

Job description

40 Temperance Street
Suite 2600
Toronto, ON M5H0B4, CAN

Locations

Showing 1 location 40 Temperance Street
Suite 2600
Toronto, ON M5H0B4, CAN

• Hybrid
• Full-Time
• Requisition #: SENIO002656

Description

CIRO is seeking a highly capable Senior Database Administrator (DBA) to support the performance, reliability, and integrity of our Finance Systems and enterprise data ecosystem. This role strengthens operational resilience, supports complex Finance System integrations, and eliminates the current single point of failure within our DBA function.

We are seeking a candidate who brings a blend of strong technical skills, cloud and integration experience, and the competencies required to operate effectively in a highly collaborative, compliance‑driven environment.

Key Responsibilities

• Manage and optimize SQL Server and Postgres databases supporting Finance Systems.
• Support Business Central, Adaptive Insights, MIS_CAM Engine, and related integrations.
• Maintain database encryption and secure connectivity standards.
• Support hybrid environments using Azure Arc, VNets, and Gateways.
• Troubleshoot and maintain data pipelines and integration jobs.
• Execute DR/Backup/restore procedures.
• Participate in on‑call rotation with Senior DBA.
• Contribute to automation and modernization initiatives.
• Implement secure configurations, encryption standards, and access policies.
• Ensure readiness for audits and compliance obligations
• Automate tasks using (PowerShell preferred).
• Collaborate with Finance, Support and Business Systems and Development teams, communicating effectively and translating technical concepts to non‑technical audiences.
• Documentation of processes and consistent knowledge sharing.

Core Competencies

• Technical Expertise
• Problem Solving & Analytical Thinking
  • Strong analytical skills for diagnosing and resolving system issues.
  • Ability to identify long‑term solutions and anticipate risks.
• Collaboration & Stakeholder Engagement
• Ownership & Accountability
  • Strong accountability for database stability, uptime, and security.
• Security & Compliance Mindset
• Adoption of cloud and hybrid modernization practices.

Qualifications

Required:

• 5+ years hands‑on SQL Server DBA experience.
  • Strong SQL tuning, indexing, and optimization skills.
  • Production support and incident management.
  • Deployment and configuration activities.
• 2+ yrs hands on Postgres Administration
• Experience with integrations (SSIS, APIs, ETL tools).
• Knowledge of security, governance, and audit requirements.
• Proficiency in SQL Server administration, query tuning, indexing, and performance optimization.
• Troubleshooting complex database and integration issues.
  • Master Data Services (MDS)
  • SSRS
  • SSIS
  • Power BI Report Server (on‑prem)
• Hands‑on experience with database encryption (TDE, Always Encrypted, encryption‑at‑rest/in‑flight).
• Practical experience with Azure technologies: Azure Arc, Azure Virtual Networks (VNet), Gateways, hybrid connectivity.
• Experience with Microsoft Power Platform (Power Automate, Power Apps, Dataverse).
• Experience supporting Microsoft Dynamics 365 Business Central

Preferred:

• Experience with Business Central.
• Experience with Adaptive Insights and MIS_CAM Engine.
• Experience with Microsoft Power Platform.
• PowerShell scripting experience.
• Experience in regulated environments.

What we offer

• Competitive base salary in alignment with market
• Performance based bonus *
• Hybrid work environment
• Employer paid Health Benefits and Spending Account that offer flexibility to meet your individual or family needs as of day one
• Defined Contribution Pension Plan with company matching that starts on your first day of employment *
• Paid flex days and sick days *
• Maternity Leave Of Absence/Paternity Leave Of Absence top up *
• Paid continuous learning and continuing development including designations

Why the Canadian Investment Regulatory Organization (CIRO)

With offices across Canada - from Vancouver to Montreal, our mission is to promote healthy capital markets by regulating fairly and effectively so that investors are protected and confident investing in their futures. As regulators, we understand that we are all investors, and therefore a career with us is a purposeful career: protecting our future.

Culture and Working Environment

Life at CIRO is purpose and performance‑driven. We foster an inclusive culture where teamwork, a forward‑thinking attitude, and integrity are at the core of everything we do. This creates an environment where employees thrive, grow, and are empowered to learn and contribute their best.

Joining CIRO means becoming part of a dynamic and transparent organization that values accountability and is committed to maintaining the highest standards of regulatory oversight in the financial industry.

Looking for a career where you can safeguard the integrity of Canadian markets? Join CIRO and be part of the team that secures our financial future.

At CIRO, you’ll be part of an organization driven by Pride in Excellence, a strong Focus on Well‑being, and A Shared Purpose that connects our people to meaningful work. We’re committed to fostering an inclusive, supportive environment where you can grow and make an impact. Learn more about what it’s like to build your career at CIRO by exploring our Careers page: https://www.ciro.ca/about-ciro/careers

Our Commitment

CIRO is an equal opportunity employer and is committed to providing employment accommodationin accordance withthe Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CIRO will provide accommodation to job applicants with disabilities throughout the recruitment process.So you require accommodation, please contact Human Resources.

We are committed to creating an inclusive and barrier-free recruitment and selection process across Canada. We welcome applications from all qualified individuals and are dedicated to providing accommodations upon request for candidates participating in all aspects of the recruitment process, in accordance with applicable human rights and accessibility legislation.

Our Recruitment Process

• This posting reflects an active vacancy on our team
• We use automated (AI) tools toassistwith candidate sourcing and communications. Applications are reviewed by our hiring team and hiring decisions are made by people.
• This role has a hiring range of $92,500 - $110,000 with the placement and offered salary being based on knowledge, skills, education/training and experience, as well as external market conditions and internal equity.