Data Engineer - Oracle, MySQL, OLTP

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We work together each day to foster an inclusive workplace culture where all employees feel respected, valued, and have an opportunity to contribute to the company’s success.

As a Data Engineer within PNC’s Lending Tech organization, you will be based in Miamisburg, OH, Pittsburgh, PA, Dallas, TX, Birmingham, AL, or Strongsville, OH. You will build and operate an enterprise‑scale, high‑volume transactional database that supports all lending payment transactions end‑to‑end. Your design, build, and maintenance work will focus on highly available, performant, and secure data stores and data movement patterns across MySQL and Oracle platforms, partnering closely with application engineering, SRE/operations, and security teams.

• 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, runbook‑driven execution).
• Design and support replication/data movement strategies for resiliency and 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.
• Collaborate with application teams on schema evolution, release coordination, and safe migration approaches (including MySQL Oracle considerations).
• Produce durable documentation: architecture diagrams, decision records, runbooks, and operational validation checklists.

• 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.
• 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.
• Oracle Data Guard experience.
• Oracle Golden Gate experience.
• Understanding of enterprise MySQL deployment/replication patterns.
• Ownership of significant database platform components with minimal guidance.
• Responsibility for technical work streams and driving them to closure.
• Improvement of runbooks/automation and contribution to production incident response.
• End‑to‑end ownership of database architecture for major programs.
• Establishment of engineering rigor and escalation for complex performance and replication decisions.
• Mentorship of engineers/DBAs and influence on roadmap decisions with measurable outcomes.

• Improved database performance and stability through measurable tuning and operational guardrails.
• Clear HA/DR posture with validated runbooks and repeatable failover readiness checks.
• Documented, scalable schema/partitioning/retention strategy for payment transactions.

BS in Computer Science, Engineering, or equivalent practical experience.

PNC offers a comprehensive range of benefits, including medical, prescription drug, dental, vision, life insurance, disability protection, 401(k) with match, pension, stock purchase plans, dependent care reimbursement, adoption and surrogacy assistance, educational assistance, wellness programs, and paid time off. Detailed information is available on

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law. This position is subject to federal regulations prohibiting hiring of individuals with certain criminal history.

Refer to the California Consumer Privacy Act Privacy Notice for disclosures related to hiring practices.