Hiring: Data Engineer - Oracle, MySQL, OLTP Company: PNC Location: Pittsburgh, PA Job Posted Time: 2026-09-16 16:05:50 Employment Type: Full-time Target Skills & Keywords : Encryption, Machine Learning, MySQL, REST, Risk Management, SQL, Workday About the job Experience: •Salaries may vary based on geographic location, market data and on individual skills, experience, and education. This role is incentive eligible with the payment based upon company, business and/or individual performance. •Generally, this opening is expected to be posted for two business days from 04/22/2026, although it may be longer with business discretion. Required Skills: •Be accountable for database architecture and implementation decisions that directly impact transaction integrity, latency, resiliency, and operational excellence. •Architecture & Design •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. •Build & Operate (Production Ownership) •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). 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 (query tuning, indexing, partitioning, execution plan analysis). •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). •Owns significant components of the database platform (specific schemas/domains, key performance areas, or HA/DR operational ownership) with minimal guidance. •Lead and oversee technical workstreams (e.g., partitioning rollout, performance remediation, operational readiness) and drives them to closure. •Improves runbooks/automation; contributes to production incident response and prevention. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!