Simplify Logo

Full-Time

Principal Database Architect

Posted on 6/27/2024

RxSense

RxSense

201-500 employees

Pharmacy benefits management analytics platform

Financial Services
Data & Analytics

Compensation Overview

$150k - $180kAnnually

Expert

Princeton, NJ, USA

Category
Data Management
Data Engineering
Data & Analytics
Required Skills
Bash
MySQL
Git
SQL
AWS
JIRA
MongoDB
Google Cloud Platform
Requirements
  • 10+ years of experience as a production support SQL Server DBA, preferably in an AWS or GCP environment, or in other cloud environments
  • 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
Responsibilities
  • Responsible for Relational databases (SQL Server, MySQL, etc.) and No-SQL databases (MongoDB Atlas)
  • Lead the design, implementation, and maintenance of database architectures including data migrations, data replication and data management
  • Develop and maintain intelligent and robust automation for routine database tasks
  • Manage teamwork via Jira ticket system
  • Ensure high availability of critical databases, including failover, redundancy mechanisms and data replication (CloudBasic used)
  • Ensure databases meet organizational requirements, including performance, scalability, security, and availability
  • Analyze and optimize database performance, including query optimization, indexing, and storage management
  • Oversee the installation, configuration, upgrading, and patching of database servers
  • Ensure data integrity, backup, and recovery processes are in place and effective
  • Support the QA and dev teams with lower environment refreshes
  • Lead the resolution of database-related incidents and issues
  • Collaborate with application development teams, system administrators, and other stakeholders
  • Monitor and forecast database growth and capacity requirements
  • Responsible for optimal developer queries and good database design via support and code approvals
  • Assist auditors to respond to internal and external audit requests
  • Participate in bi-weekly production code releases and hot fixes
  • Participate in a weekly rotation for on-call support for critical business impacting issues outside of what the DBA NOC can triage
  • Implement and maintain database monitoring tools and dashboards

RxSense offers RxIQ Enterprise, a leading analytics and adjudication platform for pharmacy benefits management, leveraging advanced technologies such as API-based interoperability and real-time analytics to empower PBMs with flexible, efficient, and transparent pharmacy benefits administration. The platform also features lightning-fast claims adjudication, providing real-time control and actionable insights for pharmacy ecosystem management.

Company Stage

Private

Total Funding

N/A

Headquarters

Boston, Massachusetts

Founded

2015

Growth & Insights
Headcount

6 month growth

5%

1 year growth

8%

2 year growth

24%