Data Engineer – Oracle, MySQL, OLTP

PNC

Data Engineer for PNC's Lending Tech organization designing and maintaining high-volume enterprise databases. Collaborating with application teams on database architecture and operational excellence.

Posted 4/29/2026full-timeMiamisburg • Alabama, Ohio, Pennsylvania, Texas • 🇺🇸 United StatesMid-LevelSenior💰 $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).

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.
Oracle Exadata experience (engineering/tuning/operations on Exadata platforms).
Oracle Data Guard experience (HA/DR, role transitions, validation of primary/standby states).
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

OLTPSQLperformance tuningindexingpartitioningquery tuningbackup/restore validationmonitoring/alertingreplicationdata movement strategies

Soft Skills

collaborationstructured communication