Database Specialist (Journeyman)

Role : Database Specialist (Journeyman)

Location : WPAFB, OH - 45433 (On-site)

Duration : 12+ Months Contract

Statement of Work :

• The consultant shall be responsible for administering, creating, and maintaining all databases required for development, testing, and production usage. Database administration includes :
• Tuning PL-SQL statements, database performance and maintaining stored procedures.
• Installing database releases, patches, and performing database upgrades and or migrations. Performing capacity planning to create and maintain databases.
• Planning and implementing backup and recovery of databases.
• Controlling migrations of programs, database changes, and data changes throughout the development cycle.
• Monitoring, analyzing and implementing Time-Compliance Network Orders (TCNO), Information Assurance Vulnerability Management (IAVM) Packages, Critical Patch Updates (CPU), and other remediation activities required to maintain the systems security, integrity, and availability.
• Implementing and enforcing security for all databases and performing required Security
• Technical Implementation Guide (STIG) audit requirements.
• Establishing and administering database users and roles.
• Managing and tuning database imports, exports, log files, and objects.
• Monitoring performance, background processes, database views, schema objects, table space, indexes, logs, and synonyms.
• Allocating resources.
• Accessing and analyze cache file utilization and performance.
• Creating and maintaining documents depicting database design, operation plans, security plans, and monitoring plans.

Task Description :

The contractor shall provide Database Administration for the eLFF systems. Database specialists are responsible for administering, creating and maintaining all databases required for development, testing, and production usage. See above section for database administration tasks.

Required skills / Level of Experience :

Nice to have skills :