Database Administrator - Edmonton, Canada - Cashco Financial

Cashco Financial

Verified Company

Edmonton, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

It's scary when you join a company and you're not sure what it's really like on the inside. Let me tell you that we are awesome We are certified as a
Great Place to Work which means our employees voted for us — this is the place to be working

Sounds good right? Let me seal the deal.

At Cashco our winning aspiration is to put 1 million Canadians on a path to financial health and our purpose is to End Financial Exclusion.

We are seeking a talented
Database Administrator to join our team at Cashco Financial.

This role will provide technical guidance in system architecture, design principles, software development methodologies and administration of the organization's databases.

Our Database Administrator will work with the Digital team and internal stakeholders to deliver digital solutions that drive meaningful outcomes for the company and our clients.

You will

Engage with internal stakeholders to understand business requirements, document various solution options and recommend best approach to enable business objectives
Design, create, test and maintain data models and database designs to support company information management, including appropriate documentation
Develop strategies for warehouse implementation, data acquisition and access, and data archiving and recovery
Design and contribute to delivery of data engineering processes, data architecture, data modeling, transformation and data pipeline
Manage data integration and train developers on effective implementation of database practices
Work with datasets to transform raw data into useful data for the company
Facilitates work with Software Development team members to ensure all components of the data model are properly built into the solution; includes documenting technical requirements
Effectively monitor and provide proactive database administration before problems arise
Routine database management including: log assessments, updates, upgrades and optimizations
Act as a technical advisor through developing and maintaining a thorough knowledge of company business processes and the data they create and require
Ensure databases are securely maintained through development and enforcement of security policies and permissions maintenance
Assist in the development of project plans, schedules, and estimates pertaining to architectural deployment and services delivery
Evaluate new data sources for adherence to the organizations quality standards and ease of integration
Improve database infrastructure and performance with best practice implementations of emerging technologies and topologies
Identify trends that provide performance improvements to existing databases
Participate in crossfunctional committees to establish and implement technical standards, promote integration of idea and coordinate projects across work units
Provide tracking and reporting of time and status on all projects as required
Ensure quality by building test cases to ensure the data models reflect requirements and data model has been accurately implemented

You have

Bachelor's Degree or Diploma in Information Technology, Computer Science, or related discipline
Minimum 5+ years of database experience or related computer science experience
MCSA (Microsoft SQL Server) or equivalent certification
MCSE (Business Intelligence) or equivalent certification considered an asset
Extensive experience within the following:
T-SQL queries
Programming languages (C#, Python)
Profile tools
Stored procedures, views, triggers, and functions
Advanced table design (partitioning, compression, indexing, clustering)
Performance tuning
Security and encryption
Backup and recovery
ETL and data warehousing
SSRS
SSIS
SSAS
The following experience considered an asset:
Agile project methodology
Project management
Strong understanding of relationship databases, data architecture and data lifecycle concepts
Strong understanding and experience with Change Management philosophies as it relates to data and system lifecycles
Demonstrated experience with creating technical documentation and data mapping documents
Demonstrated experience diagnosing and resolving database related problems

Skills:

Excellent written and verbal communication skills, in addition to strong interpersonal, organizational, and time management skills
Comfortability with working multiple, fastpaced projects while maintaining a high attention to detail
Ability to work well in a team atmosphere, interacting positively with all levels of stakeholders
Datadriven and eager to understand the numbers to provide valuable, meaningful business insights
Strong customer service focus with the ability to translate technical aspects for endusers
Ability to identify system and organizational problems, determine possible solutions and communicate those ideas effectively