Summary

This position will be assigned to the Air Force Service Center at Port San Antonio, TX.

This is a regular full-time category position with guaranteed 40 hrs per week. Employees appointed to a regular category position are eligible for benefits.

This job is open to

• The public
  
  U.S. Citizens, Nationals or those who owe allegiance to the U.S.

Clarification from the agency

Please see the "Who May Apply" section under the Qualifications section.

Duties

Develops, integrates, and maintains code to ensure the integrity and efficiency of data interchanges. Performs testing as necessary for workflows for routing and data transformation. Performs data mapping and validation between existing, modified and future applications to ensure efficient and effective electronic translation of data between systems. Maintains coded instructions to control integration program execution, manages system resources, and provides utility services. Assists end users in deciding which processes to automate, creates test scripts, and selects appropriate data elements to ensure agency reporting integrity is not compromised. Executes system integration, data integrity, disaster recovery and business continuity testing and exercises on all responsible systems. Provides enterprise-grade Quality of Service integrated seamlessly with other agency systems. Drafts DODAF related architecture products. Maintains currency and certification through on-line IT E-learning and other DOD provided sources. Incumbent is responsible for all technical programming aspects of the Oracle R12 e-Business Suite. Develops software programs, routines and scripts in support of the Oracle environment. Must be proficient in Oracle SQL, Forms, Reports, XML Reports, Oracle APIs, SQL Tuning, and development platforms such as Oracle Application Framework (OAF), and/or Application Express (APEX). Develops and maintains security procedures to guard against unauthorized intrusion into databases. Supports senior Database Administrators (DBAs) with operational and functional activities of relational databases. Performs other related duties as assigned. Perform and support activities for AF security compliance to include but not limited to actions to support Authority to Operate (ATO). Designs and modifies the integration of tools and/or utilities for reporting and feature enhancements as needed. Reporting integration may include analytics capabilities and reports, data warehouse, but not limited to those capabilities. Feature enhancements may include integration of tools that help users/customers reduce their workload, enhance the access to reports, data or invoice status, but not limited to those capabilities. The design and modification and integration of these tools, utilities or other additional applications will be interoperable and compatible for integration with the AF Services Oracle EBusiness Suite. These tools/applications will include the implementation of IT capabilities on an enterprise lowcode development platform used to develop and deploy web applications on the Oracle platform.

If interested in applying for this position you may preview the online application: https://apply.usastaffing.gov/ViewQuestionnaire/12442648

Requirements

Conditions of Employment

• This position requires the incumbent to complete a background investigation with favorable results.
• This position requires the incumbent to be able to obtain and maintain a Security + Certification for the duration of employment.
• This position requires the incumbent to be a U.S. Citizen or a Legal U.S. Resident for a minimum of 3 years.
• Per DoDM 8140.03, the incumbent of this position must achieve the appropriate foundational and resident qualification requirements within nine months of assignment.

Qualifications

Who May Apply: Open to everyone. Applicants will be categorized by preference(s) and/or priority consideration eligibilities. An applicant's eligibility will be determined based on eligibility claimed in the questionnaire and proof of eligibility MUST be provided with application by the closing date, 07/02/2024

Business Based Action, Outside Applicant Veteran, Spouse/Widow/Parent of Veteran, and Transition Hiring Preference

In order to qualify, you must meet the experience requirements described below. Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community; student; social). You will receive credit for all qualifying experience, including volunteer experience. Your resume must clearly describe your relevant experience; if the position allows for qualifying based on education, your transcripts will be required as part of your application.

Qualifying Experience:

Requires extensive development experience in Oracle e-Business Suite (EBS) including the development platforms Oracle Application Framework and/or Application Express (APEX). Demonstrated experience with the data integration efforts. Experience with use of the operation and functioning of relational databases, data integration and warehousing techniques using third party integration tools.

Knowledge, Skills and Abilities (KSA's): Your qualifications will be evaluated on the basis of your level of knowledge, skills, abilities and/or competencies in the following areas:

1. Ability to apply problem solving skills to complex software problems.
2. Ability to function in a teleworking environment utilizing VPN, Zoom, Skype and Team.
3. Strong knowledge in Oracle EBS RICEFW, OAF and APEX development is desired.

**NOTE: Those qualified applicants who meet both the minimum qualification requirement(s) and highly preferred criteria(s) will be considered best qualified for this position and will be referred to the selecting official(s) first for consideration.

All other applicants will be referred as needed and requested by the selecting official(s).

**Reminder to Applicants: Your experience has to be clearly identified in your resume in order to receive consideration. If your resume does not provide enough information regarding your work history for us to make a creditable qualification determination, your application package may be rendered disqualified, and you will no longer be considered for this position.

(Format example: Employer name, position title, beginning and ending dates of employment, with summary of duties, etc.)

Education

Some federal jobs allow you to substitute your education for the required experience in order to qualify. This position does not allow for education substitution.

FOREIGN EDUCATION: Education completed in foreign colleges or universities may be used to meet the requirements. You must show proof the education credentials have been deemed to be at least equivalent to that gained in conventional U.S. education program. It is your responsibility to provide such evidence when applying.

Additional information

• Individual must fully meet qualification/eligibility/background requirements for this position.
• U.S. Citizens and Non-U.S. Nationals who have resided in the U.S. Territory for three (3) or more consecutive years immediately preceding the start of Federal affiliation.
• Male applicants born after December 31, 1959 must be registered for Selective Service.
• Direct deposit is required.
• Satisfactorily complete an employment verification (E-Verify) check.
• A probationary period may be required.
• Pre-employment requirements must be satisfactorily met prior to Entrance on Duty (EOD).
• Payment of Permanent Change of Station (PCS) costs is not authorized, based on a determination that a PCS move is not in the Government's interest.
• Multiple positions may be filled from this job opportunity announcement. And additional selections may also be made from this job opportunity announcement.
• Selection(s) are subject to restrictions resulting from hiring preferences and priority consideration eligible.
• This is a Non-Appropriated Fund (NAF) position carrying out Morale, Welfare and Recreation (MWR) activities for the Air Force and Space Force.

• Benefits
  
  Review our benefits

How You Will Be Evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

Your resume and supporting document will be evaluated against the qualifications of the position.

Once the announcement has closed, a review of your application package (resume, supporting documents, and responses to the questionnaire) will be used to determine whether you meet the qualification requirements listed on this announcement. If you are minimally qualified, your resume and supporting documentation will be compared against your responses to the assessment questionnaire to determine your level of experience. If, after reviewing your resume and/or supporting documentation, a determination has been made that you have inflated your responses to meet the position's qualifications and/or experience, you may lose consideration for this position. Please follow all instructions carefully when applying, errors or omissions may affect your eligibility.

You should list any relevant performance appraisals and incentive awards in your resume as that information may be taken into consideration during the selection process. If selected, you may be required to provide supporting documentation.

To better expedite the hiring process, we recommend including full contact information (name, address, phone number, email, etc.,) for professional and personal references on your resume.

• Benefits
  
  Review our benefits
• Required Documents
  
  As a new or existing federal employee, you and your family may have access to a range of benefits. Your benefits depend on the type of position you have - whether you're a permanent, part-time, temporary or an intermittent employee. You may be eligible for the following benefits, however, check with your agency to make sure you're eligible under their policies.
  
  Required documents may vary based on the eligibility you are claiming (i.e., applying as a Military Spouse Preference - MSP, applying as a veteran, applying as a current federal employees, applying as a displaced employee, etc.,). The below document(s) are required and MUST be submitted with your application by the closing date of this job announcement:
  
  
  • Resume
  
  
  Your resume may be submitted in any format and must support identified the general or specialized experience described in this announcement. If your resume includes a photograph or other inappropriate material or content, it will not be used to make eligibility and qualification determinations and you may not be considered for this vacancy.
  
  Other accepted documents to support a qualification and/or claimed preference/priority eligibility may include:
  
  
  • Cover Letter
  • DD-214/ Statement of Service
  • Diploma/ GED
  • Disability Letter (VA)
  • License
  • Other (1)
  • Other (2)
  • PCS Orders
  • Professional Certification
  • Proof of Marriage Status
  • Resume
  • Separation Notice (RIF)
  • SF-50/ Notification of Personnel Action
  • Transcript
  
  
  As described above, your complete application includes your resume, your responses to the online questionnaire, and supporting documents which prove your claimed eligibility. If you fail to provide these documents, you will be marked as having an incomplete application package and you will not be considered any further.
  
  NOTE: Documents submitted as part of the application package to include supplemental documents may be shared beyond the Human Resources Office. Some supplemental documents such as military orders and marriage certificates may contain personal information for someone other than you. You may sanitize these documents to remove another person's personal information before you submit your application. You may be asked to provide an un-sanitized version of the documents if you are selected to confirm your eligibility.
• How to Apply
  
  To be considered for this vacancy you must apply and complete the online questionnaire and submit the documentation specified in the Required Documents section above.
  
  The complete application package must be submitted by 11:59 PM (EST) on 07/02/2024 to receive consideration.
  
  To begin, click Apply to access the online application. You will need to be logged into your USAJobs account to apply. If you do not have a USAJobs account, you will need to create one before beginning the application.
  
  Follow the prompts to select your resume and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.
  
  After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.
  
  You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package and submit the application. You must re-select your resume and/or other documents from your USAJobs account and designate the document type when submitting your application. Failure to complete this portion will result in an incomplete application package and you will not be further considered for this vacancy.
  
  It is your responsibility to ensure your application package (resume, supporting documents, and responses to the questionnaire) is complete, accurate, and submitted by the closing date.
  
  Additional information on how to complete the online application process and submit your online application may be found on the https://help.usastaffing.gov/Apply/index.php?title=Applicant
  
  To verify or check the status of your application, log into your USAJobs account. Once logged in, the Welcome screen lists your applications, your application status and the date it was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status
  
  Agency contact information
  
  AFSVC HQ NAF HR Office
  
  Email
  
  902fss.fsmh.902fssnafhumanresources@us.af.mil
  
  Address
  
  AFSVC Information Technology Systems
  
  AFSVC/VT
  
  2261 Hughes Ave, Suite #156
  
  Lackland AFB, TX 78236-9852
  
  US
  
  Next steps
  
  If you provided an email address, you will receive an email message acknowledging receipt of your application. Times may vary during the hiring process, as your application status updates/changes you will be notified with a notification letter via email.
• Fair and Transparent
  
  The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
  
  
  • Criminal history inquiries
  • Equal Employment Opportunity (EEO) Policy
  • Financial suitability
  • New employee probationary period
  • Privacy Act
  • Reasonable accommodation policy
  • Selective Service
  • Signature and false statements
  • Social security number request

Required Documents

Required documents may vary based on the eligibility you are claiming (i.e., applying as a Military Spouse Preference - MSP, applying as a veteran, applying as a current federal employees, applying as a displaced employee, etc.,). The below document(s) are required and MUST be submitted with your application by the closing date of this job announcement:

• Resume

Your resume may be submitted in any format and must support identified the general or specialized experience described in this announcement. If your resume includes a photograph or other inappropriate material or content, it will not be used to make eligibility and qualification determinations and you may not be considered for this vacancy.

Other accepted documents to support a qualification and/or claimed preference/priority eligibility may include:

• Cover Letter
• DD-214/ Statement of Service
• Diploma/ GED
• Disability Letter (VA)
• License
• Other (1)
• Other (2)
• PCS Orders
• Professional Certification
• Proof of Marriage Status
• Resume
• Separation Notice (RIF)
• SF-50/ Notification of Personnel Action
• Transcript

As described above, your complete application includes your resume, your responses to the online questionnaire, and supporting documents which prove your claimed eligibility. If you fail to provide these documents, you will be marked as having an incomplete application package and you will not be considered any further.

NOTE: Documents submitted as part of the application package to include supplemental documents may be shared beyond the Human Resources Office. Some supplemental documents such as military orders and marriage certificates may contain personal information for someone other than you. You may sanitize these documents to remove another person's personal information before you submit your application. You may be asked to provide an un-sanitized version of the documents if you are selected to confirm your eligibility.

How to Apply

To be considered for this vacancy you must apply and complete the online questionnaire and submit the documentation specified in the Required Documents section above.

The complete application package must be submitted by 11:59 PM (EST) on 07/02/2024 to receive consideration.

To begin, click Apply to access the online application. You will need to be logged into your USAJobs account to apply. If you do not have a USAJobs account, you will need to create one before beginning the application.

Follow the prompts to select your resume and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.

After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.

You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package and submit the application. You must re-select your resume and/or other documents from your USAJobs account and designate the document type when submitting your application. Failure to complete this portion will result in an incomplete application package and you will not be further considered for this vacancy.

It is your responsibility to ensure your application package (resume, supporting documents, and responses to the questionnaire) is complete, accurate, and submitted by the closing date.

Additional information on how to complete the online application process and submit your online application may be found on the https://help.usastaffing.gov/Apply/index.php?title=Applicant

To verify or check the status of your application, log into your USAJobs account. Once logged in, the Welcome screen lists your applications, your application status and the date it was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status

Agency contact information

AFSVC HQ NAF HR Office

Email

902fss.fsmh.902fssnafhumanresources@us.af.mil

Address

AFSVC Information Technology Systems

AFSVC/VT

2261 Hughes Ave, Suite #156

Lackland AFB, TX 78236-9852

US

Next steps

If you provided an email address, you will receive an email message acknowledging receipt of your application. Times may vary during the hiring process, as your application status updates/changes you will be notified with a notification letter via email.

Fair & Transparent

The Federal hiring process is set up to be fair and transparent. Please read the following guidance.

• Criminal history inquiries
• Equal Employment Opportunity (EEO) Policy
• Financial suitability
• New employee probationary period
• Privacy Act
• Reasonable accommodation policy
• Selective Service
• Signature and false statements
• Social security number request