Oracle DBA

Job Summary
Together with the Oracle DB team, your responsibilities are

• You do all actions that are necessary to keep the environment up and running (daily checks, proactive actions in case of technical changes in datacenter, …)
• Follow up security recommendations (proactively and reactively) and minimize the operational risk
• You help the concerned teams with their operational issues : performance investigations, database stability, ...
• You are responsible to maintain all oracle frameworks developed by KBC. Those frameworks are used to perform oracle management and are written in Perl.
• You work in the ecosystem of KBC, which means you have to deal with all systems interfacing with the Oracle database (Centrify, UAC, Cyberark, VMWare, …)
• You are, together with the team, responsible for the life cycle management of the Oracle products. For the Oracle server package this includes : building, testing, rollout (using Bladelogic), communications, follow up Oracle version updates. For the end point packages this means describing the requirements to the end point packaging team, testing and following up package version updates.
• You are responsible for the backups and recovery of all data on the Oracle servers managed by the team
• You participate in projects, on technical or application level. We work in a SAFe (scaled agile framework) context , the changes are planned during PI planning. For projects on application level, you provide the necessary expert knowledge to the application team. This can include : best practices to configure the oracle system, support in the queries provided by the application team
• You are responsible for all actions necessary to perform capacity management.
• You help the application teams with their performance issues. This may include : investigate performance issues, propose concrete actions to the application teams, support the team to build performant queries, ..
• You participate in the DRP exercises and do the necessary actions as required by the general DRP scenario.
• Follow up the market and evolutions of the Oracle Databases, together with the System Architect and Product Owner

Key Responsibilities
Together with the Oracle DB team, your responsibilities are

• You do all actions that are necessary to keep the environment up and running (daily checks, proactive actions in case of technical changes in datacenter, …)
• Follow up security recommendations (proactively and reactively) and minimize the operational risk
• You help the concerned teams with their operational issues : performance investigations, database stability, ...
• You are responsible to maintain all oracle frameworks developed by KBC. Those frameworks are used to perform oracle management and are written in Perl.
• You work in the ecosystem of KBC, which means you have to deal with all systems interfacing with the Oracle database (Centrify, UAC, Cyberark, VMWare, …)
• You are, together with the team, responsible for the life cycle management of the Oracle products. For the Oracle server package this includes : building, testing, rollout (using Bladelogic), communications, follow up Oracle version updates. For the end point packages this means describing the requirements to the end point packaging team, testing and following up package version updates.
• You are responsible for the backups and recovery of all data on the Oracle servers managed by the team
• You participate in projects, on technical or application level. We work in a SAFe (scaled agile framework) context , the changes are planned during PI planning. For projects on application level, you provide the necessary expert knowledge to the application team. This can include : best practices to configure the oracle system, support in the queries provided by the application team
• You are responsible for all actions necessary to perform capacity management.
• You help the application teams with their performance issues. This may include : investigate performance issues, propose concrete actions to the application teams, support the team to build performant queries, ..
• You participate in the DRP exercises and do the necessary actions as required by the general DRP scenario.
• Follow up the market and evolutions of the Oracle Databases, together with the System Architect and Product Owner

Essential Skills

• Necessary technical knowledge/experience
• Sound knowledge of Oracle
• Active Perl knowledge : the ability to read, understand and debug existing code as well as write new code.
• Experience with performance troubleshooting

Knowledge of the following components

• RMAN
• OEM
• OUD
• Dataguard
• SQL Plus
• ODBC JDBC
• SQL Developer
• Toad

You have some experience in

• Linux (working knowledge)

It is added value when you have knowledge of the following products

• UAC
• Bladelogic

Qualifications:
Your skills

• You are able to work in a large environment where procedures and processes are important
• You have the analytical skills to investigate new/unknown issues and to pinpoint the root cause, also if this is outside the oracle area
• You are able to work in a multidisciplinary team where you offer your oracle expertise
• You are assertive, convincing and diplomatic at the same time
• You have strong organizational and self-management skills
• You can work under pressure as you are working with operational systems
• You are a team player but also able to work independently
• You have excellent communication skills and are able to communicate with a broad range of stakeholders : service delivery owner, other system engineers, product owner, management, …
• You are able to work in an operational environment with shifting priorities
• You are able to work under pressure
• You have a critical mindset and are able to discuss pros and cons of decisions to the stakeholders You are able to work in a SAFe context
• You are security minded
• You are prepared to work outside business hours
• You have the ability to build up a network at KBC and use it