Database Administrator

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

**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) Lead and evolve the database maintenance strategy for the enterprise for Microsoft SQL Server at Servus Credit Union.
- 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.
- Abil