Senior Database Engineer

Union Bancaire Privée; Genf; Vor Ort; CHF 140.000 - 190.000; Vollzeit

Zusammenfassung

Union Bancaire Privée in Geneva seeks an experienced Database Engineer to modernize the bank’s data layer on Sybase ASE and Sybase IQ. You will optimize stored procedures, re-engineer UNIX ksh and SQL scripts, and ensure reliable ETL pipelines for operational and transactional data.

The role requires strong SQL, data modeling, and performance tuning, plus .NET/C# exposure and experience with Agile tools like JIRA/Confluence. Fluent English and French are expected, with Swiss residence.

Qualifikationen

• Experience with Sybase ASE/IQ and large analytical workloads.
• Proficient SQL including complex stored procedures and tuning.
• Strong data modeling for transactional and analytical data.
• Experience in UNIX shell scripting and batch processing.
• Familiarity with .NET/C# and modern development patterns.

Aufgaben

• Review data systems to identify improvements and optimization.
• Design, develop, and maintain stored procedures on Sybase ASE/Sybase IQ.
• Optimize database performance through indexing, partitioning, and query plans.
• Rewrite UNIX ksh and SQL scripts with modern structures and logging.
• Develop and manage on-premises applications using .NET and Angular.
• Build and support ETL/ELT workflows with data ingestion, validation, transformations, reconciliation, and scheduling.
• Ensure data quality and reliability for daily/weekly/monthly cycles with monitoring and alerts.
• Collaborate with Finance/Operations to translate requirements into robust solutions.
• Troubleshoot production incidents with root-cause analysis and SLAs.

Kenntnisse

SQL

Stored procedures

Data modeling

Troubleshooting

Analytical thinking

Tools

Sybase ASE

Sybase IQ

UNIX/Linux

ksh/bash scripting

.NET Framework/C#

GitHub Copilot

JIRA/Confluence

Angular

Control M

Jobbeschreibung

Mission

We are seeking a skilled and experienced Database Engineer to join our team in Geneva and modernize the bank’s data layer on Sybase ASE and Sybase IQ. The ideal candidate will manage and optimize complex stored procedures, re-engineer UNIX ksh and SQL scripts using modern patterns, and ensure reliable ETL pipelines for operational and transactional banking data.

Main responsibilities

• Review existing data systems and architectures to identify improvement and optimization
• Design, develop, and maintain complex stored procedures, functions, and packages on Sybase ASE Sybase IQ
• Optimize database performance: indexing, statistics, partitioning, query plans, parallelism, compression.
• Analyze existing UNIX ksh and SQL scripts; simplify and rewrite with modern structures, parameterization, error-handling, and logging.
• Develop & manage on-premises applications build on MS .Net & Angular Framework.
• Build and support ETL/ELT workflows: data ingestion, validation, transformations, reconciliation, and scheduling (e.g., Control M).
• Ensure data quality and reliability for daily/weekly/monthly cycles; implement monitoring, and alerts.
• Collaborate with Finance/Operations teams to translate requirements into robust database and batch solutions.
• Troubleshoot production incidents; perform root-cause analysis and preventative fixes while meeting the SLAs.

Technical skills

• Sybase ASE and Sybase IQ (8+ years hands-on)
  • Advanced SQL, stored procedures, performance tuning, query plan analysis.
  • Data modeling for large analytical/operational workloads.
• UNIX/Linux
  • Strong ksh/bash scripting, file handling, scheduling, permissions etc.
• Banking data
  • Solid understanding of operational/transactional and financial datasets and KPIs (balances, movements, fees, commissions, net interest margin)
• .NET Framework/C# exposure, experience applying GitHub Copilot for refactoring, app modernization.
• Agile delivery with JIRA/Confluence and GitHub

Your Profile

• Strong analytical and problem-solving skills
• Proactive in improving reliability, performance, and maintainability
• Ownership mindset with positive attitude -and Team player
• Excellent verbal and written communication skills - comfortable with business and IT stakeholders.

Languages

• English: Fluent
• French: Fluent
• Others
  • Swiss Residence

Core Competencies : Adherence to the company’s values: Dedication, Conviction, Agility and Responsibility - Compliance with regulations and internal directives