The role will design, develop, test, deploy, and support secure, scalable data solutions that consolidate identity and access data from enterprise source systems into a centralized operational data store.
Senior Database Administrator responsible for design, administration, reliability, performance, and security of Azure-based SQL Server environments, data engineering, and platform responsibilities.
Responsibilities
Design, administer, and support Azure SQL and SQL Server environments
Maintain high-availability clusters and elastic pools
Perform performance tuning, index maintenance, capacity planning, backup, restore, and disaster recovery
Configure security and compliance
Implement monitoring, alerting, and on-call operations
Requirements
Bachelor's degree in Computer Science, Information Systems, Data Science, or related technical field
Nice to have: Data engineering or ETL/ELT development
Nice to have: Medallion architecture or lakehouse patterns
Responsible for installing, configuring, securing, maintaining, and optimizing database platforms to ensure their availability, performance, recoverability, and integrity.
Responsibilities
Install, configure, and upgrade MSSQL and PostgreSQL database servers
Create, modify, and maintain database objects, including tables, indexes, views, and stored procedures
Monitor database performance and implement tuning strategies
Develop and maintain backup strategies
Implement and maintain high-availability and disaster-recovery solutions, including replication, clustering, and failover technologies
Requirements
Bachelor’s degree in computer science, information technology, or a related discipline preferred, or equivalent professional experience
Lead the technical delivery of complex, cloud‑native and AI‑enabled engagements, contributing as a hands‑on individual contributor and, where required, leading engineering teams to ensure high‑quality, predictable outcomes.
Responsibilities
Lead the technical delivery of complex, cloud‑native and AI‑enabled engagements
Define and drive the technology strategy for large and complex customer engagements
Design, develop, and deploy solutions on Microsoft Azure
Applies user‑centered design principles to translate customer needs into clear technical requirements and scalable solution designs
Provide delivery leadership by setting technical priorities, estimating effort, managing dependencies, making disciplined trade‑offs, and driving successful releases
Requirements
Bachelor's degree in computer science engineering, or a related field
Nice to have: AZ‑204 (Developing Solutions for Microsoft Azure)
Nice to have: AI‑102 (Designing and Implementing an Azure AI Solution)
Nice to have: MCSD / MCSE or equivalent modern cloud and AI certifications
Senior Administrator, Database will provide hands‑on leadership and technical expertise in support, maintenance and modernization of Microsoft SQL Server environments across a large enterprise portfolio.
Locations (2)
Sparwood, British Columbia, Canada
Calgary, Alberta, Canada
Compensation
Salary: $96,000 - $113,000 CAD/year
Responsibilities
Participate in and adhere to health and safety programs and policies
Provide senior-level administration and troubleshooting for business‑critical SQL Server environments, taking ownership of complex production issues through resolution
Monitor and optimize database performance, capacity, availability and reliability; administer high availability, replication, backup and disaster recovery, including Always On Availability Groups, clustering and Commvault
Lead SQL Server installations, patching, upgrades, migrations, consolidation and platform modernization initiatives
Maintain SQL Server security, address vulnerabilities, manage compliance needs and provide technical support and evidence for internal and external audits
New York City, Boston, and Washington DC Metro Areas, Washington State, and Southern California offices – $92,900 to $153,900
Bay Area California offices – $96,000 to $160,500
All other offices locations in the US, including Sacramento – $77,500 to $140,900
Responsibilities
Design, develop, test, and maintain robust data pipelines and database solutions supporting the IAM Operational Data Store and related reporting applications.
Analyze source-system data and translate business, reporting, risk, and control requirements into scalable conceptual, logical, and physical data models.
Develop and optimize Microsoft SQL Server and Azure SQL objects, including complex queries, stored procedures, views, functions, indexing, partitioning, and transformation logic.
Build repeatable ETL and ingestion patterns for identity, account, entitlement, credential, inventory, activity, certification, lifecycle, and control-related data.
Develop and maintain SnapLogic pipelines and supporting scripts for data extraction, transformation, validation, reconciliation, and loading.
Requirements
Bachelor’s degree in computer science, data engineering, information technology, information systems, or a related field, or equivalent practical experience