PostgreSQL Database Administrator

Treez is not for everyone. Are you right for Treez?
The company values at Treez are:

- **S**tay Curious
- **P**resent Solutions
- **E**mbrace Simplicity
- **E**ncourage Candor
- **D**rive to Outcomes

With
**SPEED**, Treez team members are making an impact at our growing startup. We are motivated by our mission and do what it takes to get the job done. We need you to be as passionate as we are about making Treez the leader in powering the global cannabis economy. We are looking for hustlers, doers, people who see the goal and drive to it.

We are seeking a
**PostgreSQL Database Administrator (DBA) **to join our team. The right person for this position will be a self-starter who has 3 to 5 years of experience as a PostgreSQL Database Administrator at a SaaS software company. Also, must be living in Vancouver, BC area of Canada.

**WHAT YOU WILL DO**

As a PostgreSQL DBA at Treez you will be responsible for managing, maintaining, and optimizing our PostgreSQL database environments. You will play a critical role in ensuring the security, reliability, and performance of our database infrastructure.

**HOW YOU WILL DO IT**
- Manage and maintain the PostgreSQL database environment, including installation, configuration, and ongoing administration.
- Troubleshoot and resolve database-related issues, including performance bottlenecks, connectivity problems, and data corruption.
- Create and maintain documentation on database configurations, procedures, and troubleshooting steps.
- Monitor and optimize database performance, including query optimization, index tuning, and resource utilization.
- Implement and maintain database replication and high availability solutions.
- Develop and enforce database security policies and best practices, including user/role management, encryption, and auditing.
- Stay up to date with the latest PostgreSQL features, tools, and best practices.

**WHAT YOU WILL NEED**
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3 to 5 years of hands-on experience as a PostgreSQL (or similar) Database Administrator.
- Strong knowledge of SQL database administration, including backup, recovery, replication, and performance tuning.
- Familiarity with database security best practices, including user/role management, encryption, and auditing.
- Proficiency in SQL and PL/pgSQL languages.
- Experience with Citus or other distributed databases is a bonus.
- Working knowledge of AWS
- Excellent problem-solving skills and the ability to work independently and as part of a team.
- Strong communication and interpersonal skills.

If you are a highly motivated individual with a passion for database administration and a strong background in PostgreSQL, we would love to hear from you. Join our team and contribute to the success of our organization by ensuring the performance, security, and scalability of our database infrastructure.

**BENEFITS THAT TREEPLE ENJOY**
- A remote first work environment
- Medical, dental, vision and 401(K) - no match yet, we're a startup
- Equity

**COME AS YOU ARE**
Treez continually strives to create a diverse and inclusive environment. Treez provides equal employment opportunities to all job applicants and employees and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

**ABOUT TREEZ**
Treez is the leading enterprise cloud commerce platform that streamlines retail and supply chain operations within the cannabis market. Through its innovative technology for retailers and brands, the company provides a robust breadth and depth of software solutions required to operate a successful modern dispensary.
Solutions include point of sale, dispensary inventory management, omnichannel sales capabilities and multiple cashless payment options all on a mission-critical platform that ensures regulatory compliance across every supply chain transaction. The innovative platform also connects essential brands with their retailers through a centralized brand catalog with real-time market insights. The extensible open API platform provides smooth integration into a variety of best-of-breed solutions, including CRM, marketplace, cashless payments and data analytics across the partner ecosystem, giving retailers everything they need to grow their business.