Join PNC’s Lending Tech as a Data Engineer building and operating enterprise-scale, high-volume transactional (OLTP) databases. You’ll help deliver secure, highly available data stores and data movement patterns that support lending payment transactions end-to-end, partnering closely with application engineering, SRE/operations, and security teams. This onsite role is located in Farmers Branch, TX.
You’ll be accountable for database architecture and implementation decisions that directly influence transaction integrity, latency, resiliency, and operational excellence across MySQL and Oracle.
What you’ll do
- Design and evolve an enterprise transactional data model for lending payment processing (OLTP), including schemas, constraints, indexing, 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, including validating operational readiness (failover/failback, replication health, and recovery objectives).
- Lead performance engineering: query tuning, execution plan analysis, index strategy, contention/locking analysis, and workload management.
- Implement automation for database operations, covering provisioning support, patch readiness support, backup validation, health checks, and runbook-driven execution.
- Design and support replication/data movement strategies for resiliency and cross-site requirements; preferred Oracle experience includes Golden Gate and Data Guard.
- Partner with security to enforce encryption in transit/at rest, least privilege, auditing, secrets management integration, and vulnerability remediation.
- Work with application teams on schema evolution, release coordination, and safe migration approaches, including MySQL and Oracle considerations.
- Maintain durable documentation such as architecture diagrams, decision records, runbooks, and operational validation checklists.
Key skills and 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, including query tuning, indexing, partitioning, and execution plan analysis.
- Operational best practices experience: backup/restore validation, patch planning, monitoring/alerting, incident response, and runbooks.
- Ability to collaborate across engineering, operations, and security with clear, structured communication.
- BS in Computer Science, Engineering, or equivalent practical experience.
Additional responsibilities include working closely with users, developers, operations, and business partners to define data service requirements and develop the data preparation process, plus implementing data migration and transformation activities/processes to ensure accuracy and security of data solutions.
Technologies you’ll work with
- MySQL, Oracle, SQL, OLTP
- Golden Gate, Data Guard, Oracle Exadata
Benefits
- 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
- 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
- Role is incentive eligible; payment based upon company, business and/or individual performance
Compensation
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 payment based upon company, business and/or individual performance.
Application window
Generally expected to be posted for two business days from 04/22/2026, though it may be longer with business discretion.
