Database Specialist

3 months 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

  • Aero Engines Specialist

    4 months ago

    Montréal, QC, Canada Database Technology Full time

    **Job Role: Aero Engines Specialist - Engine Programs & Accessories** **Location: Montreal, QC-Canada** **Pls share skill matrix with submission**: - Yrs of exp in Aero Engine experience - Yrs of exp in stakeholder management. - Yrs of exp in LRU reliability data. **Must have Key skill - Aero Engine experience, LRU (Line replaceable Unit) specialist,...

  • Database Specialist

    4 days ago

    Montréal, QC, Canada AY Talent Full time

    DATABASE SPECIALIST Working with our clients means concretely contributing to their development and supporting more than 12 brands and more than 70 clinics across Canada and the United States. The Database Specialist manages, maintains, and optimizes the company's databases, including SQL Server and DynamoDB. This role involves administering SQL servers,...

  • Database Specialist

    4 days ago

    Montréal, QC, Canada AY Talent Full time

    DATABASE SPECIALIST Working with our clients means concretely contributing to their development and supporting more than 12 brands and more than 70 clinics across Canada and the United States. The Database Specialist manages, maintains, and optimizes the company's databases, including SQL Server and DynamoDB. This role involves administering SQL servers,...

  • Database Administrator

    1 month ago

    Montréal, QC, Canada Squarepoint Capital Full time

    Department: Application Engineering Position Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology. As part of this role will be focused on working collaboratively...

  • Database Administrator

    1 month ago

    Montréal, QC, Canada Squarepoint Capital Full time

    Department: Application Engineering Position Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology. As part of this role will be focused on working...

  • Lead Java Developer With Database

    1 month ago

    Montréal, QC, Canada Accolite Full time

    Opening from Canada (Remote) Bounteous x Accolite makes the future faster for the world's most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. Bounteous x Accolite brings together 5000+ employees spanning North America, APAC, and EMEA, and partnerships with leading technology...

  • Ms-SQL Database Administrator

    7 months ago

    Montréal, Canada Explorance Full time

    Join a Montreal headquarter company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative People Insight Solutions because we believe that each experience matters. Currently, we are looking to add a Database administrator to join our growing CloudOps team. **What you...

  • Administrateur(Trice), Base de Données

    7 months ago

    Montréal, Canada LGI Healthcare Solutions Santé Inc. Full time

    **Company Description** With 40 years of expertise, LGI Healthcare Solutions develops technological software for the healthcare network. We specialize in providing solutions for clinical, financial and material management, performance and analysis, and workforce management, which includes payroll management. Innovation is at the heart of our activities and...

  • Ms-SQL Database Administrator

    7 months ago

    Montréal, Canada Explorance Full time

    Join a Montreal headquartered company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative People Insight Solutions because we believe that each experience matters. Currently, we are looking to add a Database administrator to join our growing CloudOps team. **What...

  • Specialist, Cloud Infrastructure

    3 months 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...

  • Specialist Data Analysis

    4 days ago

    Montréal, QC, Canada AY Talent Full time

    DATABASE SPECIALIST Working with our clients means concretely contributing to their development and supporting more than 12 brands and more than 70 clinics across Canada and the United States. The Database Specialist manages, maintains, and optimizes the company's databases, including SQL Server and DynamoDB. This role involves administering SQL servers,...

  • Specialist, Digital Asset Operations Management

    7 days ago

    Montréal, QC, Canada billups Full time

    Company Overview: Reinventing out-of-home planning and placement for the performance age. billups is the leading independent out-of-home (OOH) specialist in North America and is continuing to grow in the EMEA and APAC regions. Delivering OOH managed services globally, helping advertisers and agencies strengthen media performance through our patented...

  • Quality Specialist

    2 months 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 diagnose issues related to controls, quality assurance and large-scale deliveries and...

  • Specialist Data and Analytics

    3 months ago

    Montréal, QC, Canada Air Canada Full time

    **Description** **Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.** Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best...

  • Lead Payroll Specialist

    4 months ago

    Montréal, QC, Canada Cosmetic Physician Partners Full time

    CPP Clinics is a leading provider of medical aesthetics services, offering innovative treatments across multiple medspas under the CPP umbrella. We are dedicated to delivering exceptional patient experiences and outstanding results, utilizing advanced technologies and personalized care. The Payroll Specialist is primarily responsible for processing payroll...

  • Hse Specialist, Subcontractor Management

    3 months ago

    Montréal, QC, Canada WSP Full time

    **The Opportunity**: Join our dynamic Health, Safety, and Security team as a Specialist in Subcontractor Management. In this role, you will lead and enhance our subcontractor management program, ensuring compliance with health, safety, and environmental standards. You will collaborate with various stakeholders, provide expert guidance, and oversee critical...

  • Quality Specialist

    2 months 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...

  • Marketing Specialist, Product Management

    3 months ago

    Montréal, QC, Canada Nestle Operational Services Worldwide SA Full time

    **A little about us** Nestlé Nespresso SA is the pioneer and reference for highest-quality portioned coffee. The company works with more than 120,000 farmers in 15 countries through its AAA Sustainable Quality Program to embed sustainability practices on farms and the surrounding landscapes. Launched in 2003 in collaboration with the NGO Rainforest...

  • Application Specialist

    3 months ago

    Montréal, QC, Canada Caterpillar Full time

    **Career Area**: Product Support **Your Work Shapes the World at Caterpillar Inc.** When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about...

  • Procurement Specialist

    3 months ago

    Montréal, QC, Canada Aecon Group Full time

    **Build Your Career at Aecon** Aecon is proud to build some of the most impactful infrastructure projects of this generation. From the roads and transit systems that connect our communities, to the communication networks that link us from coast-to-coast, and the water infrastructure that supplies our businesses and homes. Our integral work includes...