40 Temperance Street Suite 2600 Toronto, ON M5H0B4, CAN

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 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

Solid 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.

Solid SQL tuning, indexing, and optimization skills.

Hands‑on experience with database encryption technologies.

Experience with Azure Arc, VNets, Gateways, and hybrid workloads.

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.

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

Our Commitment
CIRO is an equal opportunity employer and is committed to providing employment accommodation in accordance with the 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. Should 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.

#J-18808-Ljbffr

📌 Senior Database Administrator (Ontario)
🏢 Canadian Investment Regulatory Organization
📍 Ontario