Description
We are IT Recruitment Specialists partnered with a prestigious Global Consultancy who required an Oracle DBA- Remote for one of their public sector Clients based in UK.
- IR35: This role is inside of IR35.
- Initial duration: 12 months
- Clearance required: Must be NVPP3 cleared.
Role and tasks
Job Description:
- Working with other DB Engineers and Consultants on enterprise solutions for our clients
- Cooperatio548.80n with other teams on various projects including cloud transformation.
- Hands on experience Oracle DBA activities,
- Experience in Oracle DB administration; monitoring & tuning DB performance,
- Experience with managing DB Access rights, schema objects (tables, indexes, and views).
- 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 anonymized data from production databases to staging/testing databases using various options eg, Oracle Data pump, Oracle streams, imp/exp, RMAN restore, bespoke scripts etc.
- Writing Shell script wrappers for Oracle jobs for various reasons eg, 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 eg, 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.
If you are interested in this position and would like to learn more, please send through your CV and we will get in touch with you as soon as possible. Please note, candidates are often Shortlisted within 48 hours.