Job description

Listing Info
Finesse – Ottawa, Canada

We understand the importance of a system that works together. Join our team of leaders to begin a rewarding career.

Current Need – This job is located in British Columbia, Canada. All applicants must have the right to work in Canada in order to be considered for this role.

The Enterprise DBA / Data Analyst is a member of the Enterprise Tools team, focusing on administration of the Microsoft SQL Server infrastructure used to support over 35 line of business applications and 90 databases, including the Data Warehouse and data integration services across the IWS business unit while meeting regulatory requirements and compliance standards. Approximately 50% DBA duties and 50% Data Warehousing duties.

• Manages the SQL Server environments, including Production, Test, and Development
• Responsible for High Availability and Disaster Recovery capabilities and strategy, such as fail-over clustering, backups, and log shipping
• Monitors and optimizes performance and troubleshoots both functional and performance related issues
• Provisions databases, permissions, and other configuration as required
• Oversees Data Warehousing strategy and implementation
• Contributes to the design and standards around dimensional data models, extract-transform-load (ETL), and reporting
• Manages the IWS QlikView infrastructure
• Develops databases, ETL, and reports as required
• Follows standards for documentation, configuration management and change management
• Carries out other tasks as assigned

Qualifications

Minimum Requirements

• + years experience in database administration

Additional Knowledge & Skills

• years combined working experience as a DBA, database developer, and/or data analyst preferred

Critical Skills

• Strong administration experience with Microsoft SQL Server, including failover-clustering (FCI), log shipping or Availability Groups
• Experience in T-SQL database development, including views, complex stored procedures, functions, CLR functions and the like
• Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) or similar reporting/ETL tools
• Experience with monitoring tools, such as SQL Sentry, for server health and performance
• Any experience with other BI tools such as QlikView, Tableau, MS PowerPivot / PowerView / Semantic Model is an asset
• Any experience with Oracle / PL-SQL is an asset
• Excellent English communications (written and verbal) to communicate effectively with peers and stakeholders across the organization
• Excellent interpersonal skills
• Excellent organizational skills
• Able to learn quickly and independently

Education

• -year degree in computer science or related field or equivalent experience