TherapyNotes is hiring a
Lead Database Engineer, Remote - United States

Summary

TherapyNotes is seeking an experienced database professional to join their growing team. The candidate will be responsible for designing, implementing, and maintaining critical database systems (PostgreSQL) supporting a 24x7 SaaS platform. They will work in a highly collaborative DevOps culture, mentor other team members, and ensure the database design and operations support the availability, scalability, and recoverability needs of the business.

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)
• 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

Benefits

• Competitive salary - $110,000-$150,000
• Employer provided medical, dental, vision, life, and disability insurance
• Retirement plan with company contribution
• Annual company profit sharing and bonus
• Personal development/training budget
• Open, collaborative work environment
• Extensive 2-week onboarding plan
• Comprehensive mentorship program