Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Posting Closes On: May 22 2025
Employment Status: FullTime Permanent Remote
Servus is growing! We are currently looking for a Database Administrator in our Data and Infrastructure Department.
Servus Credit Union is Albertas largest memberowned credit union known for building strong resilient communities by helping our members feel good about their money. One of Canadas Best Managed Companies for 20 consecutive years and ranked as one of the top banks in Canada on Forbes Worlds 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 enterprisewide technical support for businesscritical 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 daytoday 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 AlwaysOn.
- 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 oncall 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 ().
- 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 multiremoteuser database environments.
- Scripting & Automation: Should be comfortable writing TSQL 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/ datamanipulationrelated 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 were looking for candidates who align with our values. We live our values in how we do business. Were 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. Its 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 performancebased 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 youll 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 dont check every box we encourage you to apply!
Required Experience:
Unclear Seniority
Employment Type
Full Time
