Senior Database Administrator

Alberta Pensions Services Corporation (APS)

Edmonton

On-site

CAD 110,000 - 140,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Alberta Pensions Services Corporation (APS) seeks a Senior Database Administrator to manage SQL Server platforms across production and non-production environments. The role emphasizes reliability, security, and performance with a focus on backups, DR, and automation.

You will monitor and tune workloads, design HA/DR strategies, and collaborate with application teams, infrastructure, and vendors to ensure service continuity and rapid incident response.

Qualifications

  • 5+ years of enterprise SQL Server experience.
  • Deep knowledge of SQL Server administration and lifecycle management.
  • Strong SQL and PowerShell scripting capabilities.
  • Experience with high-availability and disaster recovery.
  • Excellent monitoring, documentation, and incident response practices.

Responsibilities

  • Administer SQL Server platforms across production and non-prod.
  • Monitor health, performance, and capacity; pre-empt issues.
  • Tune workloads using execution plans and indexing strategies.
  • Design and test HA/DR solutions like Availability Groups.
  • Manage security, access control, encryption, auditing.
  • Own backup/restore and recovery processes; validate restores.
  • Support deployments and changes with risk assessment.
  • Develop automation and runbooks with PowerShell and T-SQL.
  • Participate in on-call rotations and root-cause analysis.

Skills

MS SQL Server
PowerShell
T-SQL
Automation
Monitoring
Capacity planning
On-call support
Documentation
Incident analysis

Education

Bachelor's degree
Diploma
Certificate

Tools

Brent Ozar kit
Ola Hallengren Maintenance Solution
Commvault

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior SQL Server DBA - High Availability & Security Expert
Senior SQL Server DBA - High Availability & Security Expert

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000
RQ08345 - Sr. Database Administrator
RQ08345 - Sr. Database Administrator

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000
Technical Lead - SQL DBA, SQL Server & Database Administration
Technical Lead - SQL DBA, SQL Server & Database Administration

Astra-North Infoteck Inc. • Vancouver

On-site
CAD 120,000 - 180,000
Database Administrator
Database Administrator

JPS Tech Solutions • New Brunswick

On-site
CAD 90,000 - 120,000
Database Administrator and Back-up Consultant
Database Administrator and Back-up Consultant

TEEMA Group • Edmonton

On-site
CAD 110,000 - 150,000
Senior Database Administrator (DBA) – SQL Server
Senior Database Administrator (DBA) – SQL Server

Strategize it Inc. • Toronto, Winnipeg

Hybrid
CAD 90,000 - 120,000
Database Administrator
Database Administrator

Financial Services Regulatory Authority of Ontario • Toronto

On-site
CAD 100,000 - 150,000
Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration
Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration

Astra-North Infoteck Inc. • Montreal

On-site
CAD 100,000 - 150,000
Database Administrator – Oracle, SQL Server, AWS RDS
Database Administrator – Oracle, SQL Server, AWS RDS

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 95,000 - 130,000
SQL Database Administrator
SQL Database Administrator

HCL Technologies Limited • Calgary

On-site
CAD 100,000 - 130,000