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.