Senior Oracle Database Developer

Description

Job Summary: We are seeking an experienced Oracle developer to build and optimize a Data Warehouse, with a focus on PL/SQL, data modeling, and performance for financial and regulatory domains. Key Highlights: 1. Develop and optimize Oracle Data Warehouses. 2. Work with data modeling (Kimball, 3NF) and advanced SQL. 3. Focus on performance and collaboration in an agile environment. **Main Responsibilities** * **Develop a Data Warehouse** using Oracle Database 19c Enterprise Edition. * **Code in PL/SQL** for data movement, transformation, and reporting. * **Create complex reports** for areas such as Risk, Finance, and Regulatory. * **Collaborate with business users** to understand requirements and data flows. * **Modernize legacy systems** (refactoring for improved performance and scalability). * **Follow company development best practices** (clean, maintainable code). * **Optimize SQL and PL/SQL**, leveraging advanced features such as: + Parallelism + Partitioning + Compression + Analytic functions * **Analyze and improve performance** using tools such as ASH (Active Session History) and Real\-Time SQL Monitoring. * **Participate in data modeling**, using Kimball, Data Vault, or 3NF. * **Work in an agile manner**, participate in design reviews, and mentor other developers. **✅ Mandatory Requirements** * **Solid experience (5\+ years)** with Oracle SQL and PL/SQL. * **Knowledge of data modeling**, both dimensional (Kimball) and normalized (3NF). * **Proficiency in advanced SQL**: analytic functions, hierarchical queries, complex joins, etc. * **Experience with tuning and troubleshooting** using Oracle tools (e.g., AWR, ASH). * **Proactive and detail-oriented profile**, with strong English communication skills. **➕ Nice-to-Have (not mandatory, but valued)** * Experience in the **financial or insurance sector**. * Knowledge of **Git** (version control). * Ability to program in **Python**. * Experience with **Oracle APEX** (Oracle Application Express) for web applications. * Interest in **complex financial products** (e.g., derivatives). **What They Look for in Terms of Profile** * Someone **technically skilled and experienced**, yet capable of engaging with business stakeholders. * A **collaborative profile**, who enjoys working in an agile team. * Ability to **analyze complex problems** and design scalable solutions. * Interest (or background) in the **financial sector**, especially regulatory topics. **Conclusion** This position is ideal for someone with: * Solid experience in **Oracle (SQL and PL/SQL)**; * Experience in **Data Warehousing and data modeling**; * Skills to **optimize performance** and handle large volumes of data; * Interest or experience in the **financial/regulatory sector**.