Job Description
Job description
Currently assigned to the WPAFB to support the SAF/FM Systems contract. Employee 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.
Complexity of tasks/responsibilities:
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 analyzing cache file utilization and performance.
Creating and maintaining documents depicting database design, operation plans, security plans, and monitoring plans.
Educational Requirements:
• 2 years of Database administrative experience
• Excellent verbal and communication skills
Preferred experience but not required:
• Database tuning/management
• Prem and/or Cloud management
Physical Requirements:
Sedentary: involves sitting most of the time but may involve walking or standing for brief periods of time. Exerts up to 10 lbs. of force to lift, carry, push, pull or otherwise move objects.
Work Environment:
• Cubical environment in a restricted work area.
• Must comply to current COVID standards for the workplace
Criticality of Attendance:
• With the exception of STD/LTD/FMLA & approved time off, attendance is considered essential.
Equipment and Machines:
Standard office equipment and machines: personal computer, scanner, copy machine, telephone, printer, fax machine, and other office equipment including desk supplies.
Other Essential Functions:
• Must be able to secure and maintain a security clearance, if applicable.
• Must pass drug testing.
• Must be able to read and write effectively in English.
• practices and standards while performing daily tasks, taking responsibility for own and coworkers' safekeeping and encouraging others to work safely.
• Must maintain a positive work atmosphere by behaving and communicating in a manner to get along with customers, clients, co-workers and management.
• Must perform work activities requiring interaction, negotiating, instructing, supervising, persuading or speaking with others.
• Must be able to work under supervision and respond appropriately and professionally to criticism from a supervisor.
• Travel requirements - as needed, expected to be less than 10%
