Database Administrator

Summary

Join RxSense, a leading healthcare technology company, as a SQL Server DBA with management experience to support production and non-production database environments. You will provide day-to-day support for .NET applications using SQL Server on AWS RDS, along with other platforms like Postgres, MySQL, and MongoDB. This 24/7/365 role involves on-call rotation and participation in weekly production releases. Responsibilities include performance diagnosis, database backups/restores, user access provisioning, managing replication jobs, reviewing code changes, and responding to ad-hoc requests. The ideal candidate possesses 5+ years of experience as a production support SQL Server DBA, proficiency in T-SQL, strong troubleshooting skills, and experience with AWS or GCP environments. A competitive salary range of $120,000-$140,000 is offered.

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

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

Preferred Qualifications

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