Database Administrator

Are you looking to join a company who is committed to investing in technology and is one of Canada’s largest mortgage lenders? Are you excited to use your technical expertise to join a technology solutions entrepreneurial start-up within a well
- established national financial services organization? Join our growing team of data and analytics staff who truly make an impact on product and service delivery at Intellifi.

**Role and Responsibilities**:

- Work within the Data Ops team, managing the data infrastructure and resources at different cloud maturity levels
- Work on projects optimizing and modernizing the data system and infrastructure
- Manage the database system, work on performance tuning, backup management, capacity planning, automation, monitoring and alerting, building and managing replication, CDC, log shipping, and other DBA activities
- Design and mange the data security and user access to data throughout the database system
- Design and implement the HA/DR for the various data resources
- Perform migration of the data systems from IaaS (SQL Server) to a PaaS environment
- Work on administration of ETLs and reporting environments
- Collaborate with Data Engineers, Data Analysts, and Report Analysts, assess their needs, manage analytical data sources and data pipelines to cater to their needs
- Work with business users, developers, and other stakeholders to determine and document the requirements of the enterprise data warehouse and data marts
- Work with the Data Engineers, assist in designing and developing data flow pipelines for transferring data between several data sources in an efficient manner
- Manage data flow in a large-scale production environment with multiple workloads and with different requirements
- Enhance the automation of database systems and processes to reduce toil and improve performance
- Assist in developing and managing the data archiving processes based on different retention policies
- Build and manage monitoring and alerting on data systems, reducing the downtimes, and manage the maintenance tasks and workload
- Evaluate complex issues for customer-impacting issue resolution
- Demonstrate a degree of knowledge throughout all CMLS products and technologies
- Stay current in data technology trends and proactively provides technology recommendations
- Assist in establishing service level agreements and monitoring progress toward key service delivery performance indicators (KPI’s) or metrics
- Collaborate in the development and delivery of data technology standards, best practices, architecture and systems to ensure data security across the enterprise

**Skills and Qualifications**:

- **Knowledge Requirements**:

- SQL Server database administration, performance management, capacity planning, high availability, disaster recovery, and other database administration tasks and responsibilities
- Azure database administration (mostly on SQL based technology)
- Modern data flows, working on several data sources, in hybrid environments with diverse levels of cloud maturity
- Tools, methods, and best practices for designing, building, and managing databases and data flow pipelines and ETLs
- Extended experience with Microsoft data platform is considered an asset (SQL Server, SSIS, SSRS, Azure Data Factory, Synapse, Power BI)
- Administrating modern BI, analytic, and reporting tool and methods
- A proven track record in designing and developing enterprise level database systems, and successful execution of it
- A working knowledge and experience in administration and managing data pipelines and ETLs (SSIS, ADF, Synapse, Power BI, etc.)
- Cloud database technology, migration, resource management, and security practices
- **Ability Requirements**:

- Provide collaborate with other technical and non-technical team members in establishing district priorities
- Work with cross-functional, interdisciplinary teams to achieve tactical and strategic goals
- Participate in rotational on-call duties to support mission critical workflows
- Demonstrate strong interpersonal, presentation, oral communication skills, written communication skills with a strong customer service orientation and strong understanding of business processes. Knowledge, Skills, and Abilities
- Able to communicate security and risk-related concepts to both technical and nontechnical audiences (in business terms)
- A natural influencer and problem solver
- Ability to effectively prioritize and execute tasks in high-pressure situations
- **Other**:

- Provide collaborate with other technical and non-technical team members in establishing district priorities
- Work with cross-functional, interdisciplinary teams to achieve tactical and strategic goals
- Participate in rotational on-call duties to support mission critical workflows
- Demonstrate strong interpersonal, presentation, oral communication skills, written communication skills with a strong customer service orientation and strong understanding of business pro