SQL Database Administrator / Data Developer

Randstad Canada; Burnaby; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading organization in the Vancouver area is seeking a Full-Time Data Solutions Developer / DBA to design and maintain secure database systems. This role offers a balanced work arrangement with remote and on-site work, alongside opportunities for career growth and hands-on experience with innovative technologies. The ideal candidate will possess significant experience in database management and data solutions development, contributing to optimizing document management systems and crucial IT operations.

Benefits

Three days of remote work

Continuous learning opportunities

Career growth through hands-on experience

Start with a one-year contract

Qualifications

• Considerable experience with on-premise SQL Database environments.
• Thorough knowledge of database design principles.
• Ability to establish standards ensuring data integrity and security.

Responsibilities

• Backup and restore databases and manage user security protocols.
• Develop ETL pipelines and manage data workflows.
• Create and maintain advanced database objects, including stored procedures.

Skills

Database Administration

Data Solutions Development

Data Analytics

Cloud-based Solutions

Complex Data Queries

Tools

SQL

Python

R

SSIS

Azure SQL

Job description

Our client in the public sector is looking for a Full-Time Data Solutions Developer / DBA who will design, implement, and maintain secure database systems while developing innovative data solutions. We are seeking a collaborative team player and experienced database and data solutions developer skilled in database server administration, database design, security, and performance optimization, with a strong foundation in data analytics, cloud-based solutions, and complex data queries.

Advantages

• Enjoy the best of both worlds with three days of remote work and two days on-site, offering flexibility and a balanced approach to your work-life integration.
• Engage in continuous learning and career growth through hands-on experience with cutting-edge technology and opportunities for professional advancement.
• Play a crucial role in optimizing document management systems, directly contributing to the efficiency and effectiveness of operations.
• Work alongside a dedicated team of IT professionals and records management experts who are passionate about innovation and supportive of each other’s success.
• Start with a one-year contract, with the possibility of extension for up to three years, providing stability and the chance to build a lasting impact within the organization.

Responsibilities

Key Responsibilities

The role is a balanced mix of database administration and data solutions development, with the following breakdown :

50% DBA Responsibilities :

Backup and restore databases.

Set up users and security protocols.

Install and manage SQL databases on servers.

10% Data Science : Utilize tools like Python or R

10% Data Engineering : Develop ETL pipelines and manage data workflows.

10% Database Encryption / Data Replication : Implement TDE and manage replication processes such as snapshot, transactional, and merge replication.

10% Azure SQL : Manage and optimize cloud-based database solutions.

10% Complex Database Development : Create and maintain advanced database objects, including views, stored procedures, functions, and complex queries

Qualifications

onsiderable 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.

Summary

If you're ready to elevate your career and make a significant impact within a leading Vancouver organization, we want to hear from you! Apply directly to this job ad or reach out to your Randstad Digital representative immediately!

P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!

We look forward to supporting you in your job search!

Good luck!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [emailprotected] to ensure their ability to fully participate in the interview process.

Create a job alert for this search