Industry: All
Term: Contract
Province: BC
Category: Information Technology
Experience: 5 - 10 Years
On behalf of our client, Affinity is looking for a Database Administrator to work with the I.T. team to design, install and maintain database systems to ensure a high level of data availability.
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
Requirements:
• Considerable experience with on premise SQL Database environments
• 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 building data pipelines and ETL processes using SSIS is an asset.
• Experience with database replication, mirroring, and encryption
• Experience with setting up new Microsoft SQL servers and databases.
• Thorough knowledge of software development methods, practices, and procedures.
• Ability to prepare technical design and write technical specifications.
• Establish and maintain effective working relationships with a variety of internal contacts.
• Provide advice and assistance on matters related to the work.
• Communicate effectively orally and in writing.
• Perform assigned duties with minimal supervision, although direction will be given.
• Maintain confidentiality.
Hourly rate: $60.00 - $70.00 Per Hour.
Affinity Earn:
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity:
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 12053
#LI-Hybrid