Database Developer (MS SQL/PostgreSQL)

TL;DR

Database Developer (MS SQL/PostgreSQL): Designing and developing efficient databases and ETL processes for a cannabis retail platform with an accent on performance optimization and data security. Focus on writing complex stored procedures, optimizing execution plans, and integrating data from diverse external sources.

Location: Remote (Global)

Company

An enterprise-grade all-in-one platform for cannabis retailers combining POS, eCommerce, Marketing, Analytics, and Inventory Management.

What you will do

• Design and develop MS SQL and PostgreSQL databases.
• Write complex SQL queries, stored procedures, triggers, and functions.
• Implement ETL processes to integrate data from APIs, external systems, and file imports.
• Optimize database performance and analyze execution plans to prevent bottlenecks.
• Manage database security, access control, and perform general maintenance and troubleshooting.
• Create and maintain technical documentation for database structures and processes.

Requirements

• At least 3 years of experience in database engineering focusing on internals.
• Strong proficiency in MS SQL and its modern features.
• Ability to analyze, solve, and prevent problems using execution plans for code optimization.
• Proactive mindset, critical thinking, and adaptability to a fast-evolving industry.

Culture & Benefits

• B2B contract with a US company, with salary paid in USD.
• 100% remote work environment with flexible hours (Core team time: 09:00-15:00 GMT).
• 20 paid vacation days, 12 holidays, and 3 sick leave days per year.
• Medical insurance provided after the probation period.
• Reimbursement for necessary equipment such as laptops and monitors.

Hiring process

• 45-minute initial call with a recruiter.
• 1.5-hour technical interview.
• 1-hour final interview with the Chapter Lead.