Database Administrator

Position Overview

• Location Type: Not Specified
• Job Type: Not Specified
• Salary: $120,000 - $140,000

RxSense is a leading healthcare technology company focused on innovative solutions for pharmacy benefits and prescription savings. Their enterprise platform enhances transparency, flexibility, and efficiency in pharmacy benefit management, aiding clients in streamlining operations and enabling consumers to save on prescriptions. RxSense also operates SingleCare, a prescription savings service that provides consumers with consistently low prices on prescription drugs, partnering with major pharmacies and grocers. RxSense has been recognized with awards such as Fast Company’s Most Innovative Companies and Forbes’ Top Startup Employers.

Position Summary

RxSense is seeking an experienced SQL Server DBA with management experience to support their production and non-production environments. This role involves daily database support for .NET applications utilizing SQL Server, primarily on AWS RDS. While SQL Server is the primary database system (95%), the company also supports RDS instances and VMs running Postgres, MySQL, and MongoDB. This is a 24/7/365 organization, and the role requires participation in an on-call rotation.

Essential Responsibilities

• Utilize monitoring tools to identify performance opportunities and provide feedback to developers.
• Support QA and development teams with database backups, restores, and instance snapshots.
• Manage assigned tasks within the Jira ticket system.
• Provision user access.
• Participate in weekly production code releases and hot fixes.
• Manage replication jobs using the CloudBasic data replication tool.
• Review Git pull requests related to data model, query, or schema changes.
• Respond to ad hoc reporting requests.
• Apply patches and updates.
• Assist auditors with 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, GCP, or other cloud environment.
• Proficiency in TSQL, DML, DDL, and SSMS.
• Strong troubleshooting and debugging skills.
• Deep understanding of query plan interpretation, indexes, and statistics.
• Ability to respond to calls within the SLA when on-call.
• Experience with data import/export using SQL Server tools like BCP, SSIS, or Powershell.
• Proficiency in Powershell (especially dbatools) and working knowledge of Bash.
• Experience with source control systems (Git, TFS, SVN).
• A passion for learning new technologies.
• Experience with High Availability techniques for ensuring uptime during index additions, large data modifications, patching, and instance resizing.
• Experience working with government (Medicaid, Medicare) security and policies (ISPE, ARS, GRC).

Bonus Skills

• MySQL
• MongoDB
• PBM or Healthcare business experience
• Jira, Confluence, Bit Bucket
• Data modeling
• Replication (any type)
• .NET
• Python

Company Information

RxSense is an Equal Opportunity and Affirmative Action employer, believing that a diverse workforce is a more talented and productive workforce.