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
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
Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.
Oracle SQL Engineer employer: Onyx-Conseil
Onyx-Conseil is an excellent employer for those seeking a dynamic and rewarding career in infrastructure engineering. With a strong focus on employee development, the company offers numerous growth opportunities, a collaborative work culture, and the chance to work on impactful projects in secure environments. Located in Salford, employees benefit from a vibrant community and access to cutting-edge technology, making it an ideal place for professionals looking to enhance their skills and contribute to meaningful projects.
