Senior Oracle EBR Architect

DWI Consulting; Genf; Remote; CHF 140,000 - 190,000; Full time

Job summary

DWI Consulting seeks a Senior Oracle EBR Architect to design and implement an Edition-Based Redefinition (EBR) architecture for online deployments and upgrades with zero downtime, in a Switzerland-based project. Remote work is possible, with a 3–6 month horizon and start in Oct/Nov.

Ideal candidates bring strong Oracle EBR expertise, practical experience with Editioning Views and Crossedition Triggers, and a track record of managing live-data changes under deployment constraints, ready to

Qualifications

• Experience with Oracle EBR architecture and deployments.
• Familiarity with editioning views and crossedition triggers.
• Experience coordinating live-data changes with minimal downtime.

Responsibilities

• Design Oracle EBR architecture and articulate it to stakeholders.
• Work with Editioning Views, Crossedition Triggers, and live-data deployment processes.
• Address apply-step behavior, idempotency, and lifecycle constraints.
• Present and defend architectural decisions to senior Oracle architects.

Skills

Oracle EBR architecture

Editioning Views

Crossedition Triggers

Live-data deployment

Job description

Senior Oracle EBR Architect

Location: Switzerland (remote possible)
Duration: 3–6 months, with possible extensions
Start: October/November (subject to confirmation)

DWI Consulting is recruiting a Senior Oracle Architect to support online application deployments and upgrades involving changes to back-end database objects without application downtime.

Key responsibilities

• Design and articulate an Oracle Edition-Based Redefinition (EBR) architecture.
• Work with Editioning Views, Crossedition Triggers and live-data deployment processes.
• Address apply-step behaviour, idempotency and EBR lifecycle limitations.
• Present and defend architectural decisions to senior technical stakeholders.

What we are looking for

• Strong Oracle EBR architecture expertise and practical implementation experience.
• Detailed knowledge of Editioning Views and Crossedition Triggers.
• Experience managing live-data changes and EBR deployment constraints.
• Confidence discussing complex designs with senior Oracle architects.