Naval Air Systems Command HUMAN RESOURCES SPECIALIST (INFORMATION SYSTEMS) in China Lake, California
About the Agency
The selectee for this position will serve as a HR Specialist (Information Systems) in the Total Force Strategy and Management Department of NAVAIRWARCENWPNDIV CHINA LAKE.
The successful selectee will perform the following duties:
- Responsible for maintaining Oracle personnel database to ensure data is accurate. Analyzes and make adjustments to database table structure, views structure, index structure, and loading of scripts as necessary to accommodate changes in Oracle, Excel and other applications/programs.
- Reviews data to ensure database is current and accurate, errors are noted and corrected.
- Responsible for handling the NAVAIR STRL (pay for performance system) data extract from the Defense Civilian Personnel Data System (DCPDS) via HRLink and upload data into an Oracle database on a regular and reoccurring basis.
- Responsible for extracting data from DCPDS via Security File Transfer Protocol (SFTP Unix server) and uploading that extract data into Oracle database on regular basis.
- Generates SQL Scripts and run edit checks to help maintain accurate data in DCPDS. When errors are discover, incumbent will also be responsible for notifying OCHR of any data discrepancies for correction.
- Responsible for providing standard and ad-hoc personnel reports. Assist customers on retrieving data from various personal systems TWMS, HRLink and Business Objects (DataMart).
- Responsible for TWMS Admin support and assist in managing TWMS accounts for the command.
- Occasional Travel
- 3-5 travel days per month may be required.
Who May Apply
This job is open to…
Current Permanent Competitive Service Internal Employees within the DoD.
Questions? This job is open to 2 groups.
- Must be a US Citizen.
- Males must be registered or exempt from Selective Service. www.sss.gov
- Must be determined suitable for federal employment.
- Must participate in the direct deposit pay program.
- May be required to successfully complete a probationary/trial period.
- See Other Information and Requirements section for additional requirements.
In order to qualify for this position, your resume must provide sufficient experience and/or education, knowledge, skills, and abilities to perform the duties of the specific position for which you are being considered. Your resume is the key means we have for evaluating your skills, knowledge, and abilities as they relate to this position. Therefore, we encourage you to be clear and specific when describing your experience.
For DA-04: Your resume must demonstrate at least one year of specialized experience at or equivalent to the DA-03 (GS-09/10) grade level or pay band in the Federal service or equivalent experience in the private or public sector. Specialized experience must demonstrate some or all of the following: 1)Advanced use of Standard Query Language (SQL) and Oracle relational database with the ability to query, analyze, and maintain Oracle data using SQL; 2) Skill in Microsoft Excel, to include Visual Basic Scripting (VBA); 3) Knowledge and demonstrated use of multiple Defense Civilian Data systems, DCPDS, TWMS, HRLink, Business Object, and TFMMS; 4) Skill in customer desktop environment and applying PII assurance methodologies; and/or 5) Knowledge and application of personnel action processing, status appointments, and historical DCPDS data codes.
For DA-03: Your resume must demonstrate at least one year of specialized experience at or equivalent to the DA-02 (GS-05/08) grade level or pay band in the Federal service or equivalent experience in the private or public sector. Specialized experience must demonstrate some or all of the following: 1) Knowledge of Standard Query Language (SQL) and Oracle relational database; 2) Skill in Microsoft Excel, to include Visual Basic Scripting (VBA); 3) Knowledge and demonstrated use of multiple Defense Civilian Data systems, DCPDS, TWMS, HRLink, Business Object, and/or TFMMS; 4) Skill in customer desktop environment and applying PII assurance methodologies; 5) Knowledge and application of personnel action processing, status appointments, and historical DCPDS data codes.
Additional qualification information can be found from the following Office of Personnel Management web site: http://www.opm.gov/qualifications/Standards/group-stds/gs-admin.asp.
You will receive credit for all qualifying experience, including volunteer and part time experience. You must clearly identify the duties and responsibilities in each position held and the total number of hours per week.
Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., professional, philanthropic, religious, spiritual, community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment.
To preview this questionnaire and determine if your experience matches the skills required for this position, click on the following link: https://apply.usastaffing.gov/ViewQuestionnaire/10036268
If you are using education to meet all or part of the qualification requirements, you must submit a copy of your transcripts or an itemized list of college courses which includes equivalent information from the transcript (course title, semester/quarter hours, and grade/degree earned) in your resume. See OPM's General Policies for information on crediting education.
Education completed in foreign colleges or universities may be used to meet the qualification requirements if the applicant can provide documentation indicating that the foreign education is comparable to that received in an accredited educational institution in the United States. It is the responsibility of the applicant to provide such evidence when applying for further information, visit: http://www.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html
Generally, current Federal employees applying for STRL Demonstration jobs must serve at least one year at the next lower pay band. This requirement is called time-in-band. All qualifications and time-in-band requirements must be met by the closing date of this announcement and clearly documented in your resume.
Must be able to obtain an interim and/or final secret security clearance prior to entrance on duty AND must be able to maintain the required level of clearance while employed in the subject position. Failure to obtain and maintain the required level of clearance may result in the withdrawal of a job offer or removal.
What To Expect Next
When the application process is complete, your application will be reviewed to determine if you meet the hiring eligibility and qualification requirements for which you requested consideration. You will be rated based on the information provided in your resume and responses to the questionnaire, along with your supporting documentation to determine your level of knowledge, skill, and ability related to the job requirements.
Best qualified applicants will be referred to the hiring manager. The hiring manager may choose to conduct interviews. Once the selection is made, you will receive a notification of the decision.
Stay informed of changes to your application status by signing up for automatic email alerts at https://www.usajobs.gov/Applicant/Application/ListApplications.
Review our benefits
This position is covered by the Department of Defense Priority Placement Program.
Additional vacancies may be filled by this announcement.
A tentative offer of employment will be rescinded if the selectee fails to meet the pre-employment requirements, including failure to report to any of the scheduled appointments.
The Department of the Navy uses E-Verify to confirm the employment eligibility of all newly hired employees. To learn more about E-Verify, including your rights and responsibilities, visit www.dhs.gov/E-Verify.
If you are unable to apply online and request information about the Alternate Application process, please contact the Department of Navy's Employment Information Center.
Federal annuitant information: The selection of an annuitant is subject to the Department of Defense and Department of the Navy policy on the employment of annuitants. Policy information may be found at: http://www.secnav.navy.mil/donhr/Documents/CivilianJobs/FedCivAnnuitants.pdf
This job originated on www.usajobs.gov. For the full announcement and to apply, visit www.usajobs.gov/GetJob/ViewDetails/476659800. Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.
Open & closing dates: 2017-08-12 to 2017-08-18
Salary: $56,075 to $105,718 / per year
Pay scale & grade: DA 3 - 4
Series: 0201 Human Resources Management
Appointment type: Permanent
Work schedule: Full-Time
Job announcement number: ST-10036268-17-MJP
Control number: 476659800