What are the responsibilities and job description for the Lead Database Engineer position at TherapyNotes.com?
About TherapyNotesTherapyNotes 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 designing, implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platformProvides leadership for all policies and procedures that govern data operations, security, management and usageParticipates in project management and sprint ceremonies to deliver solutionsMentors, coaches and guides members of the database teamCommunicates effectively with team members, other teams and stakeholdersEnsures 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 organizationAccountable for complying with HIPAA security policies within the database platformProvides on-call coverage for production support and manageRequirementsBS degree in Information Systems, Engineering, or equivalent10 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 plusBenefitsCompetitive salary - $110,000-$150,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.1 / 22 / 2025
Salary : $110,000 - $150,000
