Finance Systems DBA Lead — Hybrid, Cloud & Security

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

Benefits offered by this job

Hybrid work environment

Health benefits

Pension plan

Paid time off

Learning & development

Job summary

CIRO in Vancouver is seeking a Senior Database Administrator to ensure performance, reliability, and security of Finance Systems and enterprise data. You will manage SQL Server and Postgres databases, support Business Central, Adaptive Insights, MIS_CAM, and oversee encryption, backups, and audits.

The role emphasizes cloud and hybrid integration, Azure Arc, VNets, and Power Platform tooling, with an on‑call rotation and opportunities to modernize pipelines and automation.

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 SQL Server administration, query tuning, indexing, and performance optimization.
• 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

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

Skills

SQL Server DBA

PostgreSQL administration

Cloud & hybrid environments

Security & compliance

Power Platform experience

Tools

SSIS

SSRS

Power BI

MDS

Power Automate

Power Apps

Dataverse

Azure Arc

Azure VNets/Gateways

Dynamics 365 Business Central

Job description

CIRO in Vancouver is seeking a Senior Database Administrator to ensure performance, reliability, and security of Finance Systems and enterprise data. You will manage SQL Server and Postgres databases, support Business Central, Adaptive Insights, MIS_CAM, and oversee encryption, backups, and audits.

The role emphasizes cloud and hybrid integration, Azure Arc, VNets, and Power Platform tooling, with an on‑call rotation and opportunities to modernize pipelines and automation.