Oracle Database Administrator (Junior/Mid)

For our client, we are looking for candidate for the position: 

Oracle DB Engineer 

---

Engagement terms:

Area: Consulting IT

Localisation: 100% remote

Start: ASAP (max 1 month notice period)

Rate (budget): 80 - 90 PLN net / h

Conditions: B2B (outsourcing via NEXT), full-time, long-term (12+ month)

Scope of duties

• Provide technical expertise on Oracle Database
• Ability to drive architecture design on customer projects and act as a trusted advisor on Oracle Database to deliver highly available and secured database environments
• Install, patch, upgrade and maintain all Oracle Database and Enterprise Management software
• Migrate form Oracle 12c to 19c
• Implement backup & recovery strategy
• Help customer on benchmark to identify bottlenecks, and provide guidance on tuning and optimization of Oracle Database
• Be able to write accurate and concise technical documentation
• Ensure availability and quality of data by maintaining and improving performances (tuning) and features (by enhancing their automation, optimizing treatments and requests, the configuration...)
• Follow performance statistics of access to database objects to ensure the tuning
• Management of volume increase on data access
• Administrate user access rights as well as data security issues with security engineer
• Manage version upgrade
• Update programs, fix potential bugs (install patches) and give go before deployment in production
• Advise on back-up procedures to realize by exploitation teams to ensure integrity of data from all bases, especially archiving and data purge
• Define quality standards and set-up related follow-up dashboards
• Ensure follow-up of monitoring tools and study all issues to qualify their gravity and origin(s)
• Elaborate and execute test procedures and programs, after migrations or following an incident
• Ensure that safeguards are properly executed (by doing tests in a back-up repository) and control data updates
• Ensure the data recovery and the operational restoration of databases following a critical incident

We expect

• Good knowledge of Oracle 12c,19c or later
• Basic networking knowledge
• Basic knowledge of PL/SQL and shell scripting
• Strong problem solving and analytical capabilities
• Fluent in English (B2+)

Nice to have:

• Unix/Linux operating systems knowledge
• Working knowledge of Oracle Grid Control
• Working knowledge of Oracle Cloud Control
• Knowledge of Oracle Database auditing
• Basic knowledge of Python scripting