DBAs are expected to perform data management, maintain and perform backup/restore/disaster recovery plans and processes, and provide database/application support. This section further expands the general definition of DBAs into specific tasks that are common across the various sites to support the ALOU, CPE, and SOU
The ability to obtain and maintain an active secret clearance with an investigation completed in the last 6 years is required. A Security+ certification (or equivalent-GSEC, CAP, CASP, CISM, CISSP, CISA, etc.) is required within 60 days of starting a position.
Junior-Senior level opportunities available, salary ranges are based on education/certifications and years of experience.
All positions require standard business travel usually once every 6 months for 1-3 weeks to other US base locations.
* denotes locations that require overseas travel every 1.5 years for 3-6 months
The DBA works with other administrators at the same site and at other sites to provide and ensure complete oversight of the databases, network, and system. Both the Network Administrator and System Administrator rely upon the DBA in performing their tasks. The DBA provides inputs to the Network Administrator in determining the optimal time or period for the Network Administrator to perform network configuration changes in an effort to reduce the impacts to end users. The DBA assists the System Administrator in the backup / restore / disaster recovery planning through the system wide backup and restore process and by retaining essential data for future recovery. Finally, the DBA coordinates with Fort Worth DBAs to receive data downloads.
- Maintain, store, and manage data including: Air Vehicle (AV) and configuration, F-35 Fleet Management, Computerized Maintenance Management System (CMMS), reliability and maintainability (R&M), and Supply Chain Management (SCM) data.
- Maintain Commercial-off-the-Shelf (COTS), Government Off-The-Shelf (GOTS) and Custom Applications providing data interchange.
- Manage classified and sensitive data elements (including cryptographic key management) in accordance with program security policy.
- Support troubleshooting of data problems and reconcile data anomalies.
- Execute processes and procedures for Data Management (DM) library.
- Support DM controls for the
- Identify and mitigate DM Risk level.
- Backup/Restore/Disaster Recovery
- Run application for System settings and Registry backups.
- Coordinate with the System Administrator to schedule local drive imaging to run on periodic intervals.
- Perform backup to backup any live data directories on regular intervals.
- Monitor and verify scheduled database backups of Oracle and MS SQL and ensure data is stored on tape on a regular basis such that data is fully recoverable in the event of data loss or corruption.
- Perform appropriate procedures to perform recovery of
- Install Joint-Service Technical Data (JTD) on the appropriate units at the site (task shared with System Administrator).
- Perform “as required” manual adjustments to any database on the
- Configure applications, including but not limited to Failure Reporting, Analysis and Corrective Action System (FRACAS), CMMS, with the appropriate Commercial And Government Entity (CAGE) codes and part numbers.
- Create user accounts as required.
- Utilize CMMS-2 utilities to evaluate and scope errors, if any, before performing data import.
- Support software release activities
- Support implementation activities at site (e.g. standup of SOU at a site). Database
- Administrators are responsible for DTRs to include SPIRs, MEFLs, NFLs, SDB, SBD,AFRS DB updates, etc.
Database Administrators (DBAs) develop and execute policies, practices and procedures that properly manage the full data lifecycle needs of . The DBAs are primarily concerned with ensuring data availability to users and the protection of that data from loss. DBA tasks include but are not limited to: data protection, availability, distribution, migration, warehousing, management, replication, redundancy, and security.
Skills & Knowledge Set
The DBA requires a particular set of skills and knowledge to adequately perform database administration, including data protection. While some of these skills and knowledge set may already exist in the designated administrator, these skills are typically developed through a training curriculum or by On-The-Job Training (OJT).
Tools & Applications
- Oracle Relational Database Management System (RDBMS)
- Oracle Export, Import, and Data Pump
- Oracle Recovery Manager (RMAN)
- Procedural Language/Structured Query Language (PL/SQL)
- Oracle SQLPlus
- Microsoft (MS) SQL Server
- Windows Server 2012
- Oracle Performance Tuning
- Oracle Administration
- Operating Systems (OSs)
- Scripting Languages (shell, batch, Practical Extraction and Report Language (PERL))
- Oracle Administration in an MS Windows environment
- Oracle DBA
- Windows Systems Administrator
- OMS/JMPS Systems Administrator
- Cisco Network Administrator
- Security Analyst
- Oracle Certified Associated (OCA)
- Oracle Certified Professional (OCP) Certification
- Security+ Certification with Continuing Education (CE)