Operational Database Administrator

FirstOntario Credit Union; Hamilton; Hybrid; CAD 70,000 - 96,000; Full time

Benefits offered by this job

Competitive compensation

Health and wellness benefits

Pension Plan

Flex-work environment

Professional development support

Job summary

FirstOntario Credit Union in Hamilton, ON, seeks an experienced Database Administrator (Operational DBA) to oversee day-to-day administration, maintenance, monitoring, performance, availability and security of enterprise databases. Supports on-premises and cloud platforms with Azure experience preferred for banking systems.

The role requires strong SQL expertise, HA/DR, and Temenos banking platform familiarity, with on-call rotations and cross-team collaboration. Hybrid work in Hamilton.

Qualifications

• Degree or diploma in Computer Science, Information Technology, Information Systems, or a related discipline.
• 5+ years database administration experience in enterprise production environments.
• Strong experience supporting Microsoft SQL Server databases.
• Advanced SQL query writing, troubleshooting, and performance tuning.
• Experience with on-premises and cloud database platforms.
• Experience with Microsoft Azure database services, with Azure SQL Managed Instance preferred.
• Experience in financial services or regulated industry.
• Experience with Temenos Banking platforms.

Responsibilities

• Administer, maintain, and support enterprise database platforms across on-premises and cloud environments.
• Monitor health, performance, availability, security, and capacity for stable production operations.
• Perform installation, configuration, patching, upgrades, and migrations.
• Implement and support SSIS, SSAS, and ETL processes.
• Execute backup, recovery, and disaster recovery procedures.
• Analyze and tune SQL queries, stored procedures, and indexes.
• Support high availability, replication, clustering, and DR solutions.
• Collaborate with Infrastructure, Security, App Development, and vendors on cloud modernization.
• Develop scripts/automation to improve monitoring and admin activities.

Skills

SQL Server

SQL scripting

Performance tuning

Backup and DR

Azure

Automation (PowerShell)

Hybrid cloud

Monitoring tools

Education

Degree in Computer Science/IT

5+ years enterprise DBA experience

Tools

Temenos Banking

Azure SQL Managed Instance

Azure SQL Database

SSIS/SSAS

Job description

Why FirstOntario?

• Competitive compensation packages
• Top-tier health and wellness benefits, including comprehensive benefits packages, a yearly health spending account and personal spending account
• Enhanced mental health benefits through SunLife and TELUS Health
• Exclusive banking benefits
• Up to $1000 per year towards professional development
• Pension Plan
• Flex-work environment
• Company-wide Employee Volunteer program (Blue Wave Program)
• Employee and Family Assistance Program

Job Overview

The Database Administrator (Operational DBA) is responsible for the day-to-day administration, maintenance, monitoring, performance, availability, and security of enterprise database environments. The role supports both on-premises and cloud-based database platforms, ensuring reliable operation of critical business applications and banking systems.

The successful candidate will bring strong SQL expertise and hands-on experience managing hybrid database environments, with Microsoft Azure experience preferred. Experience in the financial services industry and with Temenos Banking platforms is considered an asset.

Database Operations and Administration

• Administer, maintain, and support enterprise database platforms across on-premises and cloud environments.
• Monitor database health, performance, availability, security, and capacity to support stable production operations.
• Perform database installation, configuration, patching, upgrades, and migrations.
• Implement and support SSIS, SSAS, and ETL processes, including maintenance.
• Execute backup, recovery, and disaster recovery procedures to support business continuity.
• Participate in on-call support rotations and respond to production incidents as required.

Performance and Reliability

• Analyze and tune SQL queries, stored procedures, indexes, and database configurations.
• Identify and resolve database bottlenecks, performance issues, and capacity constraints.
• Implement proactive monitoring, alerting, and automation to improve reliability and operational efficiency.
• Support high availability, replication, clustering, and disaster recovery solutions.

Cloud and Hybrid Infrastructure Support

• Support Azure database services, including Azure SQL Managed Instance, Azure SQL Database, and related Azure data services.
• Maintain hybrid database architectures spanning on-premises and cloud platforms.
• Collaborate with Infrastructure, Security, Application Development, and vendor teams on cloud modernization initiatives.
• Assist with database migrations, platform lifecycle activities, and cloud adoption projects.

Security, Risk, and Compliance

• Implement database security controls, permissions, encryption, privileged access practices, and access reviews.
• Support compliance with corporate security standards, audit requirements, privacy obligations, and regulatory expectations.
• Perform vulnerability remediation and support database-related security reviews and audits.
• Maintain database standards, operating procedures, runbooks, and technical documentation.

Application and Vendor Support

• Provide operational database support for core banking, digital banking, and enterprise applications.
• Support database requirements for Temenos Banking platforms and related integrations.
• Work with internal teams and external vendors to troubleshoot and resolve database-related incidents and service requests.
• Assist project teams with database design reviews, deployment planning, implementation, and change activities.

Continuous Improvement

• Develop scripts and automation to improve monitoring, administration, maintenance, and reporting activities.
• Recommend improvements to database reliability, performance, capacity planning, and operational support processes.
• Contribute to knowledge transfer, operational resilience, documentation, and service improvement initiatives.

Required Skills

• Degree or diploma in Computer Science, Information Technology, Information Systems, or a related discipline.
• Equivalent combination of education, certifications, and experience may be considered.
• 5 or more years of database administration experience in enterprise production environments.
• Strong experience supporting Microsoft SQL Server databases.
• Advanced SQL query writing, troubleshooting, and performance tuning capabilities.
• Experience managing backup, recovery, high availability, and disaster recovery solutions.
• Experience supporting production systems under defined service level expectations.
• Experience with both on-premises and cloud database platforms.
• Experience with Microsoft Azure database services, with Azure SQL Managed Instance preferred.
• Experience working in hybrid cloud environments.
• Experience in the financial services, banking, or another regulated industry.
• Experience supporting Temenos Banking, Temenos Infinity, or related banking platforms.
• Experience with automation technologies such as PowerShell, T-SQL, or other scripting languages.
• Experience with monitoring, observability, and database performance management tools.

This role is hybrid in Hamilton, ON.

This posting is for an existing vacancy.

Salary Range: $69,931 to $96,155 annually.

Compensation for this role reflects a combination of skills, experience, and internal equity. Those whose experience more closely aligns the role's requirements may be placed higher within the salary range. You will learn more about FirstOntario Credit Union's total rewards package during the interview process.

Our inclusive work environment welcomes diversity and supports accessibility. If you require accommodation at any time during the recruitment process, please let us know.