SQL Database Administrator/Data Developer

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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.

Canada
Ontario
Burnaby Show on map Get directions