Oracle Data Migration Lead
Core
Lead large-scale, complex data transformation and end-to-end data migration initiatives from legacy Oracle databases to a target state solution, ensuring seamless, secure, and accurate transfer of critical enterprise data.
Role type
Senior Oracle Data Engineering Lead
Builds
Scalable, high-performance data pipelines and migrated enterprise data systems
Domain
Enterprise Data Engineering / Oracle Database / Cloud Infrastructure
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Oracle Database architecture (12c, 19c, 23c), Oracle Exadata, Oracle Cloud Infrastructure (OCI), Oracle Data Integrator (ODI), Oracle GoldenGate, advanced SQL, PL/SQL, relational and dimensional data modeling, large-scale enterprise data migration leadership, database performance optimization
Preferred skills
OCI Certifications, Python, shell scripting, Agile/Scrum delivery methodologies, 4gl/coolgen technologies
Technologies
Oracle Database, Oracle Exadata, OCI, ODI, GoldenGate, AWS
Responsibilities
Define and execute comprehensive data migration strategies from legacy databases; Lead and mentor a team of data engineers; Architect and build scalable data pipelines using ODI and GoldenGate; Establish rigorous data validation and cleansing processes; Troubleshoot and optimize complex SQL queries and database performance; Partner with enterprise architects and business stakeholders to align technical deliverables; Ensure adherence to industry compliance standards and data privacy regulations; Maintain detailed documentation of model development processes.
Seniority
Senior, hands-on IC with leadership responsibilities