EUADB-1924-Database-Administrator

‹ Back to Current Opportunities

Please contact human resources if you have any questions.

Vantix Systems Inc. is a dynamic and savvy organization based in Edmonton, Alberta, Canada. We are looking for creative and talented professionals to join our team.

Job Opportunity
DescriptionOur Client is seeking a senior Data Base Administrator (DBA), specifically for enterprise Data Warehouse in an SQL Server environment. This person will be responsible to support SADW in maintaining the technical environment, structure and security of the data warehousing environment, including the data warehouse itself, business intelligence and analytics tools, to meet the Institution’s data reporting and analytical needs. 
SkillsOracle, SQL Server, Mirgration, Cloud Services, Tableau 
Type 
Project Description 
Experience Required/ Mandatory Skills
  • Minimum of five (5) years' experience as a DBA of a medium-scale SQL Server Data Warehouse. This five (5) years' experience is to include all of these elements - DBA; medium-scale SQL Server; and Data Warehouse - in the same job responsibility.
  • Knowledge and / or experience with Cloud technology, solutions and architecture.
  • Demonstrated process of keeping current with Data Warehousing and related technologies.
  • Experience with Business Intelligence technology. Four (4) years' experience preferred.
  • Knowledge of Artificial and/or Machine Learning technology.
  • Knowledge of Azure DevOps technology
  • Working knowledge of Query Store, Data Compression, Always Encrypted, Columnstore Index, and Resource Governor.
  • Experience setting up processes for managing security. Four (4) years' experience preferred.
  • Ability to respond and address issues after regular work hours (evenings and weekends)
  • Experience with query optimization methods.
  • Minimum of eight (8) years' experience (preferred) with SQL, coding queries, SCUD, stored procedures and data import/export.
  • Extensive experience in high performance, medium scale computing environment. Ten (10) years' experience preferred.
  • Extensive experience of system resource configuration as it pertains to SQL server installation, patching and upgrading in a DW environment. Five (5) years' experience preferred.
  • Experience with monitoring and troubleshooting DW ETL process and optimizing DW ETL process for optimum performance. Three (3) years' experience preferred.
  • Experience with tools, including: Central Management Server; SQL Server Powershell Scripting. Two (2) years' experience preferred.
  • Experience with replication, tuning procedures, fault detection and resolution processes. Two (2) years' experience preferred.
  • Understanding of OLAP architecture design.
  • Proficient SQL scripting skills, including: stored procedures; functions; etc. Five (5) years' experience preferred.
  • Experience and demonstrated understanding of best practices for combining strengths of database and DW ETL tools to optimize data movement.
  • Excellent analytical ability, judgment and problem analysis.
  • Excellent ability to communicate with people having business or technical background.
  • Ability to work collaboratively with a group of professional staff (team player).
 
Nice To Have Skills 
LocationEdmonton 
Work Environment1 year with possibility of 4 one-year extensions 
Hourly RateNegotiable