Database Engineer
TherapyNotes.com, United States
Job Description
About TherapyNotes
TherapyNotes is a national leader in behavioral health Practice Management and Electronic Health Records (EHR) software. Our software-as-a-service (SaaS) solution is at the forefront of innovation, seamlessly integrating patient scheduling, medical records, billing, and electronic claims to revolutionize how mental health professionals manage their practices.
At TherapyNotes, we are a growing team of passionate and talented individuals. Our team thrives on collaboration and innovation, continually pushing the boundaries of what EHR software can do. We pride ourselves on our ability to adapt to the ever-evolving landscape of healthcare and technology, staying at the forefront of industry trends.
We believe in pushing each other to learn and solve complex problems, fostering an environment where your skills and expertise will flourish. Together, we are shaping the future of behavioral health software, making it easier for clinicians to provide the best possible care to their patients.
If you are passionate about technology, mental health, and making a difference, TherapyNotes is the place where you can realize your potential.
DescriptionTherapyNotes 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 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
- 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)
- Experience with .NET database clients using NpgSQL a plus
- Proficiency with DevOps, Infrastructure as Code (IaC) strategies, and variable workload (container) orchestration
- Proficiency with ITIL and/or ITSM principles
- Project Management -Develops project plans, coordinates projects, communicates changes and progress, completes projects on time and budget, and manages project team activities.
- Innovation- Displays original thinking and creativity, meets challenges with resourcefulness. generates suggestions for improving work, develops innovative approaches and ideas, and presents ideas and information in a manner that gets others' attention.
- Problem Solving- Identifies and resolves problems in a timely manner, gathers and analyzes information skillfully, develops alternative solutions, and works well in group problem solving situations.
Benefits
- Competitive salary - $75,000-$115,000
- Comp-time and flexible work hours
- Full health, life, disability, and dental 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
- Company provided refreshments
#LI-Remote
#LI-PL1
TherapyNotes, LLC is an Equal Employment Opportunity Employer.All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.All candidates who