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 tot his job

Apply To this Job