Operational Database Administrator

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

Benefits offered by this job

Health benefits

Annual HSA/HSA Plus

Professional development up to $1000

Pension plan

Flex-work environment

Blue Wave Employee Volunteer program

Employee & Family Assistance Program

Job summary

FirstOntario Credit Union is seeking a Database Administrator (Operational DBA) to manage on‑premises and cloud databases with a focus on SQL Server, Azure SQL, and Temenos Banking integrations. The role supports enterprise banking systems with strong emphasis on performance, security, and reliability.

The candidate will have 5+ years of production database experience, hybrid cloud exposure, and a background in financial services.

Qualifications

• Degree or diploma in Computer Science, IT, Information Systems, or related discipline.
• 5+ years of database administration experience in enterprise production environments.
• Strong experience with Microsoft SQL Server databases.
• Advanced SQL query writing, troubleshooting, and performance tuning.
• Experience with backup, recovery, high availability, and disaster recovery.
• Experience with on-premises and cloud database platforms.
• Experience with Microsoft Azure database services, Azure SQL Managed Instance preferred.
• Experience in hybrid cloud environments and financial services/banking.
• Experience with Temenos Banking platforms.
• Experience with automation technologies such as PowerShell and T-SQL.

Responsibilities

• Administer, maintain, and support enterprise database platforms across on-premises and cloud environments.
• Monitor database 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.
• Participate in on-call rotations and respond to incidents.
• Analyze and tune SQL queries, stored procedures, and indexes.
• Support high availability, replication, clustering, and disaster recovery solutions.
• Collaborate with Infrastructure, Security, App Development, and vendors on cloud projects.
• Assist with database migrations and platform lifecycle activities.

Skills

SQL Server

Azure SQL

Performance tuning

Backup & DR

Security controls

Hybrid cloud

Temenos Banking

T‑SQL

Monitoring tools

PowerShell

Education

Degree in Computer Science / IT

Equivalent qualifications/experience

Tools

PowerShell

Temenos tooling

Azure tooling

Job description

• 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
• 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

Why FirstOntario?

• 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
• 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.