Oracle Dba
3 months ago
Woking, Surrey, United Kingdom
Venn Group
Full time
Our client, a global technology organisation, urgently require an experienced Oracle DBA to undertake a long term contract.In order to be successful, you will have the following experience:
- Extensive Oracle Database Administration experience
- Monitoring and tuning DB performance
- Technical skills with: SQL, PL/SQL, Python, Shell
Within this role, you will be responsible for:
- Working with DB Engineers and Consultants on enterprise solutions for our clients
- Installation and management of Oracle database software, both RAC and single instance options (when necessary, this may involve patching of O/S software (RedHat, Solaris etc) to the required level that's compatible with the Oracle version
- Installation and management of Oracle Automatic Storage Management (ASM) instances for efficient storage management
- Installation configuration and management of Oracle Data Guard for efficient failovers
- Implementing a resilient backup strategy with Oracle RMAN, ensuring backups are run regularly, occasionally doing test database restores
- Upgrade of Oracle software to ensure systems are not running on unsupported versions of Oracle
- Execute failover from primary to DR databases if the need arises
- Uploading anonymised data from production databases to staging/testing databases using various options e.g. Oracle Data pump, Oracle streams, imp/exp, RMAN restore, bespoke scripts etc
- Writing shell script wrappers for Oracle jobs for various reasons e.g. so they can be executed from Unix crontab
- Performance monitoring and tuning of Oracle databases
- Monitoring of OS components that may impact the performance of the Oracle database e.g. host memory usage (RAM), CPU usage, disk and network performances
- Implement automation and development projects if the need arises using SQL, PL/SQL, Python and Shell scripts