ALIS Database Administrator, NAS Lemoore, CA

Job Details

Job Location:

F35 TSS LEMOORE - Lemoore, CA 93245

Position Type:
Full Time

Education Level: Bachelor's degree or Relative Exper

Travel Percentage:
Negligible

Job Shift: Any

The wage rate for this position is $85-$95/year.

The ALIS Database Administrator is responsible for ensuring the integrity of all databases within the ALIS 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). Performs database technical duties to include general backups, restore, updates, testing, debugging, integration and analysis. The specific duties include performing data transfers between operating units and other systems (internal and external) providing user access to data, keeping servers operational, configuring assets to support user needs, troubleshooting assets.

Monitors test progress, corrective actions, hardware/software baseline status, testing patches and an overall status of the system. Also, this candidate will serve as the point of contact for JSF Squadron discussion during flight and evaluation activities.

• Be certified in Security+
• Possess demonstrated database administration skills, to include:
  • Experience with importing large data volumes and managing large Oracle and SQL Server databases.
  • Execution and troubleshooting of database SQL scripts and report/correct finding and issues to the development team.
  • Create database backups for Disaster Recovery preparation and maintenance on the Oracle databases.
  • Develop 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.
  • Perform 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 tune utilizing SQL commands (without using Oracle Enterprise Manager).
  • Oracle Recovery Manager (RMAN) experience for backup and recovery to include hot and cold backups.
  • Understand 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.
• COTS/developed software skills.
• Software Engineering background and experience.
• Integration & Test experience.

• Experience with Microsoft Office including Word, Excel, Power Point, and Outlook.
• Experience in managing emails, calendars, and schedules for multiple leaders.
• Experience in travel planning and expense reconciliation.
• Experience in supporting multiple leaders within the same site or geographically.

• Recent successful administrative support experience.
• Excellent written/verbal communication skills.
• Strong organizational skills.
• Demonstrated effective customer service and teaming…