2,086,712open jobs
127,868companies
237,718added this week
Browse all
Location
In office (Edmonton)
Seniority
Senior · 7+ years exp

Confirmed on the employer's own hiring board on Nov 3, 2026. First seen by Alion on Nov 2, 2026.

Overview
Company
Impact
Profile match
Alberta Pensions Services Corporation (APS) provides comprehensive pension administration services for Alberta’s public sector pension plans. APS manages contributions, benefits, and communications for over 420,000 members and pensioners, ensuring accurate and cost-effective service.

What you’re passionate about

You're the calm, methodical problem-solver who is at your best when business-critical systems need to be reliable, secure, performant, and recoverable. You combine deep SQL Server expertise with practical operational judgment, and you know that strong monitoring, documentation, disciplined change practices, and continuous improvement are what keep services resilient. You enjoy working with application teams, infrastructure colleagues, and vendors to troubleshoot complex issues, improve database performance, reduce recurring effort, and strengthen service continuity. When incidents happen, you bring composure, accountability, and a risk-aware mindset to get to the right outcome.

A typical day for the Senior Database Administrator

Administer APS SQL Server platforms across production and non-production environments, including installation, configuration, monitoring, maintenance, patching, upgrades, refreshes, security administration, and capacity planning.

Monitor database health, availability, performance, and capacity; identify emerging issues and implement practical remediation before service is affected.

Analyze and tune SQL workloads using execution plans, wait statistics, indexing strategies, statistics maintenance, and configuration changes.

Design, support, and test high-availability and disaster-recovery solutions, including SQL Server Availability Groups, failover procedures, and database recovery objectives.

Manage database security through role-based access, least-privilege administration, service accounts, encryption, auditing, and periodic access reviews.

Own SQL Server backup, restore, and recovery processes, including backup validation, point-in-time recovery, and regular restore testing in coordination with the enterprise backup platform.

Support database deployments, migrations, upgrades, and application changes by reviewing technical designs, assessing risk, and coordinating implementation and rollback plans.

Develop and maintain automation, monitoring, standards, procedures, and runbooks using T-SQL, PowerShell, and centralized administration tools to reduce risk and recurring manual effort.

Participate in on-call support rotations, troubleshoot incidents, lead database-focused root cause analysis, and implement corrective actions that prevent recurrence.

 

What you bring

A degree or diploma with 5-6 years of directly related experience; or a certificate with 7-9 years of directly related experience.

In-depth knowledge of enterprise database administration using MS SQL Server, including database design, installation, configuration, maintenance, performance optimization, security, and lifecycle management.

Advanced knowledge of relational database concepts, data modelling, indexing, query execution plans, and support for high-availability, high-reliability business applications.

Strong experience with database performance monitoring and tuning, capacity planning, fault isolation, data integrity checks, and evidence-based remediation.

Hands-on experience implementing and supporting SQL Server high-availability and disaster-recovery technologies, such as Availability Groups, clustering, replication, log shipping, or equivalent solutions.

Strong knowledge of SQL Server backup, restore and recovery practices, including recovery models, point-in-time recovery, restore validation, and alignment with defined recovery objectives.

Experience with T-SQL and PowerShell scripting, and automation of repeatable administrative tasks. Experience with tools such as the Brent Ozar First Responder Kit and the Ola Hallengren Maintenance Solution is an asset.

Experience supporting database migrations, application releases, and production changes within structured incident, problem, and change management practices.

Clear communication skills, strong documentation habits and the ability to collaborate effectively with application teams, infrastructure staff, security teams, stakeholders, leadership, and vendors.

Professional resilience, accountability, and adaptability in a hands-on operational and on-call environment.

Experience integrating SQL Server backups with an enterprise backup platform such as Commvault is an asset.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,086,712 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Similar stack
Same company
Edmonton
$60k – $91k per year · In office · Full-Time · 5+ years exp · Bachelor's Degree · Toronto · Mississauga · Vancouver · Ottawa · Oakville
Python
Scala
Databases
Databricks
Delta Lake
AI/ML
Spark
Machine Learning
DevOps
Terraform
Azure DevOps
GitHub Actions
Azure
CI/CD
Jenkins
Analytics
ETL/ELT
Apply
In office · Full-Time · 5+ years exp · Bachelor's Degree · Calgary · Edmonton · Halifax · Winnipeg · Montreal
Python
Scala
Databases
Databricks
Delta Lake
AI/ML
Spark
Machine Learning
DevOps
Terraform
Azure DevOps
GitHub Actions
Azure
CI/CD
Jenkins
Analytics
ETL/ELT
Apply
$63k – $116k per year · Hybrid · Full-Time · 5+ years exp · Toronto
Python
SQL
Scala
Databases
Snowflake
Databricks
AI/ML
Spark
DevOps
GCP
Azure
CI/CD
AWS
Analytics
Tableau
Power BI
ETL/ELT
Informatica
Talend
Collibra
Alation
Apply
Senior Data Scientist 7 hours ago
$98k – $147k per year · Remote (Canada) · 6+ years exp · PhD · Canada
Python
SQL
AI/ML
Copilot
Cursor
dbt
Context Engineering
Analytics
Tableau
Looker
Apply
AI Data Architect 6 hours ago
$114k – $143k per year · Hybrid · Full-Time · Saskatoon · Toronto
Python
SQL
Databases
Snowflake
AI/ML
Claude
Model Context Protocol
dbt
AI Agents
LLM
DevOps
GCP
AWS
Apply
In office · Full-Time · 3+ years exp · High School Diploma · Edmonton
Apply
In office · Full-Time · High School Diploma · Edmonton
Apply
Apply
In office · 1+ year exp · Edmonton
Apply
Project Controller 8 hours ago
In office · Full-Time · Associate's Degree · Edmonton
Management
SharePoint
Defense
EVMS
Apply
See all jobs
This is one of many
2,086,712 more open roles from verified company boards, updated every day.