Ai & Analytics Database Administrator

A Mind Source; Viseu; Híbrido; EUR 55 000 - 75 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health and Life Insurance

Resumo da oferta

A Mind Source seeks a seasoned Oracle DBA to optimize performance, implement compression, tuning, and indexing strategies on ExaCC with a focus on CPU efficiency and cost reduction. You will guide best practices and collaborate with cross-functional teams.

The role includes Kerberos migrations, Oracle Client upgrades, and securing access management with TDE and auditing, while supporting multi-platform environments (Azure SQL, PostgreSQL, Synapse) where relevant.

Qualificações

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

Responsabilidades

• Optimize Oracle database performance through compression, query tuning and indexing.
• Fine-tune ExaCC CPU allocation algorithms to maximize used/allocated ratio.
• Optimize backup and recovery for Oracle ZFS and ZDLRA appliances.
• Lead migrations and Oracle Client upgrades; support Kerberos authentication.
• Guide development teams on database design, SQL coding, performance and scalability.
• Perform root cause analysis on performance incidents.
• Enforce access management, TDE encryption, auditing controls and audit-quality documentation.
• Collaborate across platforms and with infrastructure partners and stakeholders.

Conhecimentos

SQL scripting

Oracle performance tuning

Linux/Unix OS knowledge

Formação académica

Computer Science / Engineering degree

Ferramentas

Oracle SQL Developer

Toad for Oracle

Jenkins

UrbanCode Deploy

Qlik Replicate

Git/Bitbucket

ServiceNow

Jira

DBeaver

Oracle Certified Professional (OCP)

Descrição da oferta de emprego

• 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 OracleCPU 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 supportkey 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 withinfrastructure partners, development teams and project stakeholders across initiatives.

What You'll Do

• 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 OracleCPU 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 supportkey 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 withinfrastructure partners, development teams and project stakeholders across initiatives.

Qualifications

What You'll Need

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

Technical 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;
• Azure SQL or PostgreSQL, Azure Synapse or DB2 - knowledge is a plus;
• Tools : Oracle SQL Developer, Toad for Oracle,- Following Tools are a plus : Jenkins, UrbanCode Deploy, Qlik Replicate, Git / Bitbucket, ServiceNow, Jira, DBeaver;
• Oracle CertifiedProfessional (OCP) or equivalent certification is a plus.

Profile & Other Requirements

• 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;
• Experience in regulated environments (e.G., financial services) is a strong plus;
• Lisbon / Portugal-based - hybrid working model.

What can you expect from us?

Mind-blowing workplace culture. You will be integrated in a professional, dynamic and collaborative team.

100% Remote opportunities

We want you to have the flexibility to work where you feel most comfortable and productive.

International Career

• You can expect professional growth and to be connect with the world.- We are represented in Portugal, Belgium, Luxembourg, and Denmark.- And with projects in many other countries : Netherlands, Luxembourg, Singapore and in the United States of America (and a lot more is coming...)

If you wish to work with us and you are outside European Union (good news...) we are a Tech Visa Company, We will help!

As a plus, we provide Health and Life Insurance.

J-18808-Ljbffr