Cambrian Credit Union is searching for an experienced Database Administrator (DBA) who will be responsible for
implementing an effective Data Warehouse Solution for Cambrian Credit Union.
The DBA will also share good data practices, proactively identify and resolve areas of improvement in our databases and
develop resilient processes and tools for data management, migration and reporting. The ideal candidate is a creative
problem solver who will work in coordination with cross-functional teams to maintain the structure and security of the
data warehousing environment.
As the Senior Database Administrator, you will:
•Fully understand and follow all corporate IT controls and procedures ensuring they are maintained and followed correctly.
•Design and develop (enhancements and maintenance) new ETL and Business Intelligence Solutions using the Microsoft SSIS
and SQL Server Relational Database technologies.
•Participate and deliver on the data warehouse project and later work as the main ETL contact after go-live.
•Assist in change initiatives and provide production support to data warehouse ETL (extract, transform and load) processes
and optimizing DW ETL processes for optimum performance.
•Ensure accuracy and completeness of data backup and recovery and formulates and monitors policies, procedures, and
standards related to database management.
•Work closely with Software Development Team to design and implement optimal solutions to support and enhance online,
desktop and mobile banking applications.
What this role requires of you:
•Post secondary degree, diploma or certificate in Computer Science / Information Technology, or equivalent experience.
•Hands on knowledge with Microsoft SQL Server Business Intelligence Development Studio (BIDS) - Analysis Services,
Reporting Services and Integration Services.
•Experience analyzing data architecture of various systems;
•Analyze and translate business requirements into Data Warehouse models and develop business-oriented Data Models.
•Experience proposing and enforcing data management best practices, data standards, data management policies, and rules.
•Solid experience with Performance Monitor, DMV’s, Profiler and other tools to find areas that need tuning.
•Experience with Desktop Apps like C#, WPF, WCF, VB6, desired.
•Experience programming for Online and Mobile applications, desired.
•Previous experience in the financial services industry, considered an asset.
•Critical thinker who analyzes information and uses logic to address issues, problems and challenges.
•Ability to work well in an environment with multiple and often changing priorities.
What we offer you in return:
Competitive salary, career progression and professional development, community involvement opportunities and comprehensive
benefits package including a pension plan. This position is located at Cambrian’s Head Office on Broadway Avenue in Winnipeg.