Database Administrator

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 cross-functional 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, fast-paced projects while maintaining a high attention to detail
- Ability to work well in a team atmosphere, interacting positively with all levels of stakeholders
- Data-driven and eager to understand the numbers to provide valuable, meaningful business insights
- Strong customer service focus with the ability to translate technical aspects for end-users
- Ability to identify system and organizational problems, determine possible solutions and communicate those ideas effectively