Oracle DBA / UNIX Admin

Oracle DBA / Unix Administrator

£45,000 | Fully remote with very occasional trips to South Wales office.

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