Senior Database Administrator

Investment Industry Regulatory Organization of Canada

$92K — $114K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Over 5 years of hands-on experience as a SQL Server DBA.
  • Strong skills in SQL performance tuning and optimization.
  • Experience with database encryption technologies like TDE and Always Encrypted.
  • Familiarity with Azure Arc, VNets, and hybrid workloads.
  • Proficient in managing complex database integrations (SSIS, APIs, ETL tools).
  • Solid understanding of security, governance, and compliance within databases.

Responsibilities

  • Manage and optimize SQL Server databases for Finance Systems.
  • Support integrations for Business Central and Adaptive Insights.
  • Maintain high standards for database security and encryption.
  • Manage operations in hybrid environments utilizing Azure technologies.
  • Troubleshoot issues with data pipelines and integration jobs.
  • Execute disaster recovery and database backup/restore procedures.
  • Automate repetitive tasks using PowerShell.

Benefits

  • Hybrid work environment promoting work-life balance.
  • Comprehensive health benefits with flexibility from day one.
  • Defined Contribution Pension Plan with immediate matching contributions.
  • Paid continuous learning opportunities for professional development.
  • Paid vacation, flex days, sick days, and parental leave top-up.
Full 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.

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.
  • 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.
  • 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
  • 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 (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 *
  • Vacation days
  • Maternity Leave Of Absence/Paternity Leave Of Absence top up *
  • Paid continuous learning and continuing development including designations


OurRecruitment 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 - $114,650 with the placement and offered salary being based on knowledge, skills, education/training and experience, as well as external market conditions and internal equity.


While we appreciate receiving applications, only those applicants who closely meet the position requirements will be contacted. #LI-HYBRID#Hiring

Similar Jobs

More Jobs at Investment Industry Regulatory Organization of Canada

More Information Technology Jobs

Find similar Senior Database Administrator jobs: