Data Architect Principal
SagentSalary not specified
- Full Time
- Expert & Leadership (9+ years)
Not SpecifiedCompensation
Junior (1 to 2 years)Experience Level
Full TimeJob Type
UnknownVisa
Healthcare TechnologyIndustries
Requirements
Candidates should possess 10 years of experience as a production support SQL Server DBA, preferably in an AWS or GCP environment, or in other cloud environments, with proficiency in TSQL, DML, DDL, and SSMS, along with strong troubleshooting and debugging skills, understanding of query plans, indexes, and statistics, and experience with source control systems such as Git, TFS, or SVN. Furthermore, they must be able to respond to calls within the SLA when on-call, import/export data using SQL Server tools, and be proficient with Powershell (particularly dbatools) and Bash, and demonstrate a passion for embracing new technologies, along with experience with High Availability techniques and government (Medicaid, Medicare) security and government policies such as ISPE, ARS, and GRC.
Responsibilities
The Database Architect will provide day-to-day database support for .NET (LINQ/Entity Framework) applications using SQL Server running primarily on AWS RDS, monitoring performance opportunities and providing feedback to developers, supporting the QA and dev teams with backups/restores, managing assigned Jira tasks, participating in code releases and hot fixes, managing replication jobs, reviewing Git pull requests related to data model changes, responding to ad hoc reporting requests, applying patches and updates, assisting auditors, providing system designs for data migrations and replication, participating in an on-call rotation for critical issues, and providing direction for SQL relational and non-relational data and schema mapping, indexes, and performance.
Skills
SQL Server
AWS RDS
Postgres
MySQL
MongoDB
LINQ
Entity Framework
Performance Monitoring
Database Management
RxSense
Pharmacy benefits management technology solutions
About RxSense
RxSense provides technology solutions for the pharmacy benefits management (PBM) industry, focusing on simplifying and optimizing the management of pharmacy benefits and claims. Its main product is an enterprise platform that integrates real-time business intelligence and analytics, allowing PBMs to gain actionable insights and make informed decisions to improve their operations. This platform is modular, enabling clients to customize their use and enhance care delivery. RxSense differentiates itself from competitors by offering APIs that ensure interoperability between different systems, complying with industry standards. The company's goal is to transform the PBM industry by providing tools that enhance efficiency and empower clients with timely data and insights.
Key Metrics
Boston, MassachusettsHeadquarters
2015Year Founded
GROWTH_EQUITY_VCCompany Stage
Data & Analytics, HealthcareIndustries
201-500Employees