ORACLE DATABASE DEVELOPER

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