Company:
Finesse Tech
Location: Toronto
Closing Date: 27-11-2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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.
Responsibilities 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 + 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
#J-18808-Ljbffr
Share this job
Finesse Tech