Database Specialist

2 weeks ago

Montréal QC, Canada Vision Group Full time

**DATABASE SPECIALIST**

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**
- You have flexible hours because we recognize the need to balance work with life.
- 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.
- You benefit from comprehensive group insurance, including telemedicine and an employee assistance program.
- You have a group RRSP with an employer contribution and an annual performance bonus.
- You can benefit from a free LASIK surgery.
- You can count yourself as a team member of one of Canada’s Best Managed Companies.
- This position offers the flexibility of remote work, allowing employees to work from their home.

***

**A Clear View of Your Assets**
- Hold a Bachelor's Degree in Computer Science, Mathematics, or a related field.
- Have at least 3-5 years of experience in SQL Server and DynamoDB.
- Possess excellent communication skills in French and English (oral and written).
- Translate business requirements into technical specifications.
- Microsoft SQL Server:

- Manage backup, restoration, and disaster recovery, including replication and Always On Availability Groups.
- Design relational database schemas (tables, indexes, relationships).
- Write and optimize SQL queries, stored procedures, user-defined functions, and triggers.
- Use SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT).
- Develop ETL processes using SQL Server Integration Services (SSIS).
- Create reports with SQL Server Reporting Services (SSRS).
- Monitor and optimize database performance, manage indexes, and troubleshoot slow queries.
- Amazon DynamoDB:

- Design model NoSQL data for DynamoDB, including schema design and performance optimization.
- Use DynamoDB Query Language (DQL) and understand read/write operations via the AWS API.
- Integrate DynamoDB with AWS services like Lambda, S3, Kinesis, and Glue for data extraction and processing.
- Script with Python or Node.js to interact with DynamoDB and automate tasks.
- Manage DynamoDB performance, configure read/write capacities, and optimize queries for cost management.
- Utilize BI and reporting tools that connect to DynamoDB. Experience with Amazon QuickSight is considered an asset.

**From our point of view

  • Customer Relationship Management

    1 week ago

    Montréal, Canada ACI World Full time

    **Position Title**: Customer Relationship Management (CRM) and Database Specialist **Reports to**: Director Communications and Marketing **Duration**: Permanent **Join our team for a work experience in a globally driven organization.** aci.aero/about-aci**/** **Responsibilities**: - Be responsible for developing and executing SMART database and CRM...

  • Specialist, Cloud Infrastructure

    1 week ago

    Montréal, QC, Canada Via HFR Full time

    At VIA HFR, we are re-imagining passenger rail service on behalf of the Government of Canada! Our goal is to create a new sustainable train network that that will run faster, more often and will be more reliable between Toronto and Québec City. The HFR project is Canada's largest infrastructure project in generations. Are you ready to take on a stimulating...

  • Quality Specialist

    1 week ago

    Montréal, QC, Canada Desjardins Full time

    As a Quality Specialist, you support IT efficiency. You design, configure, administer, maintain, upgrade and test the quality of business solutions, computer networks, management systems, programs and database servers based on the organization's needs. You analyze and help diagnose issues related to IT deliveries, rollouts, infrastructure operation, controls...

  • Pricing Specialist

    4 weeks ago

    Montréal, QC, Canada Fuze Logistics Services Inc Full time

    Pricing Specialist (Ocean Import/Export) - Montreal Office Fuze Logistics Services is a next generation 3PL headquartered in Montreal, with offices across North America, leveraging cutting-edge technologies and decades of industry expertise to facilitate the transport of freight globally. Fuze Logistics Services is seeking a Pricing Specialist to join our...

  • Pricing Specialist

    4 weeks ago

    Montréal, QC, Canada Fuze Logistics Services Inc Full time

    Pricing Specialist (Ocean Import/Export) - Montreal Office Fuze Logistics Services is a next generation 3PL headquartered in Montreal, with offices across North America, leveraging cutting-edge technologies and decades of industry expertise to facilitate the transport of freight globally. Fuze Logistics Services is seeking a Pricing Specialist to join our...

  • Pricing Specialist

    2 weeks ago

    Montréal, QC, Canada Fuze Logistics Services Inc Full time

    Pricing Specialist (Ocean Import/Export) - Montreal Office Fuze Logistics Services is a next generation 3PL headquartered in Montreal, with offices across North America, leveraging cutting-edge technologies and decades of industry expertise to facilitate the transport of freight globally. Fuze Logistics Services is seeking a Pricing Specialist to join our...

  • Quality Assurance Specialist

    2 weeks ago

    Montréal, QC, Canada Camp Systems International Inc. Full time

    CAMP is currently seeking a Quality Assurance Specialist to be located in our Wichita Kansas, Savannah Georgia, Ronkonkoma, New York, Clovis, CA, Merrimack, NH or Montreal office. **Overview** CAMP Systems is the leading provider of aircraft compliance and health management services to the global business aviation industry. CAMP is the pre-eminent brand in...

  • Asset Remarketing Specialist

    1 week ago

    Montréal, QC, Canada Mitsubishi HC Capital Canada Full time

    Mitsubishi HC Capital Canada and its parent company, Mitsubishi HC Capital America, form the largest non-captive, non-bank commercial finance company in North America constantly growing and transforming to contribute to a prosperous and sustainable future, creating social value through optimizing the potential of assets. Joining Mitsubishi HC Capital Canada...

  • Sourcing Specialist

    5 days ago

    Montréal, Canada Workplace Options Full time

    Workplace Options is the world’s largest independent wellbeing solutions leader that supports individuals to become healthier, happier and more productive, both personally and professionally. Service centers in the U.S., Canada, U.K., Ireland, Portugal, France, Belgium, UAE, Singapore, Japan, China, India and Indonesia support more than 75 million...

  • Change Integration Specialist

    2 weeks ago

    Montréal, QC, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...