Location: all cities,AK, USA
About TherapyNotesHave you got the right qualifications and skills for this job Find out below, and hit apply to be considered.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!DescriptionTherapyNotes 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.ResponsibilitiesResponsible for implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platformSupports the ongoing database reporting and analytical needs of the organizationEnsures the database design and operations support the availability, scalability, and recoverability needs of the businessPerforms tuning and capacity management to ensure the database meets the performance needs of the businessGuides and provides direction to developers and engineers on database development, design principles, query optimization, and index management in a fully automated deployment pipelineEnsures all infrastructure solutions and operational activities adhere to the security and operating policies established by the organizationProvides on-call coverage for production support and other duties as requiredRequirementsBS degree in Information Systems, Data Engineering, Data Sciences or equivalent3+ years experience with relational database administration3+ years experience administering highly-available PostgreSQL databasesProficiency in Linux-based PostgreSQL RDBMS database administration, architecture, concepts, features, and high-availability technologiesProficiency in data science principles such as warehousing, business intelligence reporting, and predictive analyticsProficiency in query optimization, indexing knowledge, modeling basics, materialized views, triggers, stored procedure development, and partitioningProficiency in SQL and experience in any scripting language (e.g. PowerShell, Bash, Python)Experience with .NET database clients using NpgSQL a plusProficiency with DevOps, Infrastructure as Code (IaC) strategies, and variable workload (container) orchestrationProficiency with ITIL and/or ITSM principlesBenefitsCompetitive salary - $75,000-$115,000Employer sponsored health, dental, vision, life, and disability insuranceRetirement plan with company contributionAnnual company profit sharingPersonal development/training budgetOpen, collaborative work environmentExtensive 2-week onboarding planComprehensive mentorship program#LI-Remote#LI-PL1TherapyNotes, 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/24Remote working/work at home options are available for this role.