hims & hers is hiring a
Remote PostgreSQL Database Administrator
\nHims & 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.\n\nWe 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. \n\nResponsibilities:\n\n\nManage and maintain PostgreSQL database servers in all environments\n\nDesign and implement redundancy and fail-over strategies\n\nConduct performance tuning, performance monitoring, capacity planning, and other related monitoring and troubleshooting tasks\n\nDesign and implement backup/restoration strategies per data retention requirements\n\nProvide support for software upgrades and patching\n\nMentor team members to develop talent on the PostgreSQL team\n\nProvide insight to team leadership regarding best practices for PostgreSQL\n\nDiagnose and resolve production issues\n\nMaintain database security and auditability\n\nPerform regular audits of DB access and use for HIPAA and SOX compliance \n\nManage users and roles\n\nProvide configuration, monitoring and on-call support for development, test, and production environments\n\nWillingness to learn new skills that benefit the team and company\n\n\n\n\nRequirements & Qualifications:\n\n\n3-5 years working as a database administrator working with PostgreSQL\n\nProficient level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views\n\nProficient level Postgres troubleshooting skills including identifying & resolving blocking, long running queries and other events that negatively impact the database\n\nCollaborate with SRE and Engineering teams in resolving production issues impacting system stability\n\nAbility to efficiently write database code without compromising data quality, privacy or security\n\nKnowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels\n\nDesirable to have working knowledge of AWS Database Services\n\nPrior experience with Public Cloud providers (AWS, GCP)\n\nFamiliarity with CI/CD tools such as Jenkins, CircleCI or GitHub Actions\n\nProficiency scripting in one or more languages such as Python or Bash\n\nAble to handle multiple tasks in a fast-paced environment\n\nExcellent verbal, written, and interpersonal communication skills\n\n\n\n\nHims 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. \n\n#Salary and compensation\n
No salary data published by company so we estimated salary based on similar jobs related to Sales, Engineer, Senior, Marketing, Apache, Backend, Travel, Jira, Excel, Software, Cloud, Golang, Analyst, Full Stack, SaaS, Ecommerce, Accounting, Legal, Education, Video, Developer, Digital Nomad, Junior, Python, Payroll, Salesforce, Admin, Finance, Microsoft, React, JavaScript, Internship, Mobile, Director, Drupal and Database Admin jobs that are similar:\n\n
$67,500 — $120,000/year\n
\n\n#Benefits\n
๐ฐ 401(k)\n\n๐ Distributed team\n\nโฐ Async\n\n๐ค Vision insurance\n\n๐ฆท Dental insurance\n\n๐ Medical insurance\n\n๐ Unlimited vacation\n\n๐ Paid time off\n\n๐ 4 day workweek\n\n๐ฐ 401k matching\n\n๐ Company retreats\n\n๐ฌ Coworking budget\n\n๐ Learning budget\n\n๐ช Free gym membership\n\n๐ง Mental wellness budget\n\n๐ฅ Home office budget\n\n๐ฅง Pay in crypto\n\n๐ฅธ Pseudonymous\n\n๐ฐ Profit sharing\n\n๐ฐ Equity compensation\n\nโฌ๏ธ No whiteboard interview\n\n๐ No monitoring system\n\n๐ซ No politics at work\n\n๐
We hire old (and young)\n\n
\n\n#Location\nSan Francisco, California, United States