Database administrator

Main Functions

The database administrator will be responsible for managing SQL Server databases, supporting critical business processes for Lallemand globally. You will be responsible managing the lifecycle of databases, including design, architecture, installation, configuration, monitoring, maintenance, optimization and support of multiple environments. You will assist application teams in the design and implementation of databases, you will assist the BI team in query design and performance tuning. Fully remote position.

• Design and Architecture database environments supporting critical business processes.
• Installation and configuration of database environments.
• Management of obsolescence.
• Capacity review and planning of databases, virtual machines and physical infrastructure.
• Troubleshoot issues reported by customers.
• Support application team in development, deployment and support of applications.
• Review and address all performance related issues.
• Monitor and proactively address risks and issues.
• Implement security best practices and support cybersecurity initiatives.
• Continuously evolve database standards and best practices.
• Design, implement and test availability and Disaster recovery.
• Design, implement and test backup strategy.
• Ensure proper licensing of database environments.

Technical skills

Required

• Excellent knowledge of Microsoft SQL Server from 2008 to 2019.
• Excellent knowledge of query and database performance tuning.
• Excellent knowledge of high availability and disaster recovery.
• Good experience in the design and implementation of security best practices.
• Good experience with Veeam or another database backup tool.
• Good experience with Foglight or another monitoring tool.
• Good experience in virtualization.
• Knowledge of SQL Server licensing.

An asset

• French Language
• rience in the design and implementation of Azure databases.

Personal abilities

Required

• Sense of initiative, resourcefulness, and autonomy.
• Great team spirit; team player.
• Work efficiently / Organized / Good time management
• Strong technical aptitude and experience with a wide variety of technologies.
• Ability to rapidly learn and if required evaluate new tools or technology
• Demonstrated technical innovative leadership experience.
• Must have a strong customer and quality focus.
• Be able to work occasionally under pressure
• Must be fluent in English (speaking French, Portuguese, and Spanish is an asset)

General criteria

Required

• Willing to travel to our offices around the world for projects, maintenance, installation, and meetings. Valid passport required.

Organization

Lallemand is a privately held Canadian company founded in the late 19th century, which develops, produces, and markets microorganisms for various markets. The administrative offices of the parent company are in Montreal, Canada. Today, Lallemand employs more than 4,500 people working in more than 45 countries on 5 continents.

Lallemand's corporate division encompasses all of the support services offered to our branches. Its goal is to optimize internal processes, ensure that your operation is running smoothly, and that your strategy is well thought-out.

Our corporate branch's head office is located in Montreal, Canada, and relies on a team that specializes in: Management; Finance and accounting; Engineering; Research and Development (R&D); Human Resources (HR); and Information Technology (IT). If you want to help bring enthusiasm, collaboration and innovation to our workplace, we'd love to get to know you!

Please take note that accommodations will be provided in all parts of the hiring process. Applicants need to make their needs known in advance.