Oracle Database Administrator

Oracle Database Administrator - Location: Manchester or Barrow in Furness - 3 days onsite/week - 6 initial months contract

This temporary contract is inside IR35 and will require working under the direction of the client delivery manager as part of a multi-disciplinary team. The successful candidate will follow established delivery processes and working practices.

This role requires the successful candidate to undergo and be eligible for UK Security Vetting at SC level.

More details relating to UK Security Clearance can be found here:

United Kingdom Security Vetting: clearance levels - GOV.UK

Role Description:

* Focusing on scalability, integrity, performance, availability, security, monitoring and troubleshooting of core DB clusters
* Owning core database clusters in Production as well as on a wide range of technologies
* Reporting into the Operations Manager and working alongside the Senior DBA
* Oracle schema object sizing.
* Monitor data block organisation.
* Monitor physical storage and contention.
* Monitor tablespace utilization
* Memory usage.
* Physical I/O tuning.
* Lock monitoring.
* Database resource utilization.
* Alert log, Backup status
* Database free space.
* Performance tuning ratios
* Check Invalid objects
* Monitor build-up of trace files.
* Monitor growth of alert logs.
* Purge log and trace files, which are no longer required.
* Database Monitoring
* Cache (Buffer Cache, Library Cache, Dictionary Cache) hit/miss ratios
* Point in time database recovery, using on-line redo logs.
* Provide advice during database restoration following a crash or media failure.
* Monitor Archive log retention period for database recoverability and highlight issues/limitations.
* Ensure database changes are reflected into the backup strategy.

Your skills and experience:

* Shared pool usage
* Customized DBMS_JOBS running
* Logical I/O on the database
* SAR on the database server
* Locks on the database
* Sessions and session queries
* Monitor database availability issues
* Monitor on-line and archived log file usage
* Monitor roll-back segment usage
* EARS call handling for Oracle DBA team
* Change handling for Oracle DBA team
* Participate in implementation planning
* Export & Import data between production and test instances as required

Oracle Database Administrator - Location: Manchester or Barrow in Furness - 3 days onsite/week - 6 initial months contract

Damia Group Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept our Data Protection Policy which can be found on our website.

Please note that no terminology in this advert is intended to discriminate on the grounds of a person's gender, marital status, race, religion, colour, age, disability or sexual orientation. Every candidate will be assessed only in accordance with their merits, qualifications and ability to perform the duties of the job.

Should the role require the successful candidate to undergo and be eligible for UK Security Vetting. Clearance sponsorship will be provided where required. Due to the nature of the work, candidates should meet the relevant residency requirements. If applicable, Reserved Post nationality restrictions will be confirmed by the client. Damia is committed to inclusive recruitment and welcomes applicants from all backgrounds.

Damia Group is acting as an Employment Business in relation to this vacancy and in accordance to Conduct Regulations 2003.