Oracle DBA / Unix Admin

IntaPeople; Cardiff; Hybrid; GBP 40,000 - 43,000; Full time

Job summary

IntaPeople is seeking an experienced Oracle DBA / Unix Administrator to join a busy team in a hybrid role. You will maintain critical Oracle databases on Unix/Linux, ensure availability, security and performance, and handle backups, recovery and patching.

You’ll work on monitoring, tuning, schema design support, and automation of routine tasks using Bash and batch scripting. 2–3 days in the office is expected.

Qualifications

• Solid commercial experience supporting enterprise Oracle databases (11g/19c+).
• Strong Unix/Linux administration skills.
• Experience with backups, recovery, patching and performance tuning.

Responsibilities

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

Skills

Oracle DBA experience

Unix/Linux administration

SQL/PLSQL

Performance tuning

Scripting Bash

Backup and recovery

SSH/SFTP

Tools

RMAN

Data Guard

RAC

ASM

TOAD

SQL Developer

DBeaver

Job description

Oracle DBA / Unix Administrator

£40,000 - £43,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.