Oracle Database Administrator

Recruiter
aap3
Location
Staffordshire
Salary
Competitive
Posted
10 Aug 2017
Closes
15 Aug 2017
Job Type
Administrator
Contract Type
Permanent
Database Administrator - Security Cleared aap3 are working with a leading global defence sector technology organisation on the recruitment of a number of key IT roles as part of an exciting new Programme within the UK Defence sector. So if you fancy being part of an expanding team that will form the technical backbone of this Programme, have a sense of adventure and want to be part of a new venture please apply. Database Administrator responsible for ensuring the integrity of all the databases within the system. The Database Administrator maintains the internal database of the system as well as the individual applications. The Database Administrator works closely with the System Administrator to carry out and sustain system-wide backups and restores. The Database Administrator will provide maintenance of databases to include the following: backups, disaster recovery, database support (status checks, Oracle critical patch updates). Demonstrated database administration skills, to include: Experience with importing large data volumes and managing large Oracle and SQLServer databases, be able to execute and troubleshoot database SQL scripts and report/correct finding and issues to the development team. Database backups for Disaster Recovery preparation and maintenance on the Oracle databases. Scripts to perform Level 0 and delta (Level 1) backups, full logical export of all database data that collects snapshots of parameter files and checks database for logical and physical corruption Database restoration for disaster recovery from most current backups Status check scripts to troubleshoot database issues by pulling status of every database on the server, status of the database listener, and provide database system file tampering notification Manually install Oracle Critical Patch Updates Reviewing V$ tables and DBA views for any issues that may arise Locate user session data via the command line Performance tuning utilizing SQL commands (without using Oracle Enterprise Manager) Oracle Recovery Manager (RMAN) experience for backup and recovery to include hot and cold backups. Understanding of SQL/PL-SQL language and be able to execute. Due to the security requirements of the roles applicants will ideally need to hold DV level MOD clearance currently. Candidates with SC level clearance in place and eligibility for DV level clearance may be considered but time constraints for start of the project may be restrictive for the initial roles. These roles by nature will involve some global travel and some flexibility on thepart of employees. For more information on both contract and permanent roles via aap3, industry news and updates, check out our brand new website, follow our aap3 Recruitment page on Linkedin and follow us on