16 Oct
|
FirstOntario Credit Union
|
Canada
16 Oct
FirstOntario Credit Union
Canada
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 setting
- 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 solid 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.
Role
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.
📌 Operational Database Administrator (Canada)
🏢 FirstOntario Credit Union
📍 Canada