Database Architect

Role Summary

This role is responsible for designing and evolving the organization’s cloud data architecture as applications are migrated and re-architected from on‑premises systems to Azure. The Data Architect will define scalable and secure data solutions leveraging Azure‑managed database services (Postgre

SQL Flexible Server, Azure SQL) and drive best practices in data modeling, integration, automation, and interoperability (including FHIR where applicable).

• Define reference architectures and reusable patterns that enable consistent adoption across multiple application teams.
• Design and maintain conceptual, logical, and physical data models for modernized applications.
• Define standards for data structures, naming conventions, and data lifecycle management.
• Ensure alignment between application architecture and data design (transactional + domain‑driven patterns).
• Design and guide implementation of solutions using Azure Postgre
  
  SQL Flexible Server, Azure SQL/SQL Server, and supporting Azure data services (ADF, Event Hubs, etc.).
• Establish architecture patterns for high availability, scalability, and disaster recovery.
• Provide guidance on database selection across relational and No
  
  SQL options.
• Lead data architecture for on‑prem to Azure migration and re‑platforming efforts.
• Define strategies for data migration (including near‑zero downtime approaches), data synchronization, cutover, schema modernization, and decomposition of legacy designs.
• Design integration patterns for batch and real‑time data movement.
• Support implementation of FHIR‑based data structures and interoperability patterns.
• Ensure consistency and quality across distributed data systems.
• Establish standards for data security and access controls (AAD, RBAC), data classification and protection, audit and compliance requirements (including healthcare considerations if FHIR is used).
• Ensure architecture aligns with enterprise governance models.
• Partner with application teams, DBAs, engineers, and business stakeholders to translate requirements into scalable data solutions.
• Act as a consultative architect, influencing design decisions without creating delivery bottlenecks.
• Produce and maintain architecture documentation, standards, and reference patterns.

• Bachelor’s degree or equivalent experience.
• 4+ years of experience in data architecture, database design, or data engineering.
• Strong knowledge (4+ years) of cloud‑native database platforms (Azure preferred).
• Hands‑on experience (4+ years) with Azure Postgre
  
  SQL (Flexible Server strongly preferred) and Azure SQL/SQL Server.
• Experience (4+ years) with database migration strategies, including data synchronization and low/zero‑downtime migration patterns.
• Proficiency (4+ years) in Terraform or equivalent Infrastructure‑as‑Code tools and CI/CD pipeline integration for database deployments.
• Solid understanding of data modeling (relational and No
  
  SQL) and distributed data patterns (sharding, CQRS, event‑driven architectures).
• Experience documenting data architecture standards and procedures.

• Experience with Azure ecosystem services (ADF, Synapse, Data Lake, Cosmos DB).
• Familiarity with FHIR and healthcare data interoperability standards.
• Experience with Liquibase or similar schema/versioning tools.
• Experience with ArgoCD or Git Ops deployment models.
• Exposure to domain‑driven design and microservices‑based data architecture.

$103,500 - $172,500

Priority will be given to candidates who reside in the Columbus, OH metropolitan area.

We do not provide sponsorship for this role presently or in the future.

McKesson provides equal employment opportunities to applicants and employees, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, genetic information, or any other legally protected category. For additional information on McKesson’s full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page. McKesson is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including job seekers with disabilities.

If you need a reasonable accommodation to assist with your job search or application for employment, please contact us by sending an email to (United States) Disabili or (Canada)  Resumes or CVs submitted to this email box will not be accepted.