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

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

Data Engineer – Oracle, MySQL, OLTP

Key skills