Lead Database Engineer

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