Senior Database Administrator
Alberta Pensions Services Corporation (APS)
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Senior Database Administrator in Winnipeg, MB vacancy
- Senior Database Administrator (Oracle Application DBA / Cloud) We are seeking an experienced Senior Oracle Application DBA to optimize, scale,... ...to-Have Qualifications Experience with Oracle Exadata administration and performance tuning features (Smart Scan, Hybrid Columnar...SeniorInternshipManual labor
- ...savings planEmployee Assistance ProgramRole overview The Senior Database Administrator is responsible for the operational stability, technical... ....8+ years of professional experience in database administration, database engineering, or database platform management, with...SeniorFlexible hours
- Responsibilities Creates physical database designs and operates and administers the database... ...and practices Experience in Database Administration, Maintenance OptimizationAdditional... ...suggested on a potential need for a role of a Senior DevOps/Cloud DBA at a rate similar to a...Senior
- ...future of work itself. Position SummaryWe are seeking a Senior Database Administrator (DBA) with deep, hands-on expertise across PostgreSQL,... ...and cost-efficient. The primary focus of this role is administration and platform engineering: configuring, setting up, and continuously...Senior
- Position Title - RQ11860 - Senior Database Administrator Location: Toronto, ON Mode: Contract 1. Position Overview The successful candidate... ...security standards.Develop and automate database administration activities using SQL, PL/SQL, T-SQL, Python, Bash, and PowerShell...SeniorContract work
- Database Administrator - Senior:On behalf of our Government Sector client, Procom is searching for a Database Administrator - Senior for a 6-month role. This position is onsite 5 days a week at our client’s Toronto office.Database Administrator - Senior - Job Description:This...SeniorContract workWork at office
$96k - $113k per year
...:Reposting to the Supervisor, Business Intelligence, the Senior Administrator, Database, will provide hands-on leadership and technical expertise... ...and safety programs and policies Provide senior-level administration and troubleshooting for business-critical SQL Server environments...SeniorPermanent employment$118.3k - $135.26k per year
Page 1 of 3 Position Title: Senior Database Administrator Classification: IS30 Department/Account: HIBC Services Job Code: 90000668... ...Science with 7 plus years’ experience in a systems administration environment; with structured training in DB2 Database...SeniorFull timeWork at officeWeekend work- Oracle database administration expertise drives this Senior Database Administrator role, covering performance tuning, backup recovery, and enterprise database operations.This senior position focuses on physical database design and DBMS administration. You will handle optimization...Senior
- Optimize Oracle databases and PL/SQL performance as a Senior Oracle Application DBA supporting mission-critical applications. Partner with development and engineering teams on availability and operations.This senior role focuses on Oracle Database 12c/19c+ application support...Senior
- Senior SQL Server Database Administrator in Toronto, ON, supporting FSRA database operations through performance, security, backup, and recovery expertise... ...or related fieldFive years of Microsoft SQL Server administration experienceFive years designing, securing, scaling, and...SeniorFull time
- Drive data management excellence as a Senior Database Administrator for the Government of British Columbia. This role is critical for maintaining robust database systems and ensuring data integrity. The Government of British Columbia is seeking a Senior Database Administrator...Senior
- Lead Db2 for z/OS and IMS database administration remotely in Canada, applying performance tuning, recovery, and production support expertise.DXC Technology seeks a database administrator with at least 10 years of hands-on Db2 for z/OS and IMS DB/DC experience. You will support...SeniorPermanent employmentRemote work
- Lead SQL Server administration remotely from Toronto, applying performance tuning and high availability expertise across a large on-premises environment.This Database Administrator will structure a rapidly grown estate supporting an established recovery-audit firm. You will...SeniorRemote work
- Support BMO’s mission-critical mainframe databases in Toronto through Db2 administration, JCL expertise, and enterprise-scale performance analysis.This Senior Database Administrator joins the Mainframe Platform & Application Services team supporting Db2 for z/OS. You will maintain...Senior
- ## Database AdministratorApply: Toronto, ON: Full time: Posted Yesterday: End... ...Accountable for providing highly specialized senior level technical expertise, oversight and... ...in the project implementation and administration of FSRA database systems to ensure all business...SeniorLong term contractFull time
- ...Server DBA role requires seven or more years of SQL Server DBA and database development experience. You will support database availability... ...for three days working from officeApply SQL Server administration, Azure SQL MI, HA/DR, and performance tuning expertise to critical...Senior
$89.2k - $129.3k per year
...Stantec every day. Position SummaryWe are seeking a Senior Oracle APEX and Database Administrator to support and enhance enterprise database platforms... .... This role will be responsible for the design, administration, performance optimization, and lifecycle management of...SeniorLong term contractFull timeTemporary workPart timeCasual work- Recruitment Government of British ColumbiaISL 27R - Senior Database Administrator Upcoming Government of British Columbia BC provincialGovernment of British Columbia has published ISL 27R - Senior Database Administrator. Eligible candidates should apply through the official...Senior
- Lead Azure SQL administration, security, and performance work as a senior software developer on sensitive enterprise databases. This assignment is provisionally hybrid.The Justice Technology Services Digital Design Branch needs database expertise for Criminal Justice Digital...Senior
- SQL Server administration and performance tuning define this Montreal hybrid role, combining three onsite days with two remote days each week.This SQL Server Database Administrator performs core DBA work across operations, maintenance, upgrades, and migrations. The role requires...SeniorRemote work2 days per week
- ...administer enterprise DB2 for z/OS and IMS databases while applying performance tuning,... ...expertise.DXC Technology seeks a database administrator with minimum 10 years of hands-on Db2... ...IMS experienceStrong IBM DB2 for z/OS administration experienceStrong IBM IMS DB administration...SeniorRemote work
- Manage Oracle and cloud databases onsite in Toronto as a Senior Database Administrator supporting critical government-sector projects for six months.Procom seeks... ...communication and SQL proficiencyApply your database administration, cloud integration, and optimization expertise...Senior
- ...learn and discover your way forward. Within our team, you will play a key role in the stability, performance, and evolution of our database environments. You will be responsible for the maintenance, operation, and ongoing support of production databases hosted within our...Long term contractPermanent employmentFixed term contractInternshipRemote workWork visaFlexible hours
- Job SummaryWe are seeking a Database Administrator to design, secure, maintain, and optimize enterprise databases used to store and manage critical... .... The role will support database planning, development, administration, security, backup, and maintenance across enterprise...
$70 - $78 per hour
...complex technical issues to stakeholders and Lines of Business partners Complying with CIBC standards for change control and overall database security policies Analysing recurring incidents and identifying service improvements where possible Providing on-call...- Job DescriptionOn behalf of our public sector client, Affinity is seeking a Database Administrator to be engaged for a one-year term, with a possible one-year extension, to provide day-to-day operational support for the organization’s SQL Server database environments and business...Long term contract
$80 - $95 per hour
...Systematix and we are currently looking for a senior Oracle DBA with Peoplesoft projects... ...PUM images, and migrating Oracle Database 19c to 26ai on Oracle Cloud Infrastructure... ...screening, candidate matching, and recruitment administration. All hiring decisions are ultimately...SeniorHourly payContract workRemote work- ...démarrageLocalisation du posteMontréal (hybride)DuréeNous recherchons un Administrateur de base de données senior SQL pour rejoindre notre équipe de conseillers du... ...une expérience significative (5 à 8 années) en administration,diagnostic et optimisation d'environnements Microsoft...SeniorPermanent employmentWork at office
- ...Responsibilities: Perform Core SQL DBA tasks. Configure and maintain database servers and processes Handle Database upgrades and... ...experience as a SQL Server DBA. Experience with SQL Server Administration experience required Experience with Performance Tuning and...Remote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Database Administrator. Be the first to apply!
Related searches
- database administrator Winnipeg, MB
- database manager Winnipeg, MB
- data administrator Winnipeg, MB
- junior database administrator Winnipeg, MB
- dba Winnipeg, MB
- senior disability case manager Winnipeg, MB
- senior hardware engineer Winnipeg, MB
- senior cook Winnipeg, MB
- amica senior lifestyles Winnipeg, MB
- senior building operator Winnipeg, MB

