Senior Oracle Expert

About the RoleAre you a skilled Oracle expert with developer mindset? Then you should join our Alliance Cloud team!
In this position, you will have the opportunity to collaborate with a multi-functional team, including business analysts, product managers, software engineers and test engineers where Oracle is used as a database for a Java application.
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.

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

Nice to have:

• Elastic Search
• Git
• Docker/Kubernetes
• Work experience in an Agile environment
• Oracle certifications (e.g., Oracle Certified Professional)

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.

If you are a hard-working Senior Oracle Expert looking for an exciting opportunity to contribute to challenging projects and improve your skills, we encourage you to apply! Join our team and be a part of our organization's growth and success.

What we offer

We put you in control of career

We give you a competitive package

We help you perform at your best

We help you make a difference

We give you the freedom to be yourself

We give you the freedom to be yourself. We are creating an environment of unique individuals – like you – with different perspectives on the financial industry and the world. An environment in which everyone’s voice counts and where you can reach your full potential regardless of age, background, culture, colour, disability, gender, nationality, race, religion, sexual orientation, or veteran/military status.