Open roleExternal

Oracle SQL Engineer

Job Description

Role Title: SQL - Oracle Database Administrator

Location: Manchester / Barrow - 3 days onsite/week

Duration: 6 initial months contract

Rate INSIDE IR35 MARKET RATE

SC Cleared

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.

Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.

#J-18808-Ljbffr