Database Specialist

Vision Group; Montreal; Remote; CAD 60,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Database Specialist, where you will manage and optimize databases for a leader in vision correction. This role offers the chance to work with both SQL Server and DynamoDB, utilizing advanced Microsoft tools for data management and visualization. With a commitment to a supportive work culture, you will enjoy flexible hours, generous vacation time, and the opportunity to work remotely. If you are passionate about data and ready to make a significant impact, this is the perfect opportunity for you to thrive in a collaborative environment.

Benefits

Flexible hours

3 weeks of vacation

4 personal days

3 additional days during Holiday season

Paid Friday afternoons in July and August

Comprehensive group insurance

Group RRSP with employer contribution

Annual performance bonus

Free LASIK surgery

Great Place to Work certification

Qualifications

• 3-5 years of experience in SQL Server and DynamoDB.
• Excellent communication skills in French and English.
• Ability to translate business requirements into technical specs.

Responsibilities

• Manage, maintain, and optimize company databases.
• Write stored procedures and utilize Microsoft tools for data management.
• Integrate NoSQL data with AWS services and BI tools.

Skills

SQL Server

DynamoDB

Microsoft SSIS

Microsoft SSRS

Power BI

Python

Node.js

Data Management

Database Optimization

Communication Skills

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Mathematics

Related Field Degree

Tools

SQL Server Management Studio (SSMS)

SQL Server Data Tools (SSDT)

AWS Services

Amazon QuickSight

Job description

Working at Vision Group's head office is working for the North American leader in vision correction. It means being able to concretely contribute to the development of the company and support more than 12 brands and more than 70 clinics across Canada and the United States. It's about having the wind in your sails and getting things done as a team in a relaxed environment. And all of this, while benefiting from a teleworking formula adapted to each employee.

The Database Specialist is responsible for the management, maintenance, and optimization of the company's databases, including both SQL Server and DynamoDB. This role involves the administration of SQL servers, writing stored procedures, and utilizing Microsoft tools such as SSIS, SSRS, and Power BI for data management and visualization. The specialist will also model and manage NoSQL data in DynamoDB, integrating it with other AWS services and BI tools. The holder of the position will work closely with the Senior Director of Technology as well as the Director of Business Systems to meet the company's data needs.

Join our team, where our Great Place to Work certification represents our commitment to creating a supportive and inclusive culture for every member of our organization.

A look at your benefits

1. You have flexible hours because we recognize the need to balance work with life.
2. You get 3 weeks of vacation, 4 personal days for unforeseen events, 3 additional days during the Holiday season and every Friday afternoon off paid in July and August.
3. You benefit from comprehensive group insurance, including telemedicine and an employee assistance program.
4. You have a group RRSP with an employer contribution and an annual performance bonus.
5. You can benefit from a free LASIK surgery.
6. You can count yourself as a team member of one of Canada’s Best Managed Companies.
7. This position offers the flexibility of remote work, allowing employees to work from their home.

A Clear View of Your Assets

1. Hold a Bachelor's Degree in Computer Science, Mathematics, or a related field.
2. Have at least 3-5 years of experience in SQL Server (mandatory) and DynamoDB (asset).
3. Possess excellent communication skills in French and English (oral and written).
4. Translate business requirements into technical specifications.
5. Microsoft SQL Server:
1. Manage backup, restoration, and disaster recovery, including replication and Always On Availability Groups.
2. Design relational database schemas (tables, indexes, relationships).
3. Apply data normalization and denormalization.
4. Write and optimize SQL queries, stored procedures, user-defined functions, and triggers.
5. Use SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT).
6. Create reports with SQL Server Reporting Services (SSRS).
7. Monitor and optimize database performance, manage indexes, and troubleshoot slow queries.
6. Amazon DynamoDB (asset):
1. Design model NoSQL data for DynamoDB, including schema design and performance optimization.
2. Use DynamoDB Query Language (DQL) and understand read/write operations via the AWS API.
3. Integrate DynamoDB with AWS services like Lambda, S3, Kinesis, and Glue for data extraction and processing.
4. Script with Python or Node.js to interact with DynamoDB and automate tasks.
5. Manage DynamoDB performance, configure read/write capacities, and optimize queries for cost management.
6. Utilize BI and reporting tools that connect to DynamoDB. Experience with Amazon QuickSight is considered an asset.

From our point of view

If you think you are the right candidate for this position and are ready to join a passionate and dedicated team, apply now.