It Specialist System Developer / Data

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:
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 must 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, 04/19/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: Ability to apply problem solving skills to complex software problems. Ability to function in a teleworking environment utilizing VPN, Zoom, Skype and Team. Strong knowledge in Oracle EBS RICEFW, OAF and APEX development. Ability to apply industry-standard Development, Debugging, and Testing skills to solve business problems. Knowledge of industry-standard code promotion practices. **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. 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 Nonappropriated 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 04/19/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


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:

Agency contact information AFSVC HQ NAF HR Office Email Address AFSVC Information Technology Systems
AFSVC/VT
2261 Hughes Ave, Suite #156
Lackland AFB, TX ********
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.
Equal Employment Opportunity (EEO) Policy Reasonable accommodation policy Financial suitability Selective Service New employee probationary period Signature and false statements Privacy Act 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. Help 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.