Offer summary

Qualifications:

5+ years of experience as a SQL Server DBA, preferably in AWS or GCP environments., Proficient in TSQL, DML, DDL, and SSMS with strong troubleshooting skills., Experience with source control systems like Git and knowledge of Powershell and Bash., Familiarity with High Availability techniques and government security policies related to healthcare..

Key responsibilities:

Provide day-to-day database support for .NET applications using SQL Server.

Manage tasks within the Jira ticket system and provision user access.

Participate in weekly production code releases and manage replication jobs.

Assist with ad hoc reporting requests and respond to internal and external audit inquiries.

Job description

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 Summary:

We are looking for an experienced SQL Server DBA 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.

Essential 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
Provision access to users
Participate in 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

Requirements:

5 + 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 preferred
Jira, Confluence, Bit Bucket
Data modeling
Replication (any)
.NET
Python

Salary Range: 120,000 - 140,000

RxSense believes that a diverse workforce is a more talented and productive workforce. As such, we are an Equal Opportunity and Affirmative Action employer. Our recruitment process is free from discriminatory hiring practices and all qualified applicants are considered for employment without regard to race, color, religion, sex, gender, sexual orientation, gender identity, ancestry, age, or national origin. Neither will qualified applicants be discriminated against on the basis of disability or protected veteran status. We believe in the strength of the collaboration, creativity and sense of community a diverse workforce brings.

Required profile