Oracle DBA / Unix Administrator

IntaPeople IT Recruitment

Cardiff, UK

3 days ago

Apply on jobs.intapeople.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Compensation

£40,000.0 - £43,000.0

Working hours

Regular working hours

Job source

jobs.intapeople.com

Tech stack

Secure Shell (SSH) IBM AIX Public-Key Cryptography User Authentication Bash Shell Unix Databases Oracle Data Guard Linux Oracle Databases Oracle (Applications) PuTTY

+14 more

Red Hat Enterprise Linux Recovery Manager (RMAN) Solaris (Operating System) PL-SQL SQL Databases Telnet Oracle Linux Batch Scripting Scripting File Transfer Protocol (FTP) Database Performance Toad (Software) ZFS File System Database Tools and Utilities

Job description

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., * 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

Requirements

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.