TherapyNotes is hiring a
Database Engineer

Summary

TherapyNotes is seeking an experienced Database Administrator with expertise in PostgreSQL databases to join their team. The role involves managing critical database systems for a growing SaaS platform, ensuring performance, scalability, and recoverability, and providing guidance to developers on database development principles.

Requirements

• BS degree in Information Systems, Data Engineering, Data Sciences or equivalent
• 3+ years experience with relational database administration
• 3+ years experience administering highly-available PostgreSQL databases
• Proficiency in Linux-based PostgreSQL RDBMS database administration, architecture, concepts, features, and high-availability technologies
• Proficiency in data science principles such as warehousing, business intelligence reporting, and predictive analytics
• Proficiency in query optimization, indexing knowledge, modeling basics, materialized views, triggers, stored procedure development, and partitioning
• Proficiency in SQL and experience in any scripting language (e.g. PowerShell, Bash, Python)
• Experience with .NET database clients using NpgSQL a plus
• Proficiency with DevOps, Infrastructure as Code (IaC) strategies, and variable workload (container) orchestration
• Proficiency with ITIL and/or ITSM principles

Responsibilities

• Implementing and maintaining critical database systems (PostgreSQL)
• Supporting the ongoing database reporting and analytical needs of the organization
• Ensuring the database design and operations support the availability, scalability, and recoverability needs of the business
• Performing tuning and capacity management to ensure the database meets the performance needs of the business
• Guiding and providing direction to developers and engineers on database development, design principles, query optimization, and index management in a fully automated deployment pipeline
• Ensuring all infrastructure solutions and operational activities adhere to the security and operating policies established by the organization
• Providing on-call coverage for production support and other duties as required

Benefits

• Competitive salary - $75,000-$150,000
• Employer sponsored health, dental, vision, life, and disability insurance
• Retirement plan with company contribution
• Annual company profit sharing
• Personal development/training budget
• Open, collaborative work environment
• Extensive 2-week onboarding plan
• Comprehensive mentorship program