Lead 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 designing, implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform
• Provides leadership for all policies and procedures that govern data operations, security, management and usage
• Participates in project management and sprint ceremonies to deliver solutions
• Mentors, coaches and guides members of the database team
• Communicates effectively with team members, other teams and stakeholders
• 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
• Provide support for development and testing including test data setup, automated testing scenarios, and dev/test environment data refreshes
• Research and evaluate emerging database technologies and trends to enhance the use of data and databases within the organization
• Accountable for complying with HIPAA security policies within the database platform
• Provides on-call coverage for production support and manage

Requirements

• BS degree in Information Systems, Engineering, or equivalent
• 10+ years experience with relational database administration
• 3+ years experience administering highly-available PostgreSQL databases
• Expert in RDBMS principles, database design and normalization
• Expert in PostgreSQL database architecture, concepts, features, and high-availability technologies
• Expert in query optimization, indexing knowledge, modeling basics, materialized views and partitioning
• Expert with PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL
• Proficiency with operating PostgreSQL in a Linux environment
• Experience with .NET clients using PpSQL a plus
• Experience with RDBMS in the cloud a plus
• Experience with agile …