Database Administrator

Summary

Join Servus Credit Union as a Database Administrator and provide enterprise-wide technical support for business-critical databases, ensuring data recoverability, integrity, security, availability, and performance. You will be responsible for the development, maintenance, and troubleshooting of the corporate data environment, including integration with external databases. As a senior technical resource, you will lead problem resolution, manage projects, mentor junior staff, and promote best practices in database management. The role ensures data availability and integrity through consistent, repeatable processes while minimizing redundancy and supporting application development. This full-time, permanent, remote position reports to the Platform and Systems Lead. Servus Credit Union offers outstanding benefits, including health and wellness, vacation and retirement savings programs, training and development opportunities, career advancement potential, flexible work options, competitive compensation with performance-based incentives, and employee volunteer programs.

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
• 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

Responsibilities

• 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

Preferred Qualifications

• 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
• 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
• Experience with PowerShell is desirable

Benefits

• Health and wellness
• Vacation
• Retirement savings programs
• 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
• Profit sharing