Senior Database Administrator

CIRO / OCRI; Toronto; Hybrid; CAD 92,500 - 114,650; Full time

Benefits offered by this job

Competitive base salary

Performance-based bonus

Employer-paid Health Benefits

Defined Contribution Pension Plan

Paid learning and development days

Job summary

CIRO / OCRI is looking for a Senior Database Administrator (DBA) in Toronto, Ontario, to enhance the performance and reliability of its Finance Systems. The role involves managing SQL Server databases, troubleshooting complex integrations, and ensuring data security.

Candidates should have over 5 years of SQL DBA experience, strong skills in SQL tuning, and the ability to work in hybrid environments related to Azure. CIRO offers competitive salary and comprehensive benefits, including health and pension plans.

Qualifications

• 5+ years hands-on SQL Server DBA experience.
• Strong SQL tuning, indexing, and optimization skills.
• Hands-on experience with database encryption technologies.

Responsibilities

• Manage and optimize SQL Server databases supporting Finance Systems.
• Support Business Central and related integrations.
• Troubleshoot and maintain data pipelines and integration jobs.

Skills

SQL tuning

Database encryption

Performance optimization

Troubleshooting

Education

5+ years of SQL Server DBA experience

Tools

Azure Arc

PowerShell

Microsoft Power Platform

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

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.
• Support Power Platform-driven workflows.
• 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.
• Document processes and share knowledge.

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
• Continuous Improvement & Automation
  • Adoption of cloud and hybrid modernization practices.

Qualifications

Required:

• 5+ years hands‑on SQL Server DBA experience.
• Strong 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, 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.

Benefits

• Competitive base salary in alignment with market.
• Performance‑based bonus.
• Hybrid work environment.
• Employer‑paid Health Benefits and Spending Account offering flexibility from day one.
• Defined Contribution Pension Plan with company matching beginning on first day of employment.
• Paid flex days and sick days.
• Vacation days.
• Maternity Leave Of Absence/Paternity Leave Of Absence top up.
• Paid continuous learning and continuing development including designations.

Salary Range

$92,500 - $114,650 (based on knowledge, skills, education/training and experience, as well as external market conditions and internal equity).

Equal Opportunity Employer

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.