For a global customer in Walloon Brabant, I am searching for a freelance Oracle Engineer responsible for installing, configuring, administering, maintaining and managing the global Oracle RDBMS infrastructure within the company on Linux environments.
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 the server operating system, the Oracle RDBMS, applications, affiliated software (ex: backup) and Data Center Infrastructure environment. 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 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
Scope:
* Assist 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.
Experience
* 5 years demonstrated work experience in Oracle RDBMS Environment.
* Experience in regulated and process focused computing environment preferred
* Experience in Hardware (VMware) preferred
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:
* Capture relevant data
* Understand impact and effect
* Communicate to relevant personnel
* Develop plan of action to include contingency planning
* Escalate the problem as required
* Follow-up and keep the impacted user base informed
* Document incident report and review with team to ensure root cause correction and any additional preventive maintenance activities/base operation tasks required
Additional details
Seniority: Medior/Senior
Start Date: May
Duration: 12 Months
Extension: Yes
Contract: Freelance
Location: Walloon Brabant
Onsite Policy: Flexible
Hours Per Week: 40
Languages: Fluent English
Interview Process: 1-2 stages