Oracle & Goldengate Dba: Build A Resilient Data Backbone

Oracle & Goldengate Dba: Build A Resilient Data Backbone
Viseu
Viseu, Viseu District, Portugal

At Hexa Consulting we want to spread transparency and enable diverse tech careers. Based in Portugal, we support the increasing demand in the IT sector.

Our mission is to build strong relationships, be a leading partner through a differentiated approach in IT consulting, and contribute to the professional and personal development of our team.

We work with Nearshore projects, TM & Project Development, Service & Service Management, and Tech Academies.

What are we looking for?

Oracle Database Administrator

We are looking for an Oracle DBA to lead the needs of a new highly demanding project. The person in this role will perform level three support to all databases and respective servers used by the

Custody department. Ensure best practices are in place from development to production. Constant

coordination and discussion within house or
- party developers for upcoming developments and ongoing improvement opportunities.

Responsibilities

• Gather and document technical requirements for system enhancements and updates.
• Drive the change request process for system updates, ensuring alignment with business and technical needs.
• Lead technical testing efforts to validate changes and ensure smooth production deployment.
• Own and execute assigned initiatives, from launch through to completion, while tracking progress.
• Monitor and adhere to project deadlines, proactively escalating risks or delays.
• Identify system gaps, inefficiencies, or weaknesses, and propose actionable improvements.
• Enforce and communicate project standards, ensuring consistency across deliverables.
• Prioritize and manage assigned projects independently, taking full ownership of tasks and outcomes.
• Liaise with stakeholders (e. G. , business teams, developers, vendors) and provide timely status updates.

Troubleshoot and resolve live system issues, including:

• Application performance bottlenecks;
  
  
  
  
• High memory/cpuutilization;
  
  
  
  
• Query andapplication tuning;
  
  
  
  
• Assess alternative solutions and workarounds to minimize operational impact during incidents;
  
  
  
  
• Provide Level 3support: Perform
  - cause analysis and implement permanent fixes for recurring issues;
  
  
  
  
• Track anddocument issue resolution progress, ensuring transparency and
  - up;
  
  
  
  

Monitor database infrastructure:

• Availability and disk space utilization (drives, file systems);
  
  
  
  
• Alert logs, backup logs, and network logs for anomalies;
  
  
  
  
• Support global teams (US, India, Portugal) by addressing
  - related inquiries and incidents;
  
  
  
  

Manage application databases, including:

• Software installation and patch management;
  
  
  
  
• Data import/export and ETL processes;
  
  
  
  
• Custom report development (ad-hoc or scheduled);
  
  
  
  

Perform routine DBA activities, such as:

• Backup/recovery management;
  
  
  
  
• User access andsecurity maintenance;
  
  
  
  
• Databasehealthchecks and proactive tuning.

Qualifications

- Thrive in a
- paced global environment, adapting to evolving priorities and
- functional

collaboration.

- 5+ years of professional experience as a Database Administrator (DBA), with
- on expertise in Oracle 12c/19c (required).

- Experience with other database systems (e. G. , Postgre
SQL, MS SQL) is a plus.

- Performance optimization skills: Proven ability in index tuning, query optimization, and

troubleshooting database performance issues.

- Database lifecycle management: Experience with data cleanup, historical data purging, and automation.

- Analytical and creative
- solving: Ability to assess change requests, issues, or challenges, propose solutions, and translate technical concepts into schematics, diagrams, or documentation for discussions and reporting.

- IT infrastructure involvement: Contribute to planning, sizing, and implementation of IT projects.

- Fluent in written and spoken English (required).