The Database Specialist provides all activities related to the administration of computerized SQL and Oracle databases. Some specific examples follow:

• Performs the daily O&M activities required to ensure the availability of application databases in development and production instances. Run Contiguous Monitoring & Risk Scoring (CMRS) Asset Compliance Report for Authorization to Operate (ATO), Evaluation Verification Integration Facility (EVIF), and Intranet Services weekly. Remediate all findings for all assets.
• Maintain an Applications Data and System Backup and Restoration Procedures SOP ensuring that application, system, and environment changes are reflected in the SOP within 30 calendar days of the change. Ensure the availability of applications and databases restoration activities.
• Review the results of the weekly security scans of all DISA IT applications/assets that are provided by the Information Assurance Vulnerability Management scanning team. Remediate all critical and high findings and report these actions back to the Information Assurance (IA) scanning team for compliance validation.
• Create and manage user accounts to include performing account resets and assisting users with login information.
• Implement upgrades with government provided hardware and software. Support incident resolution efforts in conjunction with the hosting facility. Conduct hosting environment maintenance and upgrades during scheduled and unscheduled maintenance events.
• Develop/execute the migration of the OS from Solaris to Red Hat Linux. Build new Solaris and RHEL virtual systems. Update build procedures and images as needed for compliance with new security requirements.

Key Tasks and Responsibilities

• Able to communicate with management, technicians, and end-users to evaluate need prior to development of an automated solution.
• Prepares detailed reports which might include system requirements such as concurrent usage factors, data storage requirements, response rates, and discuss procedures for processing data through the use of data base management systems (DBMS) including relational data bases.
• Projects long-range requirements for database administration and design in conjunction with other managers.
• Designs, creates, and maintains databases in a client/server environment.
• Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.
• Advises users on access to various client/server databases.
• Designs, implements, and maintains complex databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Applies knowledge and experience with database technologies, development methodologies, and front-end/back-end programming languages (e.g., SQL).
• Performs database programming and supports systems design. Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

Job Requirements: