Data Engineer - Oracle, MySQL, OLTP

Enterprise-scale data platforms for lending payments are at the center of PNC’s Lending Tech organization. In this onsite Data Engineering role, you’ll design, build, and operate highly available, performant, and secure OLTP databases and data movement patterns on MySQL and Oracle, supporting transactional journeys end-to-end.

Based in Farmers Branch, TX, you’ll be accountable for database architecture and implementation decisions that impact transaction integrity, latency, resiliency, and operational excellence. The work is grounded in reliability and engineering rigor, with documentation, automation, and validated operational readiness forming core expectations.

Responsibilities

• Design and evolve an enterprise transactional (OLTP) data model for lending payment processing, including schemas, constraints, indexing strategies, partitioning, and retention or archival patterns.
• Define database standards to improve reliability, scalability, performance, and resiliency across MySQL and Oracle.
• Implement and operate high availability and disaster recovery patterns, validating operational readiness through failover or failback checks, replication health, and recovery objectives.
• Drive performance engineering through query tuning, index strategy refinement, execution plan analysis, and contention or locking investigation, plus workload management.
• Implement automation for database operations such as provisioning support, patch readiness support, backup validation, health checks, and runbook-driven execution.
• Design and support replication and data movement strategies as needed for resiliency or cross-site requirements (preferred Oracle skills include Golden Gate and Data Guard).
• Partner with security to enforce encryption in transit and 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 to Oracle considerations.
• Create durable documentation including architecture diagrams, decision records, runbooks, and operational validation checklists.

Requirements

• 3+ years of 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).
• Operational best practices experience including backup and restore validation, patch planning, monitoring and alerting, incident response, and runbooks.
• Proven ability to collaborate across engineering, operations, and security with clear, structured communication.
• BS in Computer Science, Engineering, or equivalent practical experience.
• Ability to work with users, developers, operations, and business partners to define data service requirements and support the data preparation process development.
• Experience implementing data migration and transformation activities to ensure accuracy and security.

Preferred Qualifications (Oracle Focus)

• Oracle Exadata experience (engineering, tuning, or operations).
• Oracle Data Guard experience (HA/DR, role transitions, validation of primary or standby states).
• Oracle Golden Gate experience (replication design and operations).
• Understanding of enterprise MySQL deployment and replication patterns (for example, primary or replica cross-site patterns).
• Experience owning significant components of the database platform with minimal guidance and driving technical workstreams to closure.
• Experience improving runbooks and automation, and contributing to production incident response and prevention.
• Ownership mindset for end-to-end database architecture (transaction store modernization, MySQL to Oracle strategy, or multi-site replication and DR patterns).
• Ability to set standards and act as an escalation point for complex performance and replication or DR tradeoffs.
• Experience mentoring engineers or DBAs, aligning across teams, and influencing roadmap decisions with measurable operational outcomes.
• Experience establishing engineering rigor through design reviews, operational readiness gates, and evidence-based performance validation.

Tools & Technologies

• MySQL, Oracle, SQL, OLTP, Golden Gate, Data Guard, Oracle Exadata

Benefits

• Medical and prescription drug coverage (with a Health Savings Account feature)
• Dental and vision options
• Employee and spouse or 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 or elder care
• Adoption, surrogacy, and doula reimbursement
• Educational assistance, including select programs fully paid
• Robust wellness program with financial incentives
• Maternity and/or parental leave
• Up to 11 paid holidays each year
• 9 occasional absence days each year, unless otherwise required by law
• 15 to 25 vacation days each year depending on career level
• Incentive eligible role with payment based on company, business, and or individual performance

Compensation & Location

Base salary: $42,000.00 – $172,250.00 per year. Salaries may vary based on geographic location, market data, and individual skills, experience, and education. The role is incentive eligible with the payment based upon company, business and/or individual performance.

Location: Farmers Branch, TX (onsite)

What success looks like (first 6–12 months)

• Improved database performance and stability through measurable tuning and operational guardrails (reduced latency, fewer recurring incidents).
• A clear HA/DR posture supported by validated runbooks and repeatable failover readiness checks.
• A documented, scalable strategy for schema, partitioning, and retention for payment transactions that supports volume growth sustainably.

Position Overview

As a Data Engineer in PNC’s Lending Tech organization, you’ll design, build, and maintain highly available, performant, and secure data stores and data movement patterns across MySQL and Oracle. You’ll work closely with application engineering, SRE or operations, and security teams, contributing to database architecture and implementation decisions tied to transaction integrity and operational excellence.

Education

Bachelors

Application Window

Generally expected to be posted for two business days from 04/22/2026, though it may be longer with business discretion.