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, and runbook-driven execution).
Design and support replication/data movement strategies as needed for resiliency and/or 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.
Work closely with application teams on schema evolution, release coordination, and safe migration approaches (including MySQL ↔ Oracle considerations).

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).
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) Oracle Exadata experience (engineering/tuning/operations on Exadata platforms).
(Preferred) Oracle Data Guard experience (HA/DR, role transitions, validation of primary/standby states).
(Preferred) Oracle Golden Gate experience (replication design/operations).
Understanding of enterprise MySQL deployment/replication patterns (e.g., primary/replica cross-site patterns).

Senior Data Engineer – OLTP, Data Guard, Golden Gate

Key skills