Senior Oracle Expert

SWIFT

Brussels, Belgium

The Senior Oracle Expert position requires crafting, developing, maintaining and deploying Oracle database solutions in Production.

The ideal candidate should have a solid background in Oracle database administration and SQL tuning. Attention to detail, problem-solving skills, and being able to work fast-paced, Agile environment are essential for success in this role.

Responsibilities:

Provide expertise around Oracle-related code, to ensure consistency with accepted coding standards and effective approaches.
Conduct detailed testing and debugging of Oracle applications to identify and resolve defects.
Collaborate with business analysts and software engineers to analyse user requirements and translate them into technical specifications.
Optimize application SQL queries to extract and manipulate data efficiently.
Perform database performance tuning and optimization to ensure efficient query execution and data retrieval in a distributed architecture.
Ensure data integrity and security by implementing accurate data validation and access controls.
Implement changes in Production (requires physical presence in the office at least 2 days/week).
Collaborate with database administrators to supervise and maintain the health and performance of Oracle databases.
Analyse and understand impact of Oracle database patches and upgrades on the projects databases and act as Oracle domain expert.
Stay up to date with the latest Oracle technologies, tools, and trends to suggest improvements and drive innovation in database development.

Requirements:

Bachelor's degree in computer science, Information Systems, or a related field (or equivalent work experience).
Demonstrable experience as an Oracle Expert or similar role, with a solid grasp of Oracle database concepts, architecture, and data modelling.
Knowledge of performance tuning tools & techniques to optimize database queries and operations e.g. Explain Plan, Autotrace, AWR.
Familiarity with Oracle tools and technologies, such as Oracle Enterprise Manager, SQL Developer, DataPump, Oracle Text.
Ability to work both independently and collaborate in a team environment.
Great communication skills to optimally interact with multi-functional teams and stakeholders, across all levels.
Able to work in a fast-paced environment and handle various tasks simultaneously.

Must haves:

Proficiency in SQL programming and database design principles.
Proficiency in Oracle performance tuning.
Experience with Oracle Partitioning feature.
Experience with Oracle security like Database Vault and data encryption.
Familiar with Java related development and ability to work with Java developers.