Data Replication Engineer

McKesson•Richmond, VA

1d•$127,400 - $212,300

About The Position

McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve – we care. What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you. We are seeking a highly skilled Data Replication Engineer to manage our mission-critical, high-volume data streaming pipelines. In this role, you will ensure real-time data availability across our hybrid ecosystem, bridging traditional on-premises relational databases with modern cloud infrastructure. You will own the entire lifecycle of our replication environment, from initial job configuration and performance tuning to daily operations and compliance auditing.

Requirements

BS degree in Computer Science or related field. Advanced degree preferred.
Minimum 3–5 years of direct experience administering at least one of the following enterprise tools: Oracle GoldenGate: Experience with Extract, Replicat, and Microservices Architecture. IBM InfoSphere CDC: Knowledge of Access Server, Management Console, and source/target engines. Qlik Replicate: Experience with Qlik Enterprise Manager, task design, and endpoint configuration.
Sources: Deep understanding of transaction logs in relational databases (e.g., Oracle Redo/Archive logs, SQL Server Transaction logs, DB2).
Targets: Proven track record of streaming data into cloud data warehouses (e.g., Snowflake, Google BigQuery, AWS Redshift, Databricks).
Advanced SQL scripting, database indexing knowledge, and proficiency in Linux/Unix shell scripting or PowerShell.

Nice To Haves

Advanced degree preferred.

Responsibilities

Proactive Monitoring: Establish, monitor, and respond to alerts regarding replication lag, latency, and throughput bottlenecks.
Incident Management: Troubleshoot and resolve complex replication failures, data mismatches, and pipeline interruptions to meet strict SLAs.
Health Assessments: Perform daily health checks on log readers, capture processes, network delivery scripts, and target appliers.
Pipeline Configuration: Map, configure, and deploy end-to-end change data capture (CDC) workflows for new business applications.
Schema Evolution: Manage database schema changes (DDL replication) without disrupting downstream analytics and reporting.
Data Validation: Implement automated reconciliation jobs to ensure strict data consistency and integrity between source and target systems.
Lifecycle Management: Plan, test, and execute software upgrades, patches, and hotfixes for replication tools during maintenance windows.
Infrastructure Scaling: Coordinate with DBA and Cloud teams to provision compute, memory, and storage resources as data volumes grow.
Disaster Recovery: Design, document, and test failover and recovery procedures for the replication infrastructure.
Audit Support: Produce evidence, documentation, and lineage maps to satisfy internal and external compliance and data governance inquiries.
Access Control: Implement role-based access control (RBAC) and secure credential management (e.g., secret vaults) across replication tools.
Data Security: Ensure data encryption protocols (TLS/SSL) are applied to all data in transit across networks and cloud boundaries.