Sme (subject matter expert) oracle

Entreprise

P&L Entreprises is a morrocan company, located in Casablanca, specialized in information technology. Our company is looking for and selecting candidates specialized in Oracle, Azure Cloud… to work offshore from Morocco for the European market. The company intends to hire expert profiles who can be the key figure in satisfying European clients needs.

Poste

Nature & Scope:

Responsible for installing, configuring, administering, maintaining and managing the global Oracle RDBMS infrastructure within the UCB company on Linux environments. Assists in the design, planning and implementation of the Global Oracle RDBMS environment and develop and maintain configurations, deployment and maintenance utilities, documentation, procedures and practices.

Develop procedures required to maintain and support group and sites needs and ensure this documentation is accurately maintained. Assist with defining and maintaining capacity and disaster recovery plans and facilities for this environment. Expected to assist with group projects, and is responsible for efficient, accurate execution of goals in accordance with quality metrics, target dates and budgets. Exhibit a high degree of technical competence in Oracle RDBMS environments.

Profil

Major Accountabilities:

Coordinates and administers Oracle RDBMS installations, configurations, troubleshooting and maintenance on Linux OS.
Assists with development of Oracle RDBMS deployment, support and maintenance procedures on Linux OS.
Troubleshoots and resolves complicated issues within within the server operating system, the Oracle RDBMS, applications, affiliated software (ex: backup) and Data Center Infrastructure environement. Support the 3 level escalation support as required.
Assists with assessing and implementing vendor supplied upgrades, patches and virus updates as related to Oracle RDBMS environment.
Work and partner with internal and external contractors and support personnel to ensure proper transitioning and on-going support of operational tasks
Incident management. Ensure that all calls are resolved within defined SLAs and all calls to be correctly allocated or escalated in line with defined escalation procedures.
Assist project and architecture teams to understand Oracle RDBMS and server requirements and define appropriate hardware and software configurations in line with the UCB Data Center and Server standards
Utilization and maintenance of software tools to monitor and manage Oracle RDBMS systems, capacity and performance.
Performs system testing and associated regulatory validations of Oracle RDBSM environment
Stay aware of new technologies and maintain knowledge.
Suggest and help realisation of improvement and/or new implementation based on redesign, problem solving, new technologies or features to improve the Data Center and server team agility,performance and reliability

Experience:

5 years demonstrated work experience in Oracle RDBMS Environment.
Experience in regulated and process focused computing environment preferred
Experience in hardware (VMware) preferred

Core Oracle Database Skills

Database Administration

Deep understanding of Oracle database architecture, including memory structures, process architecture, and storage structures.
Proficient in Oracle Database versions from 11g upwards and their new features.
Advanced expertise in tablespaces, schema management, indexing strategies, and partitioning.
Experience with Oracle Advanced Compression, Partitioning.

Backup and Recovery

Expert knowledge of Oracle Recovery Manager (RMAN) for backup, restoration, and disaster recovery.
Proficient with Flashback Technologies (e.g., Flashback Query, Flashback Table).
Planning and implementing comprehensive backup strategies to meet RTO/RPO requirements.

Performance Tuning

Expertise in SQL tuning, execution plans, and analyzing performance bottlenecks.
Skilled with Oracle performance tools: AWR (Automatic Workload Repository), ASH (Active Session History), and ADDM (Automatic Database Diagnostic Monitor).
Proficient in optimizing database storage, indexing, and caching mechanisms.

High Availability and Scalability

Experience with Oracle Data Guard and Active Data Guard for disaster recovery and high availability.

Security Management :

Proficient in implementing database security policies, including user roles, privileges, and profiles.

Database Migration and Upgrades

Expertise in performing in-place and out-of-place upgrades while minimizing downtime.

Oracle Ecosystem Tools

Proficient with Oracle Enterprise Manager (OEM) for monitoring and performance tuning.
Skilled in Oracle SQL Developer
Must work well in a team-orientated, highly dynamic environment
Possess strong diagnostic and analytical skills, with a proactive, detail-oriented focus
Ability to effectively communicate with internal and external customers and vendors
Able to effectively communicate both written and verbal in English and French
Customer service focused

Problem Solving

When a critical problem occurs, very quickly be able:

1. Capture relevant data

2. Understand impact and effect

3. Communicate to relevant personnel

4. Develop plan of action to include contingency planning

5. Escalate the problem as required

6. Follow-up and keep the impacted user base informed

7. Document incident report and review with team to ensure root cause correction and any additional preventive maintenance activities/base operation tasks required

Language