TherapyNotes, LLC · 12 hours ago
Lead Database Engineer
Maximize your interview chances
Health CareTherapeutics
Insider Connection @TherapyNotes, LLC
Get 3x more responses when you reach out via email instead of LinkedIn.
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
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
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
Preferred
Experience with .NET clients using PpSQL
Experience with RDBMS in the cloud
Experience with agile software development and DevOps principles
Benefits
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