Job Title: Database Administrator (DBA)
Location: Burnaby, British Columbia
Work Arrangement: Hybrid
Employment Type: Contract
Job Summary
We are seeking a skilled and detail-oriented Database Administrator (DBA) to maintain, support, and improve the performance, integrity, and security of our corporate data systems. This role is critical in planning, managing, and optimizing SQL Server environments, including data migration, backup/recovery, and performance monitoring, while also contributing to the development of robust and scalable database architectures.
Key Responsibilities
Install, configure, and maintain on-premise Microsoft SQL Server environments.
Manage and monitor database storage, backups, replication, recovery, and encryption to ensure high availability and disaster readiness.
Design, develop, and maintain database architecture, including schema design and performance tuning.
Plan and coordinate data migration activities between systems.
Identify and resolve data abnormalities and system inefficiencies.
Liaise with internal teams and application staff to deliver aligned and secure business technology solutions.
Set up and maintain SSIS packages and data pipelines for ETL processes.
Ensure data security, integrity, and confidentiality through well-established protocols.
Serve as a project manager for infrastructure and database-related projects, assigning tasks and monitoring progress.
Research, evaluate, and recommend database and performance measurement tools to improve system operations.
Prepare technical designs and specifications to support development and integration initiatives.
Extensive hands-on experience with on-premise Microsoft SQL Server environments.
Strong understanding of database design, replication, mirroring, encryption, and performance tuning.
Experience in data modeling and ETL development using SSIS.
In-depth knowledge of software development practices and how they interact with database systems.
Proven experience in setting up new SQL servers and databases from the ground up.
Ability to create and enforce data security and backup standards.
Skilled in technical documentation, including design specs and system architecture.
Experience in performance measurement tools and metrics-driven database optimization.
Familiarity with cloud-based database solutions or hybrid environments.
Strong oral and written communication skills.
Ability to analyze and recommend improvements to existing data infrastructure.
Proven track record in self-directed work with minimal supervision.
Collaborative and capable of establishing effective relationships across departments.
Commitment to data confidentiality and compliance with security protocols.
We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.
Have questions or want to learn more about us? We would love to hear from you!
Altis Recruitment Team
Email: militaryfamilies@altis.com
613-230-3700
Welcome on behalf on the Altis Recruitment team! Altis has a long-standing business relationship with the Defence community. For more than 30 years, we have been grateful to work alongside the Department of National Defence and countless military professionals. We know that family members of military personnel often make many personal sacrifices to support their loved ones. We understand that it can be difficult to pursue a career when embracing sudden changes like relocation and deployment. For some, this has meant putting a pause on career goals or professional development. We would like to provide you with everything you need for a successful and confident job search – in addition to access to job opportunities. Download the checklists our experts have created to help you be at your best from application to interview.