RxSense

Database Architect

Princeton, New Jersey, United States

Not SpecifiedCompensation
Junior (1 to 2 years)Experience Level
Full TimeJob Type
UnknownVisa
Healthcare TechnologyIndustries

Company Information

RxSense is a leading healthcare technology company delivering innovative solutions for pharmacy benefits and prescription savings. Our enterprise platform brings transparency, flexibility, and efficiency to pharmacy benefit management, helping clients streamline operations and enabling consumers to save on prescriptions. By integrating intelligence across the pharmacy ecosystem, RxSense makes cost-effective healthcare more accessible. Whether for PBMs, pharmacies, or individuals, our solutions help modernize operations, reduce costs, and improve outcomes.

RxSense also owns and operates SingleCare, a free prescription savings service that offers consumers access to consistently low prices on prescription drugs. Through its partnerships with the country’s largest pharmacies and grocers, including CVS, Walgreens, Walmart, Kroger and Albertsons, SingleCare improves access and adherence to affordable medications and has helped millions of Americans save over $11 billion on their medications.

RxSense is a great place to work! Our company has earned several prestigious awards, including Fast Company’s Most Innovative Companies, Forbes’ Top Startup Employers, Modern Healthcare's Best Places to Work in Healthcare, and Inc’s Best in Business and Best Workplaces.

Position Overview

  • Location Type: [Not Specified]
  • Job Type: [Not Specified]
  • Salary: [Not Specified]

We are looking for an experienced SQL Server DBA/Database Architect with management experience to support our production and non-production environments. The role provides day-to-day database support for .NET (LINQ/Entity Framework) applications using SQL Server running primarily on AWS RDS. SQL Server constitutes 95% of our database environment but we do support other platforms. We also support RDS instances and VMs running Postgres, MySQL, and MongoDB. We are a 24/7/365 organization, and this role requires participation in an on-call rotation.

Responsibilities

  • Use monitoring tools to diagnose performance opportunities and provide suggestions and feedback to developers
  • Support the QA and dev teams with backups/restores of databases and instance snapshots
  • Manage assigned tasks within the Jira ticket system
  • Participate in bi-weekly production code releases and hot fixes
  • Manage replication jobs in data replication tool (CloudBasic)
  • Review Git pull requests that relate to data model, query, or schema changes
  • Respond to ad hoc reporting requests
  • Apply patches and updates
  • Assist auditors to respond to internal and external audit requests
  • Provide cross-functional communication and support to engineering and product teams
  • Provide system designs for data migrations, data replication between systems, and data management.
  • Participate in a weekly rotation for on-call support for critical business impacting issues outside of what the DBA NOC can triage.
  • Provide direction for SQL relational and non-relational data and schema mapping, indexes, and performance.

Requirements

  • 10 years of experience as a production support SQL Server DBA, preferably in an AWS or GCP environment, or in other cloud environments (or related data systems experience)
  • Proficient with TSQL, DML, DDL, SSMS
  • Strong troubleshooting and debugging skills
  • Must understand how to interpret a query plan, have deep knowledge of indexes and statistics
  • Able to respond to calls within the SLA when on-call
  • Able to import/export data using common SQL Server tools such as BCP, SSIS or Powershell
  • Proficient with Powershell (particularly dbatools) and a working knowledge of Bash
  • Experience with source control systems such as Git, TFS, SVN
  • Passion for embracing and learning new technologies
  • Experience with High Availability techniques to ensure maximum uptime when adding indexes, modifying large amounts of data, patching, and re-sizing instances.
  • Experience working with government (Medicaid, Medicare) security and government policies such as ISPE, ARS, GRC.

Bonus Skills

  • MySQL
  • MongoDB
  • PBM or Healthcare based business experience

Skills

SQL Server
AWS RDS
Postgres
MySQL
MongoDB
LINQ
Entity Framework
Performance Monitoring
Database Management

RxSense

Pharmacy benefits management technology solutions

About RxSense

RxSense provides technology solutions for the pharmacy benefits management (PBM) industry, focusing on simplifying and optimizing the management of pharmacy benefits and claims. Its main product is an enterprise platform that integrates real-time business intelligence and analytics, allowing PBMs to gain actionable insights and make informed decisions to improve their operations. This platform is modular, enabling clients to customize their use and enhance care delivery. RxSense differentiates itself from competitors by offering APIs that ensure interoperability between different systems, complying with industry standards. The company's goal is to transform the PBM industry by providing tools that enhance efficiency and empower clients with timely data and insights.

Boston, MassachusettsHeadquarters
2015Year Founded
GROWTH_EQUITY_VCCompany Stage
Data & Analytics, HealthcareIndustries
201-500Employees

Risks

Increased competition in the PBM space may pressure RxSense to innovate rapidly.
Partnership with Walgreens may expose RxSense to regulatory challenges.
Investment from Parthenon Capital could lead to strategic shifts causing internal disruptions.

Differentiation

RxSense offers a modular platform with real-time analytics for PBMs.
The company provides APIs compliant with FHIR and NCPDP standards for interoperability.
RxSense's platform delivers actionable insights for data-driven decision-making in pharmacy benefits.

Upsides

Partnership with Walgreens enhances consumer access to prescription discounts nationwide.
Growing demand for cloud-based healthcare solutions aligns with RxSense's offerings.
Collaboration with Scipher Medicine integrates precision medicine into pharmacy benefits management.

Land your dream remote job 3x faster with AI