Senior Database Administrator to design, install and maintain database systems to ensure a high level of data availability

S.i. Systems client is looking for a Senior Database Administrator to design, install and maintain database systems to ensure a high level of data availability

1 year contract hybrid model- 2 days/ week onsite in Burnaby.

Must Haves:

• Experience with on premise SQL Database environments
• Experience with setting up new Microsoft SQL servers and databases.
• Thorough knowledge of the principles and techniques associated with database design and management.
• Ability to analyze and evaluate various data and information requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.
• Ability to establish standards and procedures to ensure the integrity, security, availability and recovery of all data.
• Ability to serve as project manager for a variety of infrastructure and database projects, establish project schedules, assign and guide the work of team members, and monitor progress.
• Experience with data modeling
• Experience with database replication, mirroring, and encryption

Nice to have:

• Experience with building data pipelines and ETL processes using SSIS

Responsibilities:

• Installing and maintaining databases
• Managing backup and recovery processes, system storage, data security and confidentiality
• Developing database architecture
• Planning and coordinating data migration between systems
• Monitoring technical performance of corporate data systems
• Setting up database encryption
• Setting up database replication
• Identifying and resolving data abnormalities
• Liaising with client departments and applications staff on the delivery of business technology solutions
• Researching, evaluating and recommending technology solutions related to database and performance measurement tools
• Managing the deployment of SSIS data pipeline packages