PostgreSQL Database Engineer
About the position
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 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
Nice-to-haves
ā¢ Experience with .NET database clients using NpgSQL a plus
Benefits
ā¢ Competitive salary - $90,000-$130,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
Apply Now
Apply Now
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 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
Nice-to-haves
ā¢ Experience with .NET database clients using NpgSQL a plus
Benefits
ā¢ Competitive salary - $90,000-$130,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
Apply Now
Apply Now