Product Features
Blog
Contact Us
Sign In
Optamor3
,
Marham, Norfolk
Oracle Database Administrator - Marham
|
|
Job Type: Full-time |
|---|
Overview
Lockheed Martin Rotary and Mission Systems Logistics and Training (RMS LT) entity provides a diverse range of products, services and capabilities. The Training product line ranges between CBT (Computer-based-training) through to high-fidelity, full-mission simulators for military and civilian domains. Lockheed Martin RMS LT currently have an opportunity for an Oracle Database Administrator to join an existing team based at RAF Marham. Th Database Administrator will be responsible for ensuring the integrity of all the databases within the system, and maintains the internal database of the system as well as the individual applications. Working closely with the System Administrator to carry out and sustain system-wide backups and restores, the DBA will provide maintenance of databases to include the following: backups, disaster recovery, database support (status checks, Oracle critical patch updates). Required skills, qualifications and experience Must be capable of obtaining a UK Developed Vetting Security Clearance Certified in Security 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. Demonstrated system administration skills, to include: Setting up configuring and troubleshooting all aspects that make up Storage Area Network (SAN) Fabric architecture (Zoning, logical unit number (LUN) Masking, and host bus adapter (HBA) Hardware. Setting up configuring and troubleshooting all aspects that make up Internet Protocol (IP) Switch Fabric architecture (Routing, Fail Over, etc), Working knowledge of Networked Attached Storage (NAS) and supported protocols. Engineering skills required for maintaining Enterprise Server Racks. Strong Working knowledge of SSL/VPN security architecture with integration into multi-layered Firewall architecture. Ability to work with EMC storage configuration tools (Navisphere, Visual SAN, Fabric Manager). Performing System Virtual Volume Imaging and Recovery, Disk to Disk/DR and Disk to Tape. Required skills, qualifications and experience Must be capable of obtaining a UK Developed Vetting Security Clearance Certified in Security 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. Demonstrated system administration skills, to include: Setting up configuring and troubleshooting all aspects that make up Storage Area Network (SAN) Fabric architecture (Zoning, logical unit number (LUN) Masking, and host bus adapter (HBA) Hardware. Setting up configuring and troubleshooting all aspects that make up Internet Protocol (IP) Switch Fabric architecture (Routing, Fail Over, etc), Working knowledge of Networked Attached Storage (NAS) and supported protocols. Engineering skills required for maintaining Enterprise Server Racks. Strong Working knowledge of SSL/VPN security architecture with integration into multi-layered Firewall architecture. Ability to work with EMC storage configuration tools (Navisphere, Visual SAN, Fabric Manager). Performing System Virtual Volume Imaging and Recovery, Disk to Disk/DR and Disk to Tape.