PostgreSQL Database Engineer

Job title:

PostgreSQL Database Engineer

Company

MealSuite

Job description

MealSuite, , is a privately owned SaaS organization comprising 190+ team members across the globe, with hub locations in Cambridge, ON, Canada, Dallas, TX, USA, and Ho Chi Minh City, Vietnam. Our suite of end-to-end foodservice technology solutions helps professionals across healthcare and aging services streamline their operations, save time, reduce food waste, and meet regulatory requirements, so they can focus on what matters most: improving the quality of patient and resident care.We’re looking for a skilled PostgreSQL Database Engineer to join our Engineering Team. Reporting to the Software Architect, you will be responsible for the design, implementation, management, and optimization of PostgreSQL databases to ensure high performance, security, and availability. The ideal candidate will have extensive experience working with PostgreSQL in a production environment and possess a strong understanding of database architecture, performance tuning, and scalability.A day in the life as a PostgreSQL Database Engineer:

• Design and maintain scalable, high-performance PostgreSQL database solutions for mission-critical applications.
• Optimize queries and database structures to improve performance, scalability, and reliability.
• Continuously monitor database performance, troubleshoot slow queries, and identify and implement necessary optimizations.
• Ensure data integrity, security, backup, and recovery strategies for PostgreSQL databases.
• Implement and manage database replication and clustering techniques to scale PostgreSQL databases effectively.
• Work closely with engineering teams, and DevOps teams to integrate PostgreSQL databases with other systems.
• Maintain detailed documentation of database configurations, processes, and best practices.
• Manage version upgrades, patching, and routine maintenance tasks for PostgreSQL.

If the below describe your knowledge, experience and character, this role could be for you:

• I have at least 4 years of experience as a Database Engineer or in a similar role with a strong focus on PostgreSQL.
• In-depth knowledge of relational database architecture, replication, and high-availability solutions (e.g., streaming replication, logical replication, pgpool, etc.).
• I possess strong skills in query optimization, index tuning, and performance tuning.
• I am familiar with PostgreSQL management tools (pgAdmin, psql), monitoring tools (e.g., pg_stat_statements, Prometheus), and backup solutions.
• I am knowledgeable on database security best practices (encryption, access control, auditing).
• I possess strong troubleshooting and problem-solving skills related to database performance, replication, reliability, and scalability.
• I’m willing to occasionally travel and have a valid passport and no travel restrictions that limit my ability to cross the border between Canada and the USA (and Vietnam if required for role).
• I thrive in an agile environment that is constantly changing and encourages team members to collectively collaborate and communicate
• I love to be directly involved in projects and initiatives that offer continued learning and endless opportunity to express my ideas and build my leadership skills

We know imposter syndrome can be REAL when applying for a new role, but please don’t let the confidence gap prevent you from taking a leap and applying for your dream job. Your future self will thank you!More to love about working at MealSuite:We are passionate people that care about others. The heart of what we do comes down to our mission to Deliver smiles and satisfaction to the continuum of care through an all-in-one foodservice management technology. .

• We’ve built a progressive culture that values teamwork and innovation. We listen to all voices and entrust team members with tasks that make a significant impact on the communities we serve.
• We’re growing sustainably. A career with MealSuite offers the innovation and agility of a startup matched with the stability of an established company in a growing industry.
• We take care of our employees too! Here are just a few of the great things we offer:

• Unlimited paid time off – yeah, you read that right! We trust our employees to build their own version of balance so they can feel rejuvenated to bring their best every day.
• Healthcare benefits – extended health, vision, dental, and paramedical coverage, critical illness, life and disability insurance, travel medical insurance, and access to Teladoc medical experts.
• Hybrid flexibility – we value the collaboration, mentorship and learning that come from physically working next to one another, as well as the benefits that remote work can offer.
• Work-life balance – this is supported by the fact that more than 90% of current employees agree that their leader supports their wellbeing.
• An inclusive workplace – women account for 53% of our employees and 58% of people leaders.
• Participation in our equity program – we’d love for you to share in MealSuite’s success as we continue to grow!
• Opportunities for career development and advancement – we support our employees in pursuing and achieving their professional goals.
• Purposeful work with a positive community impact – more than 90% of our North American employees agree that the company’s purpose aligns with their personal values. Learn more about our values at

.This role will require you to work in our office located in Cambridge, ON, up to 2 days a week. More than an hour away from the office location? Apply anyway, and we can talk through your options!Have we got your attention? Great! Here’s what’s next:Apply today with your resume and answers to our application questions.We’ll start reviewing candidates within two weeks of this position being posted and will reach out to you if we’d like to get to know you a bit better. We often get hundreds of applications for our roles (we feel very honoured that so many people are interested!) and try our best to get back to each person. If there’s a delay in our response, please don’t think we’ve forgotten about you. We may be taking our time to thoroughly review each candidate before deciding who to interview.We want to ensure that every qualified individual has an equal opportunity to work with us. If you require accommodation to our application process, please contact .

Expected salary

Location

Cambridge, ON

Job date

Thu, 20 Feb 2025 23:29:11 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnearcanada.com) you saw this job posting.