Oracle Database Developer
Oracle Database Developer – Lisbon
Hybrid working – 2 days home office
As a Oracle Database Developer, you will play a key role in the design, development, and optimization of our Oracle-based data warehouse and reporting solutions. You will collaborate closely with business stakeholders and technical teams to deliver robust and scalable systems that
support
- critical financial and regulatory processes.
TASKS & RESPONSIBILITIES
- 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 reporting.
- Collaborate with business users to understand requirements, workflows, and data needs.
- Refactor and enhance legacy systems to improve scalability, performance, and maintainability.
- Write clean, reliable code following best practices and development standards.
- Optimize SQL and PL/SQL code, leveraging advanced Oracle features like parallel queries, partitioning, compression, and analytical functions.
- Tune database/query performance using tools such as ASH 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 mentoring junior developers.
REQUIREMENTS
- 5+ years of experience in Oracle SQL and PL/SQL development.
- Strong understanding of data modeling for data warehouses, including dimensional modelling 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 (e. g. , ASH, AWR).
- Strong
- 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.
- Experience in the financial or insurance industry is a strong advantage.
- Working knowledge of Git version control systems is a plus.
- Proficiency in Python programming language is a plus.
- Developing
- applications using Oracle Application Express considered a plus. - Solution-driven mindset and interest in investment banking and derivative financial products.
- Informações detalhadas sobre a oferta de emprego
Empresa: System Recruitment Specialists Localização: Lisboa
Lisboa, Lisboa, PortugalPublicado: 25. 7. 2025
Vaga de emprego atual
Seja o primeiro a candidar-se à vaga de emprego oferecida!