Lead Database Engineer
Austin, Texas, United States - Remote
About TherapyNotes
TherapyNotes is a national leader in behavioral health Practice Management and Electronic Health Records (EHR) software. Our software-as-a-service (SaaS) solution is at the forefront of innovation, seamlessly integrating patient scheduling, billing, documenting, and managing telehealth sessions, enabling clinicians and practice managers to focus on what matters most: quality patient care.
At TherapyNotes, we are a growing team of passionate and talented individuals. Our team thrives on collaboration and innovation, continually pushing the boundaries of what EHR software can do. We pride ourselves on our ability to adapt to the ever-evolving landscape of healthcare and technology, staying at the forefront of industry trends.
We believe in pushing each other to learn and solve complex problems, fostering an environment where your skills and expertise will flourish. Together, we are shaping the future of behavioral health software, making it easier for clinicians to provide the best possible care to their patients.
If you are passionate about technology, mental health, and making a difference, TherapyNotes is the place where you can realize your potential.
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 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
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.
#LI-Remote
#LI-PL1
Job Profile
$110,000-$150,000 2-week onboarding plan Collaborative work environment Competitive salary Disability Insurance Extensive 2-week onboarding plan Medical, dental, vision, life, and disability insurance Mentorship Mentorship Program Open, collaborative work environment Personal development/training budget Profit Sharing Retirement plan Retirement plan with company contribution
Tasks- Comply with HIPAA security policies
- Design, implement, and maintain critical PostgreSQL databases
- Ensure database design supports business needs
- Guide developers on database development and design principles
- Mentor and guide database team members
- Participate in project management and sprint ceremonies
- Perform tuning and capacity management
- Provide leadership for data operations, security, and management
- Provide on-call coverage for production support
- Research and evaluate emerging database technologies
Agile Database Administration Database design Database Management DevOps HIPAA Security Linux PL/pgSQL PostgreSQL Query optimization
Experience10+ years
EducationBS degree in Information Systems BS in Information Systems Business Engineering Information Systems
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9