Data Engineer - Oracle, MySQL, OLTP

PNC Financial Services Group; Farmers Branch (TX); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) with match

Paid time off

Educational assistance

Job summary

PNC is seeking a Data Engineer to focus on building and operating high-volume transactional databases to support lending payment processes. This role includes responsibilities like database design and operational excellence, ensuring reliability and performance in a collaborative work environment.

Applicants should have strong SQL skills and experience with MySQL and Oracle. The position offers a diverse set of benefits and is set in an inclusive workplace culture.

Qualifications

• Experience with high-volume databases handling mission-critical transactions.
• Strong SQL and performance tuning expertise with MySQL and Oracle.
• Knowledge of operational practices including backup/restore validation and incident response.

Responsibilities

• Design and evolve transactional data models for lending payment processing.
• Define database standards for reliability and performance.
• Implement high-availability and disaster-recovery patterns.

Skills

Strong hands-on experience designing and operating high-volume, enterprise OLTP databases

Advanced SQL and performance tuning experience across MySQL and Oracle

Operational best practices knowledge

Collaboration across engineering, operations, and security

Education

BS in Computer Science, Engineering, or equivalent practical experience

Tools

MySQL

Oracle

Oracle Exadata

Oracle Data Guard

Oracle Golden Gate

Job description

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.

Job Profile

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.

Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications (Oracle focus)

• 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 workstreams 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.

What Success Looks Like (first 6‑12 months)

• 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.

Education

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

Benefits

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 pncthrive.com.

Equal Employment Opportunity (EEO)

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.

Equal Opportunity and Non‑Discrimination Statement for California Residents

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