Job Description:

About TherapyNotesTherapyNotes is a national leader in behavioral health Practice Management and Electronic Health Records (EHR) software. Our software-as-a-service (SaaS) solution is at the forefront of innovation, seamlessly integrating patient scheduling, billing, documenting, and managing telehealth sessions, enabling clinicians and practice managers to focus on what matters most: quality patient care.At TherapyNotes, we are a growing team of passionate and talented individuals. Our team thrives on collaboration and innovation, continually pushing the boundaries of what EHR software can do. We pride ourselves on our ability to adapt to the ever-evolving landscape of healthcare and technology, staying at the forefront of industry trends.We believe in pushing each other to learn and solve complex problems, fostering an environment where your skills and expertise will flourish. Together, we are shaping the future of behavioral health software, making it easier for clinicians to provide the best possible care to their patients.If you are passionate about technology, mental health, and making a difference, TherapyNotes is the place where you can realize your potential.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 designing, implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platformEnsures 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 pipelineProvide support for development and testing including test data setup, automated testing scenarios, and dev/test environment data refreshesResearch and evaluate emerging database technologies and trends to enhance the use of data and databases within the organizationProvides leadership for all policies and procedures that govern data operations, security, management and usageAccountable for complying with HIPAA security policies within the database platformProvides on-call coverage for production support and manageRequirementsBS degree in Information Systems, Engineering, or equivalent7+ years experience with relational database administration3+ years experience administering highly-available PostgreSQL databasesExpert in RDBMS principles, database design and normalizationExpert in PostgreSQL database architecture, concepts, features, and high-availability technologiesExpert in query optimization, indexing knowledge, modeling basics, materialized views and partitioningExpert with PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQLProficiency with operating PostgreSQL in a Linux environmentExperience with .NET clients using PpSQL a plusExperience with RDBMS in the cloud a plusExperience with agile software development and DevOps principles a plusCompetenciesProject Management - Develops project plans, coordinates projects, communicates changes and progress, completes projects on time and budget, and manages project team activities.Innovation - Displays original thinking and creativity, meets challenges with resourcefulness. generates suggestions for improving work, develops innovative approaches and ideas, and presents ideas and information in a manner that gets others' attention.Problem Solving - Identifies and resolves problems in a timely manner, gathers and analyzes information skillfully, develops alternative solutions, and works well in group problem solving situations.BenefitsCompetitive salary - $90,000-$125,000Comp-time and flexible work hoursFull health, life, disability, and dental insuranceRetirement plan with company contributionAnnual company profit sharingPersonal development/training budgetOpen, collaborative work environmentExtensive 2-week onboarding planComprehensive mentorship programCompany provided refreshments#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.5/8/2024