TherapyNotes is a leading provider of behavioral health Practice Management and EHR software, seeking an experienced database professional to join their innovative team. The role involves implementing and maintaining PostgreSQL database systems to support a 24x7 SaaS platform, ensuring optimal performance, availability, and security while collaborating with developers and engineers.
Responsibilities:
- Responsible for implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform
- Supports the ongoing database ETL, warehousing, reporting and analytical needs of the organization
- 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
- Ensures all infrastructure solutions and operational activities adhere to the security and operating policies established by the organization
- Provides on-call coverage for production support and other duties as required
Requirements:
- BS degree in Information Systems, Data Engineering, Data Sciences or equivalent
- 3+ years experience with relational database administration
- 3+ years experience administering highly-available PostgreSQL databases
- Proficiency in Linux-based PostgreSQL RDBMS database administration, architecture, concepts, features, and high-availability technologies
- Proficiency in data science principles such as warehousing, business intelligence reporting, and predictive analytics
- Proficiency in query optimization, indexing knowledge, modeling basics, materialized views, triggers, stored procedure development, and partitioning
- Proficiency in SQL and experience in any scripting language (e.g. PowerShell, Bash, Python)
- Proficiency with DevOps, Infrastructure as Code (IaC) strategies, and variable workload (container) orchestration
- Proficiency with ITIL and/or ITSM principles
- Experience with .NET database clients using NpgSQL a plus