PostgreSQL Database Administrator

hims & hers

Hims & Hers Health, Inc. (better known as Hims & Hers) is a multi-specialty telehealth platform building a virtual front door to the healthcare system. Hims & Hers connects consumers to licensed healthcare professionals, enabling people to access high-quality medical care—from wherever is most convenient—for numerous conditions related to primary care, mental health, sexual health, skincare, and more. Launched in November 2017, the platform also offers thoughtfully created and curated health and wellness products. With products and services available across all 50 states and Washington, D.C., Hims & Hers’ mission is to make it easier for all Americans to access affordable care and treatment for conditions that impact their daily lives. In January 2021, the company was listed on the NYSE at an initial valuation of $1.6 billion and is traded under the ticker symbol “HIMS”. To learn more about our brand and offerings, you can visit forhims.com and forhers.com.

We are looking for a PostgreSQL Database Administrator who will be a member of our engineering operations team. The PostgreSQL DBA is responsible for all aspects of PostgreSQL databases including administration, schema design, programming, security and performance. 

Responsibilities:

  • Manage and maintain PostgreSQL database servers in all environments
  • Design and implement redundancy and fail-over strategies
  • Conduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks
  • Design and implement backup/restoration strategies per data retention requirements
  • Provide support for software upgrades and patching
  • Mentor team members to develop talent on the PostgreSQL team
  • Provide insight to team leadership regarding best practices for PostgreSQL
  • Diagnose and resolve production issues
  • Maintain database security and auditability
  • Perform regular audits of DB access and use for HIPAA and SOX compliance 
  • Manage users and roles
  • Provide configuration, monitoring and on-call support for development, test, and production environments
  • Willingness to learn new skills that benefit the team and company

Requirements & Qualifications:

  • 3-5 years working as a database administrator working with PostgreSQL
  • Proficient level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views
  • Proficient level Postgres troubleshooting skills including identifying & resolving blocking, long running queries and other events that negatively impact the database
  • Collaborate with SRE and Engineering teams in resolving production issues impacting system stability
  • Ability to efficiently write database code without compromising data quality, privacy or security
  • Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
  • Desirable to have working knowledge of AWS Database Services
  • Prior experience with Public Cloud providers (AWS, GCP)
  • Familiarity with CI/CD tools such as Jenkins, CircleCI or GitHub Actions
  • Proficiency scripting in one or more languages such as Python or Bash
  • Able to handle multiple tasks in a fast-paced environment
  • Excellent verbal, written, and interpersonal communication skills

Hims is an Equal Opportunity Employer and considers applicants for employment without regard to race, color, religion, sex, orientation, national origin, age, disability, genetics or any other basis forbidden under federal, state, or local law. Hims considers all qualified applicants in accordance with the San Francisco Fair Chance Ordinance.

To apply, please visit the following URL:https://remoteOK.com/jobs/112362→