
Database Administrator at Servus Credit Union. 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. . . . 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!. Company Location: Canada.