Lead Database Engineer

Summary

Join TherapyNotes, a leading provider of behavioral health practice management and EHR software, as a Database professional. You will be responsible for designing, implementing, and maintaining critical PostgreSQL database systems supporting a 24x7 SaaS platform. This role requires extensive experience with PostgreSQL databases, both on-premise and in the cloud, and expertise in RDBMS principles, database design, and query optimization. You will provide leadership in data operations, security, and management, mentor team members, and collaborate with other teams. The ideal candidate will possess a BS degree in a relevant field and 10+ years of experience in relational database administration. TherapyNotes offers a competitive salary, comprehensive benefits, and a collaborative work environment.

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

• Design, implement, and maintain critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform
• Provide leadership for all policies and procedures that govern data operations, security, management and usage
• Participate in project management and sprint ceremonies to deliver solutions
• Mentor, coach and guide members of the database team
• Communicate effectively with team members, other teams and stakeholders
• Ensure the database design and operations support the availability, scalability, and recoverability needs of the business
• Perform tuning and capacity management to ensure the database meets the performance needs of the business
• Guide and provide 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
• Be accountable for complying with HIPAA security policies within the database platform
• Provide on-call coverage for production support and manage

Preferred Qualifications

• Experience with .NET clients using PpSQL
• Experience with RDBMS in the cloud
• Experience with agile software development and DevOps principles

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