Staff Developer, Database Expert

Petal is a leading Canadian healthcare orchestration and billing company that revolutionizes healthcare systems to make them agile, efficient, and resilient by enabling the forecasting and shaping of world-class healthcare through Healthcare BI, advanced analytics, and informed insights.

Our commitment to fostering an exceptional workplace culture has earned us notable recognitions, including being listed as a Great Place to Work in both the technology and healthcare sectors.

Join us in our mission to empower healthcare innovators and improve healthcare differently.

Let's talk Tech Stack

The technologies you will work with in Petal's existing ecosystem are MySQL , Elasticsearch , and Azure DB for our foundational products.

The backend stack of our applications that interact with these databases is primarily composed of Ruby on Rails and .NET, in a monolithic architecture.

We are currently undergoing a technological transition and a major overhaul of our main products, so you will mainly work on new relational and document database models, such as MongoDB, in modern event-driven and microservices architectures.

We are a SaaS company that aims to implement the best DevOps approaches. Our infrastructures are cloud-based, entirely as code with Terraform , and our latest applications are managed by container and deployed under Kubernetes .

Automating the deployment pipeline is a priority for us, and we use various platforms, including GitLab , for implementation.

We firmly believe in a continuous deployment approach and have achieved high maturity in this regard, deploying code to production environments multiple times a day.

Our web and mobile applications use modern tools such as Angular and React Native , RxJS , Redux , and Storybook . Quality is at the core of our principles, and all this code is tested using frameworks such as Jest , Playwright , as well as end-to-end testing libraries and services.

What you can expect when joining the team

Reporting to the Director of Software Development, you will play a key and central role within the various product development teams and the Petal platform as an expert in database development, modelling, and designing efficient and secure database solutions.

You will work with software development leaders to design, evaluate, implement, and optimize database models and systems, as well as train people on best practices.

Your daily life

In your day to day, you will be led to :

• Understand the challenges of data management and operations and develop effective and appropriate solutions;
• Design and implement efficient and secure database solutions, migration solutions, and data persistence management over time;
• Evaluate existing database systems to identify areas for improvement;
• Collaborate with the development team to design optimized database schemas;
• Establish data backup and recovery procedures in collaboration with the teams that will operate these databases;
• Ensure the performance, security, availability, and integrity of the databases;
• Train and establish best practices among software developers and other stakeholders.

Your profile

Are you an experienced and motivated database expert, known for your positive attitude, work ethic, as well as your technical and interpersonal skills?

Are you valued for your ability to identify issues and respond with effective solutions and approaches? Are you driven by the unique opportunity to contribute to a greater cause in the healthcare industry through innovative solutions based on people, data, and technology?

The sky is the limit! If you have :

• Over 5 years of proven experience as a database architect;
• A degree in computer science or a related field;
• Excellent knowledge of relational database management systems like MySQL and Azure DB;
• Excellent knowledge of the data indexing and search software ElasticSearch;
• Excellent knowledge in SQL query optimization and various approaches to optimizing data access and storage;
• A good understanding of data protection principles and legislation;
• Good knowledge of using an ORM in development and its impacts on data modeling;
• Good knowledge of best data management practices in a microservices or event-driven architecture;
• Solid experience in product or software development as a database expert in agile delivery;
• The ability to work well in a team and communicate effectively;
• Experience in software development in web or microservices contexts (an asset);
• Good knowledge of document-oriented database management systems like MongoDB (an asset);
• Since you will be regularly interacting with English-speaking colleagues located outside of Québec, proficiency in both English and French (spoken, written, and read) is preferable.

Petal’s position on remote working

In our opinion, a company cannot claim to be modern, innovative and have the well-being of their team at heart, without attempting to integrate remote working to the level that their business model allows them to.

Petal employees continue to benefit from the option of teleworking up to the maximum flexibility permitted by the nature of the position and the smooth running of operations.

Our benefits

• A signing bonus of $1,000 for your remote work set-up;
• Compensation that recognizes your contribution;
• 4 to 6 weeks of paid vacation per year;
• 5 paid personal days per year ;
• A group RRSP / DPSP plan with employer contribution;
• A complete group insurance plan, from day 1;
• An annual wellness allowance;
• Access to the Lumino Health telehealth application;
• Flexible work hours and more.

Petal is an active participant in the equal opportunity employment program, and members of the following target groups are encouraged to apply : women, people with disabilities, aboriginal peoples and visible minorities.

If you are a person with a disability, assistance with the screening and selection process is available on request.