Principal Database Architect

RxSense is a high-growth healthtech company empowering clients and consumers with technology to access lower cost prescription drugs. Its transformative cloud-based enterprise platform enables clients to take control of their pharmacy benefits with fast, flexible and customizable solutions and real time data insights to improve operational and financial performance -- and ultimately deliver better care to patients nationwide. 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 more affordable medications and has helped millions of Americans collectively save over $8 billion on their medications.

RxSense is a great place to work! Our company has earned recognition as one of 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.

Summary:

We are looking for an experienced 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. This role will be driving day to day work with a strategic view.
Essential Duties and 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.

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.

Bonus Skills:

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

Salary: 150,000 - 180,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.