[Remote] Senior Database Administrator at SmithRx

Remote

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Health-Tech, Pharmacy Benefit ManagementIndustries

Requirements

5+ years of experience in Database Administration
BS or advanced degree in computer science or other related field
Experience working and managing SQL and NoSQL databases like PostgreSQL, MySQL, Redis, Redshift, DynamoDB, BigQuery, MongoDB, Cassandra and Snowflake
Deep understanding of AWS Database services, especially AWS RDS, Aurora, Redshift, DynamoDB etc
Ability to use tools to identify bottlenecks or performance problems enabling query and schema optimization

Responsibilities

Manage and maintain PostgreSQL, DynamoDB and Athena databases running on AWS Cloud, ensuring high availability and reliability
Monitor the performance and overall health of databases, proactively identifying and resolving issues
Design and implement growth strategies for databases, ensuring they can handle rapidly increasing demands
Develop, implement and maintain very high security standards to protect highly sensitive PHI data from external and internal threats
Ensure compliance with various database privacy regulations and frameworks like HIPAA, SOC2 etc
Design and implement Business Continuity Plan (BCP) and Disaster Recovery (DR) Plan
Develop and maintain a pipeline to restore anonymized data from production to lower environments
Work closely with the security team to develop comprehensive risk analysis and response for data infrastructure
Collaborate with development, architecture, and release teams providing architectural design recommendations to effectively adapt the database environment to support new platform features and capabilities
Work closely with the Data Engineering team to build, maintain and troubleshoot ETL jobs for downstream applications
Support software development teams to drive proper coding practices and assist in the development of complex queries, tuning of DML

Skills

Key technologies and capabilities for this role

Database AdministrationCloud DatabasesPerformance TuningQuery OptimizationMonitoringScalingMaintenanceUpgrades

Questions & Answers

Common questions about this position

What databases will I be working with in this role?

You will manage and maintain PostgreSQL, DynamoDB, and Athena databases running on AWS Cloud.

What are the key responsibilities of the Senior Database Administrator?

Responsibilities include ensuring reliability and efficiency of data infrastructure through maintenance, upgrades, monitoring, performance tuning, scaling, query optimization, security for PHI data, HIPAA/SOC2 compliance, BCP/DR planning, and collaboration with the security team.

What is the company culture like at SmithRx?

SmithRx has a mission-driven and collaborative culture guided by core values of Integrity, Courage, and Together, inspiring employees to do their best work in transforming the U.S. healthcare system.

Is this a remote position or does it require office work?

This information is not specified in the job description.

What experience is required for this Senior Database Administrator role?

Hands-on experience designing and administering cloud-based Database systems is required, particularly with PostgreSQL, DynamoDB, and Athena on AWS, to handle a user base doubling annually.

SmithRx

Pharmacy benefit management with transparent pricing

About SmithRx

SmithRx operates as a Pharmacy Benefit Manager (PBM) that focuses on managing prescription drug plans for self-insured employers and plan sponsors. The company uses a transparent pricing model called "Pass Through Pricing," where it charges only an administrative fee and passes all rebates from prescriptions directly to clients and their members. This model contrasts with traditional PBMs that often inflate drug prices and retain rebates for profit. SmithRx's clients benefit from a technology platform that utilizes real-time data to improve service delivery, ensuring efficient and high-quality pharmacy benefit management. The company also provides a concierge service to enhance support for both members and clients. SmithRx aims to simplify pharmacy benefits while maximizing value for its clients through transparency, advanced technology, and exceptional customer service.

San Francisco, CaliforniaHeadquarters

2016Year Founded

$94.8MTotal Funding

SERIES_CCompany Stage

HealthcareIndustries

201-500Employees

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

Disability Insurance

Health Savings Account/Flexible Spending Account

Unlimited Paid Time Off

Paid Holidays

Wellness Program

Commuter Benefits

Parental Leave

Mental Health Support

Professional Development Budget

Risks

Increased competition from technology-driven PBMs like Capital Rx could erode market share.

Rapid technological advancements may require costly updates to SmithRx's platform.

Potential regulatory scrutiny on PBM pricing models could impact SmithRx's business model.

Differentiation

SmithRx uses a transparent 'Pass Through Pricing' model, unlike traditional PBMs.

The company leverages real-time data for efficient pharmacy benefit management services.

SmithRx offers concierge-level service, enhancing customer satisfaction and support.

Upsides

SmithRx secured $60M in Series C funding, indicating strong investor confidence.

Partnership with Banjo Health enhances prior authorization processes using AI technology.

Collaboration with TheracosBio offers cost-effective drug options for Type 2 Diabetes.

Land your dream remote job 3x faster with AI

Try Jobo Free