Data Replication Engineer

McKesson•Richmond, VA

9d•Hybrid

About The Position

McKesson is seeking a highly skilled Data Replication Engineer to manage mission-critical, high-volume data streaming pipelines. This role ensures real-time data availability across a hybrid ecosystem, connecting on-premises relational databases with cloud infrastructure. The engineer will be responsible for the entire lifecycle of the replication environment, including job configuration, performance tuning, daily operations, and compliance auditing.

Requirements

BS degree in Computer Science or related field.
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), or Qlik Replicate (Experience with Qlik Enterprise Manager, task design, and endpoint configuration).
Deep understanding of transaction logs in relational databases (e.g., Oracle Redo/Archive logs, SQL Server Transaction logs, DB2).
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

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