TherapyNotes is hiring a
Lead Database Engineer

Summary

Join us and let's revolutionize behavioral health software together while making a real difference! We're 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.

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

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

Benefits

• Competitive salary - $110,000-$150,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