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 share your latest CV LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance. A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience. Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.
