Army & Air Force Exchange Service DATABASE ADMINISTRATOR in AAFES Headquarters (Dallas), Texas

Job Description

APPLIES EXPERT KNOWLEDGE OF THE DATA MANAGEMENT PROCESS TO THE SUPPORT OF AAFES DATA BASE MANAGEMENT WITHIN THE IT INFRASTRUCTURE PORTFOLIO. THE TASKS ASSOCIATED WITH THIS SUPPORT MAY INCLUDE, BUT ARE NOT LIMITED TO REVIEWING, EVALUATING, DESIGNING, IMPLEMENTING AND MAINTAINING CORPORATE DATA BASES, IDENTIFYING DATA SOURCES, CONSTRUCTING DATA DECOMPOSITION AND DATA FLOW DIAGRAMS, WRITING CODE FOR ACCESSING AND MODIFYING DATA BASES AND CONSTRUCTING STORED PROCEDURES. RESPONSIBLE FOR ENSURING IT COMPLIANCE TO SECURITY, AUDIT POLICIES, AND PROCEDURES. MONITORS AND TUNES DATA BASE SYSTEMS TO ACHIEVE OPTIMUM PERFORMANCE. DEVELOPS AND MAINTAINS STANDARD OPERATING PROCEDURES AND DOCUMENTATION, PROVIDES PROJECT LEADERSHIP FOR THE PLANNING AND EXECUTION OF MAJOR DATA BASE PROJECTS, AND PROVIDES GUIDANCE AND ADVICE TO DEVELOPERS AND USERS CONCERNING DATA BASES CAPABILITIES, SOFTWARE, HARDWARE, AND PROCEDURES. ENSURES DATA INTEGRITY BY EVALUATING, IMPLEMENTING, AND MANAGING APPROPRIATE SOFTWARE AND HARDWARE SOLUTIONS. DEFINES DISASTER RECOVERY REQUIREMENTS AND PLANS AND DELIVERS A DISASTER RECOVERY SOLUTION FOR THE DATA BASE ENVIRONMENT. COORDINATES WITH AAFES BUSINESS UNITS, THE PROJECT MANAGEMENT OFFICE (PMO), OUTSIDE ENTITIES AND IT STAFF TO CONFIRM COMPLIANCE AND RISK MITIGATION HAS BEEN MET. SERVES AS THIRD LEVEL SUPPORT BY IDENTIFYING, EVALUATING, AND TROUBLESHOOTING NON-ROUTINE EVENTS AND INCIDENTS ASSOCIATED WITH THE DATA BASE MANAGEMENT PROCESSES. RESPONDS TO TELEPHONE CALLS AND EMAIL REQUESTS FOR DATA BASE MANAGEMENT PROCESSES. SAFEGUARDS PHYSICAL ACCESS TO AAFES RESTRICTED DATA, PROCESSES AND SERVICES.

Major Duties

Analyze and resolve database performance issues, database capacity issues, replication/clone/restores, and other database issues Database design and new software compliance Interface with development staff, project mgmt and Sr mgmt Data security Provide technical resource/training to lead junior staff

Job Qualifications

6 YEARS EXPERIENCE IN THE ADMINISTRATION OF IMS AND DB2 OR ORACLE AND SQL SERVER DATABASES AND SUBSYSTEMS

OR

A BACHELOR'S DEGREE IN INFORMATION TECHNOLOGY AND 4 YEARS EXPERIENCE IN THE ADMINISTRATION OF IMS, DB2, ORACLE OR SQL SERVER DATABASES AND SUBSYSTEMS

Degree (one of):

  • BACHELORS DEGREE - Preferred

Major/Minor (one of):

  • INFORMATION TECHNOLOGY - Preferred

Additional Qualifications/Requirements

Technical (Preferred/Required Skills/Systems): * Oracle Database Administration * Oracle Weblogic and Application Administration * Backup, Recovery, Performance Tuning, Patching, Security

Vacancy Number: C1-000864-2017

Job Title: DATABASE ADMINISTRATOR

Exchange Location: United States - Texas - AAFES Headquarters (Dallas)

Facility Name: IT-I INFRASTRUCT MGT

Employment Category: Regular Full Time

Career Area: Information Technology

Job Grade: 4

Job Tier: 3

Work Challenges: 24x7 work environment supporting Exchange operations, which requires either shift work, on call, and/or after hours project work and may include holidays, and weekends

IT environment is constantly changing demanding quick solutions and evolving skills IT position located at HQ IT position - there may be some TDY associated with this IT work

Supervisor: No

Number of Positions Remaining: 1

Removal Date: 27-Sep-2017