ORACLE DATABASE DEVELOPER
Leonteq AG · Ausland · 100%
Automatisch bewerben · Originalinserat beim Unternehmen
About the Role
- As a Senior Oracle Database Developer, you will play a key role in the design, development, and optimization of our Oracle-based data warehouses and reporting solutions.
- You will collaborate closely with business stakeholders and technical teams to deliver robust and scalable systems that support mission-critical financial and regulatory processes.
What You'll Do
- Contribute to the design and development of a Data Warehouse based on Oracle Database 19c Enterprise Edition
- Develop scalable, efficient, and maintainable PL/SQL code for data movement, transformation, and reporting
- Implement complex reporting solutions in areas such as Risk, Finance, and Regulatory reports
- Collaborate with business users to understand requirements, workflows, and data needs
- Refactor and enhance legacy systems to improve reliability, performance, and maintainability
- Write clean, reliable code following Leonteq’s best practices and development standards
- Optimize SQL and PL/SQL code, leveraging advanced Oracle features like parallel queries, compression and advanced analytics using techniques such as AWM
- Tune database/query performance using tools such as AWM and Real-Time SQL Monitoring
- Support data modeling activities using techniques such as Kimball, Data Vault, or 3NF
- Work in an agile, collaborative environment, contributing to design reviews and monitoring.
What You'll Need
- 5+ years of experience in Oracle SQL and PL/SQL development
- Strong understanding of data modeling for data warehouses, including dimensional modeling, data warehousing best techniques and normalization techniques
- Deep knowledge of advanced SQL concepts, including analytical functions, hierarchical queries, complex joins, partitioning, and parallel execution
- Hands-on experience in performance tuning and troubleshooting using Oracle diagnostic tools and profiling (e.g., ASH, AWR)
- Strong problem-solving skills with the ability to develop creative and scalable solutions
- Proactive and independent working style with high attention to detail
- Fluency in English with excellent communication and collaboration skills
- Solution-driven mindset and interest in investment
Nice to Have
- Experience in the financial or insurance industry
- Proficiency in Python programming language
- Working knowledge of Git version control systems
Why You'll Love Working Here
- Experience the dynamics of a leading fintech company
- Be part of a multinational team / department spread across different locations
- Work in modern facilities at an exceptional location
- Hybrid working system: home office and office
Über Leonteq AG
Leonteq ist ein Schweizer Fintech-Unternehmen mit Fokus auf strukturierte Produkte.
Es wurde 2007 gegründet und hat seinen Hauptsitz in Zürich.
Das Unternehmen bietet Anlagelösungen und Technologieplattformen für Finanzinstitute.
Leonteq ist an der Schweizer Börse SIX Swiss Exchange kotiert.