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