Database-Oriented Analyst/Developer (Oracle) – Banking Sector (Consultant)

Union Bancaire Privée

Genf

On-site

CHF 120,000 - 190,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Union Bancaire Privée in Geneva seeks an experienced Oracle-focused analyst/developer to support production systems across core banking interfaces. You will design, implement, and optimize PL/SQL objects, automate batch workflows with ksh, and ensure secure data handling in a multi-region environment.

Collaborating with onshore and offshore teams, you will draft functional and technical specifications, maintain runbooks, and drive production readiness with robust observability and structured

Qualifications

  • 7–15 years of experience as an Oracle-focused analyst/developer in production environments.
  • At least 5 years of experience in the banking sector.
  • Expert PL/SQL skills with performance tuning and robust error handling.
  • Proficiency with UNIX scripting (KornShell) for automation.
  • Experience eliciting requirements and producing functional/technical specifications aligned with architecture.
  • Hands-on experience operating and supporting production data platforms (deployments, incident response, stability and performance enhancements).
  • Proven collaboration with business analysts, architects, and development teams across regions/time zones.
  • Familiarity with multi-region, multi-timezone batch processing in banking or 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 requirements and translate into design documents for ODS changes and interfaces.
  • Design, implement, and enhance Oracle PL/SQL objects (packages, procedures, views) with maintainability and observability in mind.
  • Create and modify UNIX KornShell scripts to orchestrate multi-timezone batch jobs and data workflows.
  • Coordinate delivery with onshore and offshore teams; align with architectural guidelines and interface contracts.
  • Maintain and improve existing database artifacts, ensuring performance, stability, and reliability in production.
  • Communicate with adjacent systems for end-to-end data consistency and integrity.
  • Provide technical support, troubleshoot incidents, and perform root-cause analysis for go-lives and production support.
  • Leverage AI tools to accelerate documentation, specification drafting, and knowledge sharing.
  • Document APIs/interfaces, runbooks, functional and technical specifications to build organizational knowledge.

Job description

Mission
  • 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 (clean modular design, clear naming, code reviews), robust observability (structured logging with audit trail in mind), and operability (standardized error handling and troubleshooting runbooks) to support reliable production operations.
  • 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.
Key Qualifications
  • 7–15 years of experience as an Oracle-focused analyst/developer supporting production systems in complex environments, including at least 5 years of experience in the banking sector.
  • 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.
Nice to Have
  • Knowledge of ODS design patterns and file and event-driven ingestion from core banking systems.
  • Exposure to downstream integrations and additional RDBMS (e.g., Sybase IQ, MS SQL Server) through batches
  • Experience with CI/CD for database changes and schema versioning
  • Familiarity with interface governance, API or messaging integration patterns.
  • Experience in large-scale banking transformation programs (multi-entity, multi-region).
Mindset & Soft Skills
  • Ownership mentality with a bias for clear, pragmatic solutions under production constraints.
  • Strong problem-solving and analytical skills; ability to debug complex batch/data issues.
  • Clear communication and effective collaboration with business, architecture, and development teams.
  • Knowledge-sharing mindset and commitment to high-quality documentation.
  • Organized, detail-oriented, and dependable in production support contexts.
Our Tech Environment
  • Databases: Oracle 19c+ (primary ODS), Sybase IQ (replicate).
  • Scripting: UNIX KornShell (ksh) or similar. Acting as an interface with a scheduling software
  • Data Domain: Operational Data Store fed by Core Banking events; gateway to Wealth Management and Operations applications.
  • Processes: Requirements workshops; architectural governance; coordinated onshore/offshore delivery.
  • Productivity: AI-assisted documentation/specification workflows.
  • Tooling & Collaboration: Jira, Confluence, Git and CICD
Documentation & Governance
  • Draft functional specifications validated with business and functional architecture.
  • Draft technical specifications validated with technical architecture and development teams.
  • Maintain runbooks, deployment guides, and knowledge base entries to support ongoing operations and onboarding.
What We Offer
  • Opportunity to contribute to a critical bank-wide transformation of the operational data platform.
  • Collaboration with business analysts, architects, and development teams across regions and time zones.
  • Professional development and training support, including AI enablement.
  • Stable environment with clear impact on core banking data flows.
Location
  • Office location : Geneva
  • Swiss Residency: Mandatory
Core Competencies : Adherence to the company’s values: Dedication, Conviction, Agility and Responsibility - Compliance with regulations and internal directives
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database-Oriented Analyst/Developer (Oracle) – Banking Sector
Database-Oriented Analyst/Developer (Oracle) – Banking Sector

Union Bancaire Privée • Genf

On-site
CHF 120,000 - 170,000
Oracle PL/SQL Engineer for Banking ODS & Batch
Oracle PL/SQL Engineer for Banking ODS & Batch

Union Bancaire Privée • Genf

On-site
CHF 120,000 - 190,000
Oracle PL/SQL Developer (f/m/x)
Oracle PL/SQL Developer (f/m/x)

IBM Suisse SA • Lancy

On-site
CHF 120,000 - 170,000
Senior Oracle Database Engineer (Database Operations)
Senior Oracle Database Engineer (Database Operations)

Avaloq1 • Bioggio

Hybrid
CHF 120,000 - 160,000
Hybrid & flexible working
Data Ops Engineer
Data Ops Engineer

EFG Private Banking • Genf

On-site
CHF 110,000 - 170,000
ODS Oracle PL/SQL Pro for Production & Batch Orchestration
ODS Oracle PL/SQL Pro for Production & Batch Orchestration

Union Bancaire Privée • Genf

Hybrid
CHF 120,000 - 170,000
Data Warehouse & Data Specialist
Data Warehouse & Data Specialist

Tech StaQ • Genf

On-site
CHF 110,000 - 140,000
Competitive benefits package
Ongoing training and certifications
Mentorship programs
+1
DBA team leader
DBA team leader

EFG Private Banking • Genf

On-site
CHF 170,000 - 250,000
Senior Oracle DBA
Senior Oracle DBA

TXT Group • Ticino

On-site
CHF 120,000 - 180,000
Anonymization Developer
Anonymization Developer

Union Bancaire Privée • Genf

On-site
CHF 140,000 - 180,000
Top locations