DBA Oracle 19c

Project overview

Context

Our client is looking for a Senior Oracle DBA with at least 8 years of experience for a long-term mission, starting as soon as possible.

The consultant will work transversally with three Agile teams using packaged software. They will play a central role in optimizing databases, reducing CPU consumption, and preparing for a major migration of the Oracle environment.

Your missions

Technical skills

Mandatory:

Migration-related skills:

**Profile sought

You have at least 8 years of experience and possess confirmed expertise as a Study Oracle DBA.

You have previously worked directly on optimizing and tuning SQL queries from packaged software, regardless of the specific software.

The position requires a transversal profile, capable of working with multiple teams and Product Owners, responding to user requests, and collaborating effectively in an Agile organization.

An ability to occasionally work outside of business hours for certain deployments is also expected.

• Study and define the upgrade method from Oracle 19c to Oracle 26ai.
• Participate in the migration of databases to Oracle 26ai on OCI/DBSystem.
• Optimize and perform tuning of Oracle databases.
• Analyze, improve, and optimize SQL queries from packaged software.
• Monitor and reduce database CPU consumption in a FinOps approach.
• Ensure database deployments.
• Guarantee the reliability of SQL deliverables.
• Respond to user requests.
• Handle production incidents in collaboration with the database administration team.
• Act as the point of contact between project teams, Oracle DBAs, and the software vendor.
• Work in interaction with three Product Owners within Agile teams.
• Participate in BCP and DRP exercises.
• Occasionally participate in deployments outside of business hours.
• Oracle DBA expertise.
• Oracle 19c.
• Exadata / **.
• Multitenant.
• RAC.
• Data Guard.
• Proficiency in SQL.
• Experience in tuning and optimizing SQL queries.
• Experience optimizing queries from packaged software.
• Ability to analyze and reduce database CPU consumption.
• Experience with production environments and incident management.
• Experience working in an Agile environment.
• Oracle 26ai.
• OCI / DBSystem.
• Ability to study and prepare an Oracle 19c to Oracle 26ai migration.

Project details

• Start: ASAP
• Duration: 12 mois
• Location: 94700 MAISONS-ALFORT, FR
• Languages: French