TherapyNotes is seeking an experienced database professional to join our growing team. The right candidate will have extensive experience administering PostgreSQL databases, both on-premise and in the cloud. They will be comfortable working
in a highly collaborative, DevOps culture working alongside members of our technology organization to administer PostgreSQL databases in our development, test, and production environments.
To apply, please visit
https://therapynotes.workable.com/
Responsibilities
- Responsible for designing, implementing, and managing critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform.
- 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.
- Provide support for development and testing including test data setup, automated testing scenarios, and dev/test environment data refreshes.
- Research and evaluate emerging database technologies and trends to enhance the use of data and databases within the organization.
- Provides leadership for all policies and procedures that govern data operations, security, management and usage.
- Accountable for complying with HIPAA security policies within the database platform.
- Provides on-call coverage for production support and manage.
Requirements
- 7+ years’ experience with relational database administration
- 3+ years’ experience administering highly-available PostgreSQL databases
- Familiarity with RDBMS principles, database design and normalization.
- Expert experience in PostgreSQL database architecture, concepts, features, and high-availability technologies.
- Expert experience in query optimization, indexing knowledge, modeling basics, materialized views and partitioning.
- Expert experience with PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL.
- Proficiency with operating PostgreSQL in a Linux environment.
- Experience with .NET clients using npSQL a plus.
- Experience with RDBMS in the cloud a plus.
- Experience with Oracle and MS SQL Server a plus.
- Understanding of agile software and DevOps principles a plus.
Benefits and Perks
TherapyNotes offers careers that provide you with the freedom to do amazing work, interact with great people, and offer fantastic learning and growth opportunities. Our team empowers and challenges each other to learn and solve complex
problems. We build and manage web applications with a strong emphasis in healthcare. If you are looking to join a supportive team, use your leadership experience, and build great products, please submit your application.
- Competitive salary
- Comp time and flexible work hours
- Retirement plan with company matching
- Full health, life, disability, and dental insurance
- Personal development/training budget
- Open, collaborative work environment
- Company provided refreshments
TherapyNotes is an Equal Employment Opportunity Employer. All candidates whom have been given a conditional offer of employment with TherapyNotes.com must also undergo a criminal background check.
|
