Database Administrator

Servus Credit Union; Calgary; Remote; CAD 80,000 - 100,000; Full time

Job summary

Servus Credit Union is seeking a Database Administrator to provide enterprise-wide support for critical databases. This role involves ensuring data integrity, security, and performance while leading projects and mentoring junior staff. The ideal candidate will have extensive experience with Microsoft SQL Server and cloud database management, demonstrating a commitment to best practices in database management.

Benefits

Training & Development Opportunities

Career Advancement Potential

Flexible work options

Competitive Compensation

Employee volunteer program

Qualifications

• In-depth knowledge of Microsoft SQL Server platforms.
• Experience with disaster recovery options for SQL Server.
• Strong experience with SQL Server Integration Services.

Responsibilities

• Provide technical support for business-critical databases.
• Lead problem resolution and manage projects.
• Collaborate with stakeholders to determine impact of database changes.

Skills

Performance Tuning

Query Optimization

Database Management

Technical Writing

Scripting

Tools

Microsoft SQL Server

Azure Cloud

SSIS

SSAS

SSRS

PowerShell

DynaTrace

DBUp

Flyway

Liquibase

Job description

Posting Closes On: May 22, 2025

Employment Status: Full-Time, Permanent, Remote

Servus is growing! We are currently looking for a Database Administrator in our Data and Infrastructure Department.

Servus Credit Union is Alberta's largest member-owned credit union, known for building strong, resilient communities by helping our members feel good about their money. One of Canada's Best Managed Companies for 20 consecutive years and ranked as one of the top banks in Canada on Forbes World's Best Banks list for two years in a row, we are a team of smart, gutsy, and driven individuals.

Position Overview:

Reporting to the Platform and Systems Lead, the Database Administrator (DBA) provides enterprise-wide technical support for business-critical databases, ensuring data recoverability, integrity, security, availability, and performance. This role is responsible for the development, maintenance, and troubleshooting of the corporate data environment, including integration with external databases.

As a senior technical resource, the DBA leads problem resolution, manages projects, mentors junior staff, and promotes best practices in database management. The role ensures data availability and integrity through consistent, repeatable processes while minimizing redundancy and supporting application development.

Key Accountabilities:

• Responsible for day-to-day activities regarding the upkeep and availability of all database servers in the production and lower environments.
• Responsible for database backup and recovery functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and Always-On.
• Lead project teams in performing DBMS installations, configurations and updates as per department standards.
• Serve as a SME (Subject Matter Expert) for Microsoft SQL Server at Servus Credit Union
• Lead and evolve the database maintenance strategy for the enterprise
• Prepare and maintain accurate database management documentation relating to design, architecture, and operations.
• Collaborate with stakeholders and Developers to determine impact of database changes.
• Plan, coordinate and participate in the implementation of database maintenance operations.
• Collaborate with Audit and Security stakeholders to plan, coordinate, monitor, and maintain security standards and measures.
• Monitor and manage corporate databases to optimize performance, availability, resource use, and physical implementations, ensuring they meet business needs.
• Coordinate scheduled database maintenance windows and communicate accordingly.
• Provide on-call support as needed, responding within timelines as defined in On Call Policy and DBA SLA.
• Address unscheduled database outages and performance issues by diagnosing errors, implementing recovery strategies, logging and tracking problems, escalating as needed, and participating in debriefings to prevent recurrence.
• Perform incident diagnosis by examining individual SQL statements, tables, process and system architecture.
• Tune individual SQL statements by rewriting, adding or modifying indexes or modifying database tables.
• Address a variety of database integration issues including data access, data migration, integration and maintenance/conversion.
• Maintain database support tools including database management software and related products.
• Participate in defining and executing Servus' Azure SQL IaaS / PaaS support model.
  
  
  

Requirements

• In depth knowledge of the Microsoft SQL Server platform (2022, 2019, 2017, 2016).
• Proficient in performance tuning and query optimization, including the utilization of Performance Monitor, SQL Profiler, and other related tools.
• Experience configuring highly available systems with disaster recovery options for SQL Server.
• Experience with backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, and Always On.
• Strong experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Demonstrated advanced experience creating and managing databases in multi-remote-user database environments.
• Scripting & Automation: Should be comfortable writing T-SQL scripts and working with source code repositories such as git. Experience with PowerShell is desirable.
• Experience with Azure Cloud Database Management in both IaaS and PaaS solutions is desirable.
• Experience with DynaTrace is desirable.
• Awareness of Schema Migration tools such as DBUp, Flyway, and Liquibase.
• Familiarity with Linux/Unix including basic commands and shell scripting.
• Extensive knowledge of analysis and development processes.
• Demonstrated advanced experience in I.T. operations and support practices including troubleshooting of data access-/ data-manipulation-related problems.
• Detailed knowledge of data security and integrity methods and techniques.
• Demonstrated technical writing skills including the use of standard diagramming techniques.
• Ability to program, configure, manage, and maintain complex relational databases and data sets.
• Ability to install, maintain, modify and upgrade database management software.
• Ability to provide technical guidance and leadership to professional personnel in area of expertise.
• Awareness of DevOps and Agile methodologies.
• Awareness of hardware virtualization and IaaS, ideally Nutanix, Microsoft Azure, VMWare, and Windows Server.
• Understanding and familiarity with credit union financial systems.
• Understanding of credit union business and operations.
• Knowledge of credit union products and services.
• Knowledge of credit union philosophies and principles.
  
  

Most importantly, we're looking for candidates who align with our values. We live our values in how we do business. We're not afraid to be different - in fact, we embrace our differences. We have a spirit that motivates us to give our best service to members every day. It's our values that attract many people to Servus - and keep them with us. We embrace our culture and heritage, and we pride ourselves on our strong commitment to the communities we serve and our efforts to build and maintain member loyalty. If this sounds like you, then we encourage you to apply!

Benefits

Working for Servus has outstanding benefits. In addition to standard benefits like health and wellness, vacation and retirement savings programs, we also provide other important benefits such as:

• Training & Development Opportunities
• Career Advancement Potential
• Flexible work options
• Competitive Compensation including performance-based incentive pay
• Meaningful work towards individual and corporate goals
• Opportunities to get involved and give back through an employee volunteer program
  
  
  

For Information About These Benefits And More, Click Here.

At Servus, our employees are also members. This means you'll have all the benefits of being a member of the credit union including profit sharing, voting for the board of directors, and all of the services we provide ... with a few additional perks!

What happens next?

Only those applicants selected for an interview will be contacted. Should you require any accommodations during the hiring process, please advise us at that time.

Discover a sense of belonging amongst a team of unique, authentic individuals working together to reimagine financial fitness. We value and celebrate the richness that diverse backgrounds and experiences bring to our community. Your skills, passion, and curiosity may find a sense of belonging at Servus, so even if you don't check every box we encourage you to apply!