22 Oct
|
Firstontario Credit Union
|
Canada
22 Oct
Firstontario Credit Union
Canada
Why FirstOntario?
- Competitive compensation packages
- Top-tier health and wellness benefits, including comprehensive perks 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.
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.
📌 Operational Database Administrator (Canada)
🏢 Firstontario Credit Union
📍 Canada