Lead Database Engineer

December 3

Apply Now

Receive Emails with Similar Jobs

TherapyNotes, LLC

WebsiteLinkedInAll Job Openings

practice management software • EMR • mental health • behavioral health • medical billing software

51 - 200 employees

Founded 2010

⚕️ Healthcare Insurance

☁️ SaaS

🧘 Wellness

Description

• 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! • 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. • 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 software development and DevOps principles a plus

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