TherapyNotes.com
Lead Database Engineer
TherapyNotes.com, Remote, Oregon, United States,
About TherapyNotes
Want to make an application Make sure your CV is up to date, then read the following job specs carefully before applying.
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!
Description
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.
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 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
#LI-Remote #LI-PL1
TherapyNotes, LLC is an Equal Employment Opportunity Employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. All candidates whom have been given a conditional offer of employment with TherapyNotes, LLC must also undergo a criminal background check.
12/2/2024 Remote working/work at home options are available for this role.
Want to make an application Make sure your CV is up to date, then read the following job specs carefully before applying.
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!
Description
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.
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 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
#LI-Remote #LI-PL1
TherapyNotes, LLC is an Equal Employment Opportunity Employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. All candidates whom have been given a conditional offer of employment with TherapyNotes, LLC must also undergo a criminal background check.
12/2/2024 Remote working/work at home options are available for this role.