Database Engineer
TherapyNotes, LLC
full-time
Posted on:
Location Type: Remote
Location: Remote • Pennsylvania • 🇺🇸 United States
Visit company websiteSalary
💰 $90,000 - $130,000 per year
Job Level
Mid-LevelSenior
Tech Stack
ETLITSMLinux.NETPostgresPythonRDBMSSQL
About the role
- 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)
- 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
Benefits
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PostgreSQLdatabase administrationETLdata warehousingreportingquery optimizationindex managementSQLscripting languagesDevOps
Soft skills
guidancedirectioncommunicationproblem-solvingcollaboration
Certifications
BS degree in Information SystemsBS degree in Data EngineeringBS degree in Data Sciences