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