Oracle Cloud Infrastructure (OCI) Migration Lead/Data Architect
Apetan Consulting LLC · Parsippany, NJ · 4 days ago
On-siteEngineeringFull-time
Key Responsibilities
- 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.
- 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.
Required Qualifications
- 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.