Database-Oriented Analyst/Developer (Oracle) – Banking Sector (Consultant) in Genève

Database-Oriented Analyst/Developer (Oracle) – Banking Sector (Consultant) in Genève

Genève Vollzeit Vor Ort
Union Bancaire Privée

h3Mission /h3 ul liParticipate in workshops to capture functional/technical requirements and translate them into clear design documents for ODS changes and interfaces. /li liDesign, 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. /li liCreate and modify UNIX KornShell (ksh) scripts to orchestrate multi-timezone batch jobs and data workflows. /li liCoordinate delivery with onshore and offshore team members; align with architectural guidelines and interface contracts. /li liMaintain and improve existing database artifacts, ensuring performance, stability, and reliability in production. /li liCommunicate with adjacent systems across the bank’s information system to ensure end-to-end data consistency and integrity. /li liProvide technical support, troubleshoot incidents, perform root-cause analysis, and manage go-lives and production support. /li liLeverage AI tools to accelerate documentation, specification drafting, and knowledge sharing where appropriate. /li liDocument APIs/interfaces, runbooks, functional and technical specifications to build organizational knowledge. /li /ul h3Key Qualifications /h3 ul li7–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. /li liExpert PL/SQL skills, including performance tuning and robust error handling. /li liProficiency with UNIX scripting (KornShell ksh or similar) for operational automation and batch orchestration. /li liExperience eliciting requirements and producing functional and technical specifications aligned with architecture standards. /li liHands-on experience operating and supporting production data platforms (deployments, incident response, stability and performance improvements). /li liProven collaboration with business analysts, architects, and development teams across regions and time zones. /li liFamiliarity with multi-region, multi-timezone batch processing strategies in banking or similar regulated domains. /li liAbility to leverage AI as a productivity tool for documentation and development specifications. /li liStrong understanding of secure software and data handling practices in financial services. /li /ul h3Nice to Have /h3 ul liKnowledge of ODS design patterns and file and event-driven ingestion from core banking systems. /li liExposure to downstream integrations and additional RDBMS (e.g., Sybase IQ, MS SQL Server) through batches /li liExperience with CI/CD for database changes and schema versioning /li liFamiliarity with interface governance, API or messaging integration patterns. /li liExperience in large-scale banking transformation programs (multi-entity, multi-region). /li /ul h3Mindset Soft Skills /h3 ul liOwnership mentality with a bias for clear, pragmatic solutions under production constraints. /li liStrong problem-solving and analytical skills; ability to debug complex batch/data issues. /li liClear communication and effective collaboration with business, architecture, and development teams. /li liKnowledge-sharing mindset and commitment to high-quality documentation. /li liOrganized, detail-oriented, and dependable in production support contexts. /li /ul h3Our Tech Environment /h3 ul liDatabases: Oracle 19c+ (primary ODS), Sybase IQ (replicate). /li liScripting: UNIX KornShell (ksh) or similar. Acting as an interface with a scheduling software /li liData Domain: Operational Data Store fed by Core Banking events; gateway to Wealth Management and Operations applications. /li liProcesses: Requirements workshops; architectural governance; coordinated onshore/offshore delivery. /li liProductivity: AI-assisted documentation/specification workflows. /li liTooling Collaboration: Jira, Confluence, Git and CICD /li /ul h3Documentation Governance /h3 ul liDraft functional specifications validated with business and functional architecture. /li liDraft technical specifications validated with technical architecture and development teams. /li liMaintain runbooks, deployment guides, and knowledge base entries to support ongoing operations and onboarding. /li /ul h3What We Offer /h3 ul liOpportunity to contribute to a critical bank-wide transformation of the operational data platform. /li liCollaboration with business analysts, architects, and development teams across regions and time zones. /li liProfessional development and training support, including AI enablement. /li liStable environment with clear impact on core banking data flows. /li /ul h3Location /h3 ul liOffice location : Geneva /li liSwiss Residency: Mandatorybr/ /li /ul h3Core Competencies : Adherence to the company’s values: Dedication, Conviction, Agility and Responsibility - Compliance with regulations and internal directives /h3

Database-Oriented Analyst/Developer (Oracle) – Banking Sector (Consultant) in Genève Arbeitgeber: Union Bancaire Privée

UBP bietet eine herausragende Arbeitsumgebung, die von einer agilen Unternehmenskultur geprägt ist und Mitarbeiterinitiativen fördert. Als Senior Change Lead im Wealth Management haben Sie die Möglichkeit, bedeutende Veränderungen in einem dynamischen Team zu gestalten und Ihre Karriere durch gezielte Weiterbildungsangebote und ein starkes Netzwerk innerhalb der Organisation voranzutreiben. Zudem profitieren Sie von einem internationalen Arbeitsumfeld in der Schweiz, das Vielfalt und persönliche Entwicklung schätzt.

Union Bancaire Privée

Kontaktdaten:

Union Bancaire Privée Recruiting-Team