Senior Data Engineer – OLTP, Data Guard, Golden Gate

PNC

Senior Data Engineer developing and maintaining highly available OLTP databases for PNC's Lending Tech organization. Collaborating with cross-functional teams to ensure data integrity and performance at scale.

Posted 4/16/2026full-timeMiamisburg • Alabama, Ohio, Pennsylvania, Texas • 🇺🇸 United StatesSenior💰 $42,000 - $172,250 per yearWebsite

Tech Stack

Tools & technologies

MySQLOracleSQL

About the role

Key responsibilities & impact

Design and evolve an enterprise transactional data model for lending payment processing (OLTP), including schemas, constraints, indexing strategies, partitioning, and retention/archival patterns.
Define database standards for reliability, scalability, performance, and resiliency across MySQL and Oracle.
Implement and operate high availability and disaster recovery patterns; validate operational readiness (failover/failback, replication health, recovery objectives).
Drive performance engineering: query tuning, index strategy, execution plan analysis, contention/locking analysis, and workload management.
Implement automation for database operations (provisioning support, patch readiness support, backup validation, health checks, and runbook-driven execution).
Design and support replication/data movement strategies as needed for resiliency and/or cross-site requirements (preferred Oracle skills include Golden Gate and Data Guard).
Partner with security to enforce encryption-in-transit/at-rest, least privilege, auditing, secrets management integration, and vulnerability remediation for database platforms.
Work closely with application teams on schema evolution, release coordination, and safe migration approaches (including MySQL ↔ Oracle considerations).

Requirements

What you’ll need

Strong hands-on experience designing and operating high-volume, enterprise OLTP databases supporting mission-critical transactions.
Advanced SQL and performance tuning experience across MySQL and Oracle (query tuning, indexing, partitioning, execution plan analysis).
Experience with operational best practices: backup/restore validation, patch planning, monitoring/alerting, incident response, and runbooks.
Proven ability to collaborate across engineering, operations, and security with clear, structured communication.
(Preferred) Oracle Exadata experience (engineering/tuning/operations on Exadata platforms).
(Preferred) Oracle Data Guard experience (HA/DR, role transitions, validation of primary/standby states).
(Preferred) Oracle Golden Gate experience (replication design/operations).
Understanding of enterprise MySQL deployment/replication patterns (e.g., primary/replica cross-site patterns).

Benefits

Comp & perks

medical/prescription drug coverage (with a Health Savings Account feature)
dental and vision options
employee and spouse/child life insurance
short and long-term disability protection
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

OLTPMySQLOracleSQLquery tuningindexingpartitioningbackup/restore validationperformance tuningreplication

Soft Skills

collaborationstructured communication