Senior Oracle Database Developer

Full Time 29 July - 2025 4:44 pm
PDF
Employment Information
Updated
29 Jul-2025
Experience
Any
Level
Any
Profession
Developer
Type
Full Time
Salary
To be defined
Locations
Description

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 company’s 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 modeling 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 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.
  • 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 web-applications using Oracle Application Express considered a plus.
  • Solution-driven mindset and interest in investment banking and derivative financial products.

About the company:

Our client is fintech company with a leading marketplace for structured investment solutions.

Your recruiter:

Aline, Senior Talent Acquisition Specialist @ Effitalents.

Feel free to contact her for more information!

Evaluate

Promote

Create your own combination of services

Communicate

Create your own combination of services