Oracle Database Administrator

IntaPeople: STEM Recruitment; Cardiff; Hybrid; GBP 40,000 - 45,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

IntaPeople: STEM Recruitment is seeking an experienced Oracle DBA / Unix Administrator in the Cardiff area. You will support enterprise Oracle databases and the Unix/Linux infrastructure, ensuring availability, security and performance while handling backups, patching and recovery.

The role is hybrid (2–3 days in the office) with a mix of hands-on database and operating system tasks, SQL/PLSQL tuning, and collaboration with developers on schema design.

Qualifications

• Solid commercial experience supporting enterprise Oracle databases.
• Oracle 11g, 19c or newer preferred.
• Strong Unix/Linux administration skills.

Responsibilities

• Carry out daily checks across databases, backups, filesystems and tablespaces; identify errors and capacity issues.
• Investigate failed services and other database or system issues.
• Manage Oracle backups and recovery using RMAN.
• Perform expdp/impdp schema refreshes; full and data-only refreshes.
• Monitor and tune database performance (SQL, long-running processes, SGA/PGA).
• Install, patch and upgrade Oracle database software and tools.
• Manage database users, roles, privileges and security policies.
• Support database deployments; collaborate with developers on schema design and troubleshooting.
• Maintain Unix/Linux environments alongside Oracle database estate.
• Automate routine tasks using Bash scripting and Windows batch scripting.

Skills

Oracle DBA experience

Unix/Linux administration

SQL/PLSQL

Education

Oracle OCP or similar certification

Tools

RMAN

Data Guard

RAC

ASM

TOAD

SQL Developer

DBeaver

SSH

PuTTY/Plink

Bash scripting

Job description

£40,000 - £45,000 | Hybrid role 2-3 days p/week in the office ideally

We're working exclusively with a long standing client of ours who has just started looking for an experienced Oracle DBA / Unix Administrator due to increased workload and client wins.

You'll join an established technical team, supporting customer Oracle database environments and the underlying Unix/Linux infrastructure.You'll be responsible for keeping critical databases available, secure and performing well, as well as dealing with day-to-day issues, backups, recovery, patching and performance.

What you'll be doing

• Carrying out daily checks across databases, backups, filesystems and tablespaces, identifying errors and capacity issues
• Investigating failed services, runaway processes and other database or system issues
• Managing Oracle backups and recovery using RMAN
• Performing expdp/impdp schema refreshes, including full and data-only refreshes
• Monitoring and tuning database performance, including SQL, long-running processes and SGA/PGA
• Installing, patching and upgrading Oracle database software and associated tools
• Managing database users, roles, privileges and security policies
• Supporting database deployments and working with developers on schema design and troubleshooting
• Maintaining and supporting Unix/Linux environments alongside the Oracle database estate
• Automating routine tasks using Bash/Unix scripting and Windows batch scripting

What we're looking for

You'll need solid commercial experience supporting enterprise Oracle databases, ideally Oracle 11g, 19c or newer, combined with strong Unix/Linux administration skills.

Key technical experience includes:

• Strong Oracle DBA experience, including SQL and PL/SQL
• Oracle internal packages, including XDBADMIN
• RMAN backup and recovery
• Experience with Data Guard, RAC and ASM
• Knowledge of Dbvisit would be useful
• Strong Linux/Unix skills, ideally Red Hat, Oracle Enterprise Linux, AIX or Solaris
• Good understanding of Unix filesystems including ext3, ext4 and ZFS
• Logical volumes, mounting and SMB
• SSH, SFTP and Telnet
• SSH key generation and public key authentication
• Bash Shell scripting, including tools such as expect
• Windows batch scripting and PuTTY/Plink
• Experience with tools such as TOAD, SQL Developer or DBeaver

An Oracle OCP or similar database certification would be beneficial, although relevant commercial experience is more important.

This would suit someone who enjoys being hands-on with both Oracle databases and Unix/Linux environments, rather than a DBA role focused purely on database administration.