Senior Oracle PL/SQL Engineer for ODS Data Ops

UBP - Union Bancaire Privée; Genf; Vor Ort; CHF 120.000 - 180.000; Vollzeit

Zusammenfassung

UBP - Union Bancaire Privée in Geneva seeks an experienced Oracle PL/SQL analyst/developer to design, implement, and optimize ODS interfaces and batch processes across Core Banking systems.

You will operate in a multi-region, multi-timezone environment, focusing on maintainability, observability, and robust production support, with AI-assisted documentation and strong collaboration across onshore and offshore teams.

Qualifikationen

• 7–15 years of Oracle-focused analyst/developer experience in production environments.
• Strong PL/SQL skills with emphasis on performance tuning and error handling.
• Proficient in UNIX scripting (KornShell) for automation and batch orchestration.
• Experience eliciting requirements and drafting functional/technical specs.
• Experience supporting production data platforms and incident management.

Aufgaben

• Participate in workshops to capture requirements and translate into design docs.
• Design, implement, and enhance Oracle PL/SQL objects across ODS and interfaces.
• Create and modify UNIX ksh scripts for multi-timezone batch jobs.
• Coordinate delivery with onshore/offshore teams and ensure interface contracts.
• Maintain and improve database artifacts for performance and reliability.
• Provide technical support, troubleshoot incidents, and manage go-lives.
• Leverage AI tools to accelerate documentation and knowledge sharing.
• Document APIs/interfaces, runbooks, and technical specifications.

Kenntnisse

Oracle PL/SQL

Performance tuning

UNIX KornShell scripting

Requirements elicitation

Production support

Batch processing

AI-assisted documentation

Cross-region collaboration

Tools

Jira

Confluence

Git

CI/CD

Jobbeschreibung

UBP - Union Bancaire Privée in Geneva seeks an experienced Oracle PL/SQL analyst/developer to design, implement, and optimize ODS interfaces and batch processes across Core Banking systems.

You will operate in a multi-region, multi-timezone environment, focusing on maintainability, observability, and robust production support, with AI-assisted documentation and strong collaboration across onshore and offshore teams.