Our client is looking for Senior Oracle DB Developer
Description
As a Senior DB Developer (Oracle), you have the opportunity to collaborate on challenging projects both technically and functionally. The projects you will work on are crucial for the continuity and performance of our client's core business activities. These projects involve consolidating and distributing information related to railway traffic management (pre-processing, real-time, post-processing, back-office) to B2B stakeholders, namely:
Externally to our organization:
- To railway companies operating or transiting on our network.
- To foreign infrastructure managers.
- To European platforms for consolidating railway information, such as RailNetEurope.
Internally to our organization:
- Real-time visualization of schedule changes for our signal box staff.
- Calculation of fees and invoicing for the use of our network by our customers.
- Calculation of electricity consumption related to our activities.
- Feeding expert systems such as BigData.
You will work on both new developments and corrective and evolutionary maintenance of existing applications. As a highly technological company, we greatly appreciate and value your technical skills.
Tasks and responsibilities:
- Design and validate 3NF data models based on functional analysis.
- Design and validate data models according to the Data Vault model, Star Schema, or others based on functional analysis.
- Implement the data model and business logic in SQL and PL/SQL.
- Ensure code quality and promotion management across various environments (dev, test, acc, prod).
- Analyze and improve application/DB performance.
- Participate in peer reviews.
- Maintain documentation.
Technical skills
- Oracle DB development (L3: at least 5 years of experience)
- SQL & PL/SQL development (L3: at least 5 years of experience)
- Relational modeling via ERD and application of normalization principles (3NF) (L3: at least 5 years of experience)
- Database architecture design according to Data Vault and Star Schema models (L3: at least 5 years of experience)
- Use of GIT as Source Code Manager (SCM) (L3: at least 5 years of experience)
- Use of Scrum/Agile methodology (L3: at least 5 years of experience)
- Optimization of SQL & PL/SQL queries (L3: at least 5 years of experience)
- Use of Jira (L3: at least 5 years of experience)
- Management and validation of scripts in different environments (dev, test, acc, prod) (L3: at least 5 years of experience)
- General database management (security, tablespace, schema, …) (L2: at least 2 years of experience)
- Dutch or French (first language) (C2: highly complex mastery)
- Dutch or French (other than first language) (B1: intermediate level)
- English (B2: upper-intermediate level)
Soft skills
- Demonstrate knowledge of the company, the IT world, and understand the challenges of the requested role.
- Understand the company's mission and key activities.
- Show ability to integrate into the company teams, particularly through values such as kindness, courage, positivity, and reliability.
- Demonstrate skills inherent to the requested role within the ICT department, namely:
- Presentation skills
- Professional attitude
- Correctness and respect toward management
- Clear and effective communication
- Responsible commitment for the duration of the contract
Available for on-call duty
Yes
Desired frequency
1 week every 4 weeks
