Senior Oracle Database Administrator

PROJECT DESCRIPTION:

Work model: Hybrid (2 days/week form office Warsaw)

Assignment type: B2B

Start: ASAP

Project length: long term

Rate: 175 pln/h net + vat

Project language: English

Industry: Banking

The Senior DBA will be responsible for managing Oracle-based applications, ensuring continuous service and integrity through implementation, testing, troubleshooting, and support for critical databases.

RESPONSIBILITIES:

• Prepare the prePROD environment for enabling FSFO.

• Sync the DataGuard in case of issues or errors.

• Rebuild the Standby as needed.

• Create DB service and validate PDB-level services.

• Create a new database and migrate old PDB to a new container.

• Activate FSFO and troubleshoot related issues.

• Perform tests on prePROD, including switchover and failover.

• Apply DB-level patching.

• Execute changes related to OS (Unix processes, load management, daemon) as needed.

• Handle RAC issues with disaster recovery.

• Set up OGG Microservices and OEM.

• Implement changes in production.

MUST HAVE:

• 10+ years of managing Oracle Database versions 12c to 19c (RAC, Data Guard).

• Operating system experience in Linux.

• Proficiency with Oracle management tools (Data Guard, RMAN, Data Pump).

• Understanding of architecture design principles.

• Strong problem-solving skills and ability to work independently and in a team.

• Experience with creating PDB services and handling Data Guard issues.

• Strong practical experience in a production RAC (ASM) environment (19c).

• Self-starter with attention to detail.

• Knowledge of Oracle GoldenGate.

• Understanding of storage systems.

• Knowledge on FSFO problem-solving, observers, and change/incident management processes.

• Experience with Oracle SR handling and OEM architecture.