Job Description
Sr. Data Architect / Oracle Cloud Infrastructure (OCI) Migration Lead
Location: Parsippany, NJ (On-site)
Position Overview
We are seeking a highly experienced Sr. 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.
The ideal candidate will work closely with the technology team, providing strategic direction while actively resolving complex technical challenges, accelerating migration efforts, and establishing best practices for future-state architecture.
Key Responsibilities
Technical Strategy & Architecture
•Conduct a comprehensive assessment of the current Oracle Cloud Infrastructure (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 Oracle Cloud Infrastructure 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, 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.
Required Qualifications
•8-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.
Preferred 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.
Key Competencies
•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