ODS Oracle PL/SQL Pro for Production & Batch Orchestration

Union Bancaire Privée; Genf; Hybrid; CHF 120,000 - 170,000; Full time

Job summary

Union Bancaire Privée in Geneva is seeking a seasoned Oracle PL/SQL analyst to design, implement and optimize database objects across the ODS and core banking interfaces. You will maintain production systems, perform root-cause analysis, and collaborate with onshore/offshore teams to ensure data integrity and reliable operations.

Responsibilities include requirements capture, creating design and technical specifications, developing batch automation scripts, and leveraging AI tools to accelerate

Qualifications

• 7–15 years of experience as an Oracle-focused analyst/developer supporting production systems in complex environments.
• Expert PL/SQL skills, including performance tuning and robust error handling.
• Proficiency with UNIX scripting (KornShell ksh or similar) for operational automation and batch orchestration.
• Experience eliciting requirements and producing functional and technical specifications aligned with architecture standards.
• Hands-on experience operating and supporting production data platforms (deployments, incident response, stability and performance improvements).
• Proven collaboration with business analysts, architects, and development teams across regions and time zones.
• Familiarity with multi-region, multi-timezone batch processing strategies in banking or similar regulated domains.
• Ability to leverage AI as a productivity tool for documentation and development specifications.
• Strong understanding of secure software and data handling practices in financial services.

Responsibilities

• Participate in workshops to capture functional/technical requirements and translate them into clear design documents for ODS changes and interfaces.
• Design, implement, and enhance Oracle PL/SQL objects (packages, procedures, views) within the ODS and across upstream (Core Banking) and downstream client application interfaces, emphasizing maintainability, observability, and operability.
• Create and modify UNIX KornShell (ksh) scripts to orchestrate multi-timezone batch jobs and data workflows.
• Coordinate delivery with onshore and offshore team members; align with architectural guidelines and interface contracts.
• Maintain and improve existing database artifacts, ensuring performance, stability, and reliability in production.
• Communicate with adjacent systems across the bank’s information system to ensure end-to-end data consistency and integrity.
• Provide technical support, troubleshoot incidents, perform root-cause analysis, and manage go-lives and production support.
• Leverage AI tools to accelerate documentation, specification drafting, and knowledge sharing where appropriate.
• Document APIs/interfaces, runbooks, functional and technical specifications to build organizational knowledge.

Skills

Oracle PL/SQL

UNIX scripting

Requirements elicitation

Production support

Cross-region collaboration

Banking domain knowledge

AI for documentation

Observability / logging

Tools

Jira

Confluence

Git

CI/CD

Job description

Union Bancaire Privée in Geneva is seeking a seasoned Oracle PL/SQL analyst to design, implement and optimize database objects across the ODS and core banking interfaces. You will maintain production systems, perform root-cause analysis, and collaborate with onshore/offshore teams to ensure data integrity and reliable operations.

Responsibilities include requirements capture, creating design and technical specifications, developing batch automation scripts, and leveraging AI tools to accelerate