IT Specialist

Summary The IT Specialist (Data Management) performs multiple, varying, and complex assignments under the limited direction of the manager in an Oracle Database Administrator role within the FAA Logistics Center (FAALC) Information System Group (ISG) Infrastructure Support Team.

Responsibilities Supports a variety of Oracle-specific solutions including, but not limited to Oracle 12c/19c database projects.

Role will also require configuring secure Oracle backup solutions and implementing Oracle Real Application Cluster and DataGuard (standby) systems in a Unix Operating System (OS) environment.

Applies experience and advanced technical knowledge applicable to installing and configuring Oracle 12c and 19c in development, test, production, and disaster recovery environments in single or multi-tiered deployments in a Unix OS environment.

Performs database tuning and administrative functions for multiple applications within (Development, Test, Production, and Disaster Recovery) environments. Performs Oracle installs, upgrades, patching and other administrative functions.

Utilizes fluent understanding of Oracle Relational Database Management System Software (RDBMS) engine, including configuration and internal Oracle components to perform assignments.

Performs installation for Oracle database environments in highly available deployments and in disaster recovery environments.

Applies knowledge of Oracle Recovery Manager (RMAN) and Flashback technologies, including integration to third party hot backup agents that integrate with RMAN and knowledge with Oracle advanced database security options (Virtual Private database, Label Security, Advanced Security) and Enterprise Resource Planning (ERP) implementations.

Properly recommends disk space, RAM and CPU capacities related to sizing an Oracle environment with strong Oracle disk layout experience.

Contacts are internal and external. May act as a key technical point of contact for assigned activities. Contributes to the preparation of management/technical reports or contractual documents.

Established policies/procedures provide guidance for most assignments but allow considerable discretion to select the most appropriate approach or to recommend new approaches.

Assignments typically require solutions to be derived by interpreting and extrapolating from situations faced in the past. Provides recommendations to improve work processes. Provides guidance to lower-level technical staff on how to solve difficult technical issues. Resolves all but unique technical problems without the intervention of management or a more experienced technical specialist. Identifies and informs management of problems that require their attention. Often develops and recommends techniques to address problem situations.

Work is reviewed periodically, typically at major milestones and at completion, for technical compliance and alignment with the requirements of the project or other work activity.

Work activities typically support and may be vital to the success of projects or activities of one or more organizational units, subdivisions, and LOB's/SO's.

Requirements Conditions of Employment We are not accepting applications from noncitizens.

Qualifications To qualify for this position at the FV-I (FG/GS 13) level, you must demonstrate in your application that you possess at least one year of specialized experience equivalent to FV-H (FG/GS-12).

Specialized experience is experience that has equipped you with the particular knowledge, skills, and abilities to perform successfully the duties of the position.

Specialized Experience includes experience working with a variety of Oracle-specific solutions including Oracle 12c/19c database projects, applying knowledge of Oracle RMAN and Flashback technologies Oracle Relational Database Management System Software.

AND Individuals must have IT-related experience demonstrating each of the four competencies listed below.

The experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate.

1. Attention to Detail - Is thorough when performing work and conscientious about attending to detail. 2.

Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.

3.

Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately.

4.

Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.

Applicants should include examples of experience in their work history. Qualifications must be met by the closing date of the announcement. Education See qualifications required.

KSA Information:

As a part of the Federal-Wide Hiring Reform Initiative (streamlining the hiring process), the FAA is committed to eliminating the use of the Knowledge, Skills and Ability (KSA) narratives from the initial application in the hiring process for all announcements.

Therefore, as an applicant for this announcement, you are NOT required to provide a narrative response in the text box listed below each KSA.

In lieu of providing a KSA narrative response in the text box listed below each KSA, in your work history, please include information that provides specific examples of how you meet the response level or answer you chose for each KSA.

Your work history examples should be specific and clearly reflect the highest level of ability.

Your KSA answers will be evaluated further to validate whether the level that you selected is appropriate based on the work history and experience you provided.

Your answers may be adjusted by a Human Resource Specialist as appropriate.

Eligible applicants meeting the minimum qualification requirements and selective factor(s), if applicable, may be further evaluated on the Knowledge, Skills and Abilities (KSA) and Other Factors listed in the announcement.

Based on this evaluation, applicants will be placed in one of the following categories:
score order, category grouping, or alphabetical and referred to the selecting official for consideration. Additional Information We may use this vacancy to fill other similar vacant positions. Position may be subject to a background investigation. A one-year probationary period may be required.

The person selected for this position may be required to file a financial disclosure statement within 30 days of entry on duty.

FAA policy limits certain outside employment and financial investments in aviation-related companies. The U.S.

Department of Transportation strives to ensure that equity, transparency, accountability, collaboration, and communication permeate all that we do for the betterment of the Department, the traveling public, and our nation.

As such, DOT values a highly diverse workforce of persons who promote a culture of belonging by respecting the personal dignity and worth of each individual and fostering a positive environment where all feel safe and welcome.

If these commitments coincide with your personal ideals and professional aspirations, please consider joining the DOT family.

NOTES:
1. Some, all, or none of the applicants may be interviewed. 2. All applicants MUST apply online to receive consideration for this vacancy announcement. Faxed, mailed, or e-mailed applications cannot be accepted. 3. Position is covered by the FAA Core Compensation plan.

Additional information about core compensation is available on the following website:
Pay & Benefits | Federal Aviation Administration ). 4. Please ensure you answer all questions and follow all instructions carefully. Errors or omissions may impact your rating or may result in you not being considered for the job. 5. Additional information regarding living in Oklahoma can be found at 6. Please upload supporting documents into USAJOBS or 9-AMC-AHF- and reference the announcement number. TO CONFIRM RECEIPT OF DOCUMENTS, PLEASE CONTACT Tiffany Jones at This is a bargaining unit position.

This position is represented by AFGE 2282:
Aero Center Consolidated.

Links to Important Information:
Locality Pay , COLA

---