Database Engineer

About TherapyNotes TherapyNotes is the go-to superhero for behavioral health Practice Management and EHR software! Our top-notch SaaS solution handles scheduling, billing, documenting, telehealth, and more so clinicians can focus on awesome patient care. We're a dynamic team of pros who love to innovate and push the envelope, keeping our software cutting-edge. Join us, and let's revolutionize behavioral health software together while making a real difference! Description TherapyNotes is seeking an experienced database professional to join our growing team. The right candidate will have extensive experience with PostgreSQL databases, both on-premise and in the cloud. They will be comfortable working in a highly collaborative, DevOps culture working across the technology organization. Responsibilities Responsible for implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform Supports the ongoing database reporting and analytical needs of the organization Ensures the database design and operations support the availability, scalability, and recoverability needs of the business Performs tuning and capacity management to ensure the database meets the performance needs of the business Guides and provides direction to developers and engineers on database development, design principles, query optimization, and index management in a fully automated deployment pipeline Ensures all infrastructure solutions and operational activities adhere to the security and operating policies established by the organization Provides on-call coverage for production support and other duties as required 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 Benefits Competitive salary - $75,000-$115,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 #LI-Remote #LI-PL1 TherapyNotes, LLC is an Equal Employment Opportunity Employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. All candidates whom have been given a conditional offer of employment with TherapyNotes, LLC must also undergo a criminal background check. 9/13/24