Oracle Cloud Infrastructure (OCI) Migration Lead(Local Only)
Apetan Consulting LLC · Parsippany, NJ · 1 wk ago
On-siteInformation TechnologyFull-time
Position: Oracle Cloud Infrastructure (OCI) Migration Lead
Location: Parsippany, NJ (Hybrid)
Type: Contract
About the role
We are seeking a highly experienced Principal Data Architect / OCI Migration Lead to drive the successful execution of a large-scale data platform migration to Oracle Cloud Infrastructure (OCI). This is a hands-on technical leadership role requiring deep expertise in cloud data architectures, database migration, ETL/ELT optimization, and enterprise data engineering.
Responsibilities
- Technical Strategy & Architecture: Conduct a comprehensive assessment of the current OCI data environment to identify architectural gaps, migration bottlenecks, and performance constraints; define and implement target-state data architecture aligned with scalability, performance, security, and operational excellence; redesign data models, schemas, and pipeline architectures to improve efficiency, reduce latency, and enhance overall platform reliability; develop a phased, low-risk migration roadmap for the remaining workloads, ensuring minimal business disruption and predictable delivery.
- Hands-on Engineering & Technical Leadership: Troubleshoot and resolve complex issues involving data pipelines, database compatibility, synchronization failures, and cloud infrastructure; optimize SQL queries, ETL/ELT workflows, and data transformation processes within the OCI ecosystem; improve pipeline performance through automation, orchestration, and infrastructure optimization; design and implement automated monitoring, alerting, and observability capabilities to proactively detect failures and reduce operational risk; collaborate with engineering teams to establish coding standards, deployment practices, and operational best practices.
- On‑Site Collaboration & Delivery Execution: Work on‑site with the Data Engineering team in Parsippany, NJ, serving as the primary technical advisor during the migration program; lead daily technical triage sessions to resolve critical blockers, prioritize engineering efforts, and maintain delivery momentum; partner with architects, developers, infrastructure teams, and business stakeholders to ensure successful execution across workstreams; document architecture decisions, migration patterns, operational procedures, and technical standards to create a sustainable knowledge base for long‑term platform support.
Requirements
- 10+ years of experience in Data Engineering, Data Architecture, or Cloud Platform Engineering.
- Proven experience leading enterprise‑scale cloud migration initiatives, preferably involving Oracle Cloud Infrastructure (OCI).
- Strong expertise in Oracle databases, data modeling, SQL optimization, and database performance tuning.
- Extensive experience designing and optimizing ETL/ELT pipelines using modern data integration frameworks.
- Deep understanding of cloud‑native architecture, distributed data processing, and enterprise integration patterns.
- Experience implementing monitoring, observability, and operational automation for cloud‑based data platforms.
- Excellent troubleshooting and problem‑solving skills with the ability to resolve complex production issues.
- Strong communication and stakeholder management skills, with experience working directly with executive and engineering leadership.
Qualifications
- Oracle Cloud Infrastructure (OCI) certification(s).
- Experience with Oracle Autonomous Database, Oracle Data Integrator (ODI), Oracle GoldenGate, or Oracle Integration Cloud.
- Experience with modern data orchestration platforms such as Apache Airflow or similar workflow engines.
- Familiarity with DevOps practices, Infrastructure as Code (Terraform), CI/CD pipelines, and cloud automation.
- Experience working in highly regulated enterprise environments.
Skills
- Enterprise Data Architecture
- Oracle Cloud Infrastructure (OCI)
- Cloud Migration Strategy
- Database Performance Optimization
- ETL/ELT Engineering
- Data Pipeline Modernization
- Root Cause Analysis
- Technical Leadership
- Cross‑Functional Collaboration
- Documentation & Knowledge Transfer