Senior Oracle Application Database Administrator

Hexa Consulting; Lisboa; Hybrid; EUR 70,000 - 90,000; Full time

Job summary

Hexa Consulting in Lisbon is seeking a senior Oracle DBA to optimize performance and efficiency across ExaCC, ZFS, and ZDLRA environments. The role emphasizes specialist expertise, collaboration with development and infrastructure teams, and contribution to multi-platform environments.

The candidate should bring 5–10 years of production Oracle experience, strong tuning skills, and Linux/Unix proficiency, with a hybrid Lisbon-based work model in Portugal.

Qualifications

• University degree in Computer Science, Engineering or comparable technical field.
• 5-10 years of hands-on Oracle database experience in production environments.
• Proven expertise in performance tuning, compression and resource optimization.
• Experience with ExaCC, ZFS and ZDLRA is a strong plus.
• Linux/Unix experience is primary; Windows experience is a plus.

Responsibilities

• Optimize Oracle database performance through compression techniques, query tuning and indexing strategy; focus on ExaCC CPU efficiency, storage cost reduction and I/O efficiency.
• Fine-tune Oracle CPU allocation algorithms on ExaCC to maximize used/allocated ratio and minimize waste.
• Optimize backup and recovery processes for Oracle ZFS and ZDLRA appliances, ensuring reliability and cost-effectiveness.
• Lead and support key projects, including migration to Kerberos authentication and Oracle Client upgrades.
• Guide development teams on best practices for database design, SQL coding, performance and scalability.
• Perform root cause analysis on performance incidents and complex database issues escalated from infrastructure partners.
• Enforce access management, TDE encryption, auditing controls and audit-quality documentation.
• Contribute to multi-platform environments (Azure SQL, PostgreSQL, Synapse) where relevant.
• Collaborate with infrastructure partners, development teams and project stakeholders across initiatives.

Skills

Performance tuning

Cross-team collaboration

Problem solving

English language proficiency (C1)

Linux/Unix proficiency

Education

University degree in Computer Science, Engineering or comparable technical field

Tools

ExaCC

ZFS

ZDLRA

Oracle RAC

RMAN

OEM (Oracle Enterprise Manager)

Oracle SQL Developer

Toad for Oracle

Kerberos authentication

Job description

We are searching for candidates for a senior Oracle DBA role focused on performance optimization, resource efficiency and project delivery across Oracle ExaCC (Exadata Cloud@Customer), ZFS and ZDLRA environments. Day-to-day operational coverage is handled in partnership with infrastructure teams; this role focuses on specialist expertise, continuous improvement and cross-team collaboration with development and infrastructure stakeholders.

About the Role

This senior Oracle DBA role is focused on performance optimization, resource efficiency and project delivery across Oracle ExaCC (Exadata Cloud@Customer), ZFS and ZDLRA environments, with an emphasis on specialist expertise, continuous improvement and cross-team collaboration with development and infrastructure stakeholders.

Responsibilities

• Optimize Oracle database performance through compression techniques, query tuning and indexing strategy — with a focus on ExaCC CPU efficiency, storage cost reduction and I/O efficiency;
• Fine-tune Oracle CPU allocation algorithms on ExaCC to maximize the used/allocated ratio and minimize waste;
• Optimize backup and recovery processes for Oracle ZFS and ZDLRA appliances, ensuring reliability and cost-effectiveness;
• Lead and support key projects, including migration to Kerberos authentication and Oracle Client upgrades;
• Guide development teams on best practices for database design, SQL coding, performance and scalability;
• Perform root cause analysis on performance incidents and complex database issues escalated from infrastructure partners;
• Enforce access management, TDE encryption, auditing controls and audit-quality documentation;
• Contribute to multi-platform environments (Azure SQL, PostgreSQL, Synapse) where relevant;
• Collaborate with infrastructure partners, development teams and project stakeholders across initiatives.

Qualifications

• University degree in Computer Science, Engineering or comparable technical field;
• 5-10 years of hands-on experience with Oracle databases in production environments;
• Proven expertise in performance tuning, compression and resource optimization;
• Hands-on experience with ExaCC, ZFS and ZDLRA is a strong plus;
• OS knowledge: Linux and/or Unix (primary), Windows (secondary).

Required Skills

• Oracle RAC, Data Guard, RMAN, Oracle Enterprise Manager (OEM); SQL and PL/SQL scripting (must);
• ExaCC CPU optimization, compression techniques, query tuning, Exadata awareness;
• Kerberos authentication and Oracle Client upgrades;
• Tools: Oracle SQL Developer, Toad for Oracle,
• Professional English C1 (spoken and written) — mandatory;
• Strong collaboration skills — comfortable working with infrastructure partners, development teams and non-technical stakeholders;
• Structured problem-solving mindset; ability to communicate technical findings clearly;
• Generalizing-specialist profile — open to working across multiple database technologies;
• Must own a valid work permit or EU/Schengen Space nationality to legally work in Portugal;
• Lisbon/Portugal-based — hybrid working model.

Preferred Skills

• Following Tools are a plus: Jenkins, UrbanCode Deploy, Qlik Replicate, Git/Bitbucket, ServiceNow, Jira, DBeaver;
• Azure SQL or PostgreSQL, Azure Synapse or DB2 — knowledge is a plus;
• Oracle Certified Professional (OCP) or equivalent certification is a plus.
• Experience in regulated environments (e.g., financial services) is a strong plus;