IT Specialist (DATAMGT)
Company Name:
Department of Defense
Open to areas 1, 2, 3 and 4 Permanent Full Time
The National Guard is the oldest component of the Armed Forces of the United States. Since the earliest American colonial days, citizens have joined together for collective defense. We have a proud tradition of coming to the aid of our friends and neighbors in times of serious emergencies. Join our National Guard team and serve your nation, your State and your community!
NATIONAL GUARD MEMBERSHIP IS REQUIRED (DUAL STATUS ONLY): This is an excepted position that requires membership in a compatible military assignment in the North Carolina Army National Guard. Selectee will be required to wear the military uniform. Acceptance of an excepted position constitutes concurrence with the requirements as a condition of employment. _Applicants must be current members of the North Carolina Army National Guard or able to transfer from their current state_ .
_WHO CAN APPLY (DUAL STATUS):_ The area of consideration for this position is _ NATIONWIDE _. Applications will only be accepted from current military members of the Army National Guard.
_WHO CAN APPLY (COMPETITIVE/NON-DUAL STATUS):_ The area of consideration for this position is _ CURRENT ON-BOARD TECHNICIANS ONLY _. Applications will only be accepted from current competitive/non-dual status employees of the North Carolina Army National Guard with permanent or excepted indefinite positions.
_POSITION INFORMATION:_ Full-time Excepted Service (Permanent)
_POSITION LOCATION_: USPFO-DPI
_MD #:_ 1522-210
This position is a GS-11 with promotion potential to GS-12 upon completion of NGB requirements__
Must maintain membership in the National Guard for continued employment. No PCS will be authorized unless agreed upon by HRO prior to the e-date. Rank Requirement: ENL; WO; OFF(O3 & below) Compatibility Requirement: ENL: 25B/U/Z WO: 255A/N/S OFF: 25, 53
Provides assistance, advice and guidance to organizational users, both in the administrative and technical areas, concerning the use of the multiple database management systems available for use. Using software-engineering techniques, designs new applications that enhance existing systems. Closely coordinates with the applications' owning agency personnel to ensure NGB and state compatibility and to recommend priorities for systems development and implementation.Responsible for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS.Reviews and implements security provisions to ensure authorized access and integrity of the RDBMS. Ensures the application of information security/information assurance policies, principles, and practices in the conduct and oversight of RDBMS, policy, and planning functions. Implements the policy for the use of the data and any access constraints applying to exclusive or shared file usage (in which system deadlock might occur). Develops and reviews the administration of file membership roles, file purge roles, file back-up procedures, and audit technical advice and coordinates the monitoring and tuning requirements for RDBMS optimization of performance. Analyzes database operations to identify bottlenecks and takes action to resolve problems and ensure consistency. Manages the flow of data between the various tiers of the architecture. Investigates amount of storage space consumed, access time statistics and frequency of use for a given RDBMS. Reviews RDBMS accounting information and takes action to improve efficiency. Reviews system documentation, users manuals and training guides. Develops local state modifications to these documents to fit local operating procedures and to include instructions relative to locally developed supplemental applications. Provides training on implementation, including classroom instruction and Computer Based Training (CBT) development.Troubleshoots problems involved in the input, retrieval or modification of database information and the general operation and maintenance pertinent to any of the organizations data system elements or sub-elements.Tests new DBMS software and implements updates and changes. Ensures resolution of DBMS inconsistencies across the installation in coordination with other information technology specialists and systems administers.Develops system backup and recovery plans assigned RDBMS applications.Makes recommendations on alternatives involving major projects.Analyzes DBMS inconsistencies with other system administrators and devises recovery plans for failure resolution. Resolves a wide variety of system problems, which are caused by data errors, operator errors, hardware malfunctions and program errors. Traces and isolates causes of problems in hardware and software. Provides technical assistance to personnel involved in developing system design, programming, specifications and adapting commercially available software. Participates in the analysis of requests for new and modified applications. Determines equipment demands, number and kind of records, required files, data communication needs, procedures needed to obtain and organize information, and interfaces with other systems. Identifies relationships, sequences and search strategies to be DBMS maintenance of a data dictionary, listing the kinds of data in databases and how to access them. Coordinates and integrates data elements for a variety of projects in a number of dissimilar areas.Performs other duties as assigned.
PD (DS): D1629000
PD (NDS): N1242000
_Minimum Requirements:_ Experience, education or training that has provided a basic knowledge of data processing functions and general management principles that enabled the applicant to understand the stages required to automate a work process. Experience may have been gained in work such as computer operator or assistant, computer sales representative, program analyst, or other positions that required the use or adaptation of computer programs and systems.
Specialized Experience : Must have at least 36 months experience, education, or training that approaches techniques and requirements appropriate to an assigned computer applications area or computer specialty area in an organization. Experience planning the sequence of actions necessary to accomplish the assignment where this entailed coordination with others outside the organizational unit and development of project controls. Experience that required adaptations of guidelines or precedents to meet the needs of the assignment. Experience preparing documentation on cost/benefit studies where is involved summarizing the material and organizing it in a logical fashion.
Knowledge, skills and abilities (KSAs) listed below will be used in the selection process. KSAs are important to the entire selection process and should be addressed specifically and completely within the resume''.
1. Knowledge of Oracle RDBMS, operating systems (OS), physical and virtual data storage media to define and allocate storage capacity in the design of Oracle RDBMS.
2. Knowledge of Oracle RDBMS monitoring and tuning techniques to optimize operational performance.
3. Knowledge of IT and relational database system security priciples and methods.
4. Knowledge of database query languages, table relationships, and views.
5. Knowledge and skill in the recovery of data and databases.
Quality of Experience : Level of time is not of itself qualifying. Candidates'' experience should be evaluated on the basis of duties performed rather than strictly on the rank of the individual; however, established compatibility criteria/assignments must be followed. The applicant''s record of experience training, and education must show possession of the knowledge, skills, and abilities needed to fully perform the duties of the Miscellaneous Administration and Program Positions.
_Substitution of Education for Specialized
Experience:_ At the GS-11 level, a Ph.D. or equivalent, or 3 years of progressively higher level graduate education leading to such a degree. Major study-computer science, information science, information systems management, mathematics, statistics, operations research, or engineering, or course work that required the development or adaptation of computer programs and systems and provided knowledge equivalent to a major in the computer field.
_Military Assignment (DUAL STATUS ONLY):_ Occupants of this position must maintain continuous military membership in the North Carolina Army National Guard (NCARNG). Assignment to a compatible _Enlisted_, _Warrant Officer_ or _Officer_ (O3 & below) position in the NCARNG is mandatory. (_ENL MOS_: 25B/U/Z _WO BRANCH_: 255A/N/S _OFF BRANCH_: 25, 53)
__
_Security Clearance:_ Employment is subject to attaining and maintaining a security clearance as required by the position (ANACI minimum).
__
_Direct Deposit:_ The applicant selected for this position will be required to participate in the Direct Deposit/Electronic Funds Transfer Program.
Once the application process is complete, a review of your application will be made to ensure you meet the job requirements. To validate your qualifications for this job, a review of your r sum and supporting documentation will be made and compared against your responses to the occupational questionnaire. The rating you receive is based on your responses to the questionnaire and supporting documents. If, after reviewing your r sum and supporting documentation, a determination is made that you have misrepresented your qualifications and/or experience, your rating will be adjusted to more accurately reflect your abilities. Please follow all instructions carefully. Errors or omissions may affect your rating.
To apply for this position, you must complete the occupational questionnaire and submit the documentation specified in the Required Documents section below.
The complete application package must be submitted by 11:59 PM (EST) on Monday, June 23, 2014 to receive consideration.
To begin, click Apply Online to create a USAJOBS account or log into your existing account. Follow the prompts to select your USAJOBS resume and/or other supporting documents and complete the occupational questionnaire.
Click Submit My Answers button to submit your application package.
It is your responsibility to ensure that your responses and appropriate documentation are submitted prior to the closing date.
To verify your application is complete, log into your USAJOBS account, , select the Application Status link and then select the More Information link for this position. The ''Details'' page will display the status of your application, the documentation received and processed, and any correspondence the agency has sent related to this application. Your uploaded documents may take several hours to clear the virus scan process.
To return to an incomplete application, log into your USAJOBS account and click Update Application in the vacancy announcement. You must re-select your resume and/or other documents from your USAJOBS account or your application will be incomplete.
You are encouraged to apply online. Applying online will allow youto review and track the status of your application.
NOTE: If you applied online and your application is complete, do NOT fax the papaer application (1203FX) as this will overwrite your prior online responses and may result in you being found ineligible.
If you completed the occupational questionnaire online and are unable to upload supporting document(s):
1. To fax your documents, you must use the following cover page and provide the required information. The Vacancy ID is 1100615
2. Fax your documents to .
If you cannot complete the Application Package online, you may fax all of your materials. The complete application package must be submitted by 11:59 PM (EST) on Monday, June 23, 2014 to receive consideration. Keep a copy of your fax confirmation in the event verification is needed.
To complete the occupational questionnaire and submit via fax:
Click the following link to view and print the occupational questionnaire View Occupational Questionnaire
Print the 1203FX form, follow the instructions and provide your responses to the occupational questionnaire items
Fax all six pages of the completed 1203FX form along with any supporting documents to . Your 1203FX will serve as a cover page for your fax transmission.
The following documents are REQUIRED for this job announcement:
Current Resume (list your duties/responsibilities related to the qualifying experience listed above)
Qualification Questionnaire (On-line or OPM Form 1203-FX)
The following documents are NOT required for this job announcement :
Transcripts (optional - __required if using education to substitute for experience__)
Military Resume (optional -explain actual duties performed with the MOS/AFSC, etc.)
Miscellaneous (optional - related certifications, licenses, etc.)
Demographics Data (optional - Applicants are requested to identify, in a separate attachment, their race, gender, and national origin. Submission of this information is voluntary and will be used in support of the NCNG Equal Employment Opportunity Programs.)
Your document(s) can be submitted electronically using the document upload process or by fax. _Please ensure that your resume contains your full name, address, phone and at least your last four digits of your social security number_.
Note: Please ensure that your resume contains the basic information outlined under the Applying for a Federal Job link:
Once the online questionnaire is received you will receive an acknowledgement email that your submission was successful. After the closing date, a review of your complete application will be completed to validate your qualification status. If qualified, your documents will be forwarded to the hiring official. If further evaluation or interviews are required, you will be contacted.
Ensure that your email and phone contacts are current.
The following Web addresses are provided for your reference to explore the major benefits offered to most Federal employees.
Flexible Spending Accounts - The Federal Flexible Spending Accounts Program (FSAFeds) allows you to pay for certain health and dependent care expenses with pre-tax dollars.
Health Insurance - The Federal Employees Health Benefits Program offers over 100 optional plans.
Leave - Most Federal employees earn both annual and sick leave. Visit:
Life Insurance - The Federal Employees'' Group Life Insurance Program (FEGLI) offers: Basic Life Insurance plus three types of optional insurance.
Long Term Care Insurance - The Federal Long Term Care Insurance Program (FLTCIP) provides long term care insurance for Federal employees and their parents, parents-in-law, step parents, spouses, and adult children. /
Retirement Program - Almost all new employees are automatically covered by the Federal Employees Retirement System (FERS). FERS is a three-tiered retirement plan. The three tiers are: Social Security Benefits, Basic Benefit Plan, Thrift Savings Plan.
This link provides and overview of the benefits currently offered to Federal
1. If you are a _male applicant_ who was born after 12/31/59 and are required to register under the Military Selective Service Act, the Defense Authorization Act of 1986 requires that you be registered or you are not eligible for appointment in this agency.
2. Please do not send/fax/courier/email any resumes to the National Guard Human Resources Office. You must apply on-line or fax your resumes to the fax number listed on this announcement with the prescribed Cover Letter. __The Human Resources Office can only process materials received through USA Jobs.__Estimated Salary: $20 to $28 per hour based on qualifications.
Department of Defense
Open to areas 1, 2, 3 and 4 Permanent Full Time
The National Guard is the oldest component of the Armed Forces of the United States. Since the earliest American colonial days, citizens have joined together for collective defense. We have a proud tradition of coming to the aid of our friends and neighbors in times of serious emergencies. Join our National Guard team and serve your nation, your State and your community!
NATIONAL GUARD MEMBERSHIP IS REQUIRED (DUAL STATUS ONLY): This is an excepted position that requires membership in a compatible military assignment in the North Carolina Army National Guard. Selectee will be required to wear the military uniform. Acceptance of an excepted position constitutes concurrence with the requirements as a condition of employment. _Applicants must be current members of the North Carolina Army National Guard or able to transfer from their current state_ .
_WHO CAN APPLY (DUAL STATUS):_ The area of consideration for this position is _ NATIONWIDE _. Applications will only be accepted from current military members of the Army National Guard.
_WHO CAN APPLY (COMPETITIVE/NON-DUAL STATUS):_ The area of consideration for this position is _ CURRENT ON-BOARD TECHNICIANS ONLY _. Applications will only be accepted from current competitive/non-dual status employees of the North Carolina Army National Guard with permanent or excepted indefinite positions.
_POSITION INFORMATION:_ Full-time Excepted Service (Permanent)
_POSITION LOCATION_: USPFO-DPI
_MD #:_ 1522-210
This position is a GS-11 with promotion potential to GS-12 upon completion of NGB requirements__
Must maintain membership in the National Guard for continued employment. No PCS will be authorized unless agreed upon by HRO prior to the e-date. Rank Requirement: ENL; WO; OFF(O3 & below) Compatibility Requirement: ENL: 25B/U/Z WO: 255A/N/S OFF: 25, 53
Provides assistance, advice and guidance to organizational users, both in the administrative and technical areas, concerning the use of the multiple database management systems available for use. Using software-engineering techniques, designs new applications that enhance existing systems. Closely coordinates with the applications' owning agency personnel to ensure NGB and state compatibility and to recommend priorities for systems development and implementation.Responsible for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS.Reviews and implements security provisions to ensure authorized access and integrity of the RDBMS. Ensures the application of information security/information assurance policies, principles, and practices in the conduct and oversight of RDBMS, policy, and planning functions. Implements the policy for the use of the data and any access constraints applying to exclusive or shared file usage (in which system deadlock might occur). Develops and reviews the administration of file membership roles, file purge roles, file back-up procedures, and audit technical advice and coordinates the monitoring and tuning requirements for RDBMS optimization of performance. Analyzes database operations to identify bottlenecks and takes action to resolve problems and ensure consistency. Manages the flow of data between the various tiers of the architecture. Investigates amount of storage space consumed, access time statistics and frequency of use for a given RDBMS. Reviews RDBMS accounting information and takes action to improve efficiency. Reviews system documentation, users manuals and training guides. Develops local state modifications to these documents to fit local operating procedures and to include instructions relative to locally developed supplemental applications. Provides training on implementation, including classroom instruction and Computer Based Training (CBT) development.Troubleshoots problems involved in the input, retrieval or modification of database information and the general operation and maintenance pertinent to any of the organizations data system elements or sub-elements.Tests new DBMS software and implements updates and changes. Ensures resolution of DBMS inconsistencies across the installation in coordination with other information technology specialists and systems administers.Develops system backup and recovery plans assigned RDBMS applications.Makes recommendations on alternatives involving major projects.Analyzes DBMS inconsistencies with other system administrators and devises recovery plans for failure resolution. Resolves a wide variety of system problems, which are caused by data errors, operator errors, hardware malfunctions and program errors. Traces and isolates causes of problems in hardware and software. Provides technical assistance to personnel involved in developing system design, programming, specifications and adapting commercially available software. Participates in the analysis of requests for new and modified applications. Determines equipment demands, number and kind of records, required files, data communication needs, procedures needed to obtain and organize information, and interfaces with other systems. Identifies relationships, sequences and search strategies to be DBMS maintenance of a data dictionary, listing the kinds of data in databases and how to access them. Coordinates and integrates data elements for a variety of projects in a number of dissimilar areas.Performs other duties as assigned.
PD (DS): D1629000
PD (NDS): N1242000
_Minimum Requirements:_ Experience, education or training that has provided a basic knowledge of data processing functions and general management principles that enabled the applicant to understand the stages required to automate a work process. Experience may have been gained in work such as computer operator or assistant, computer sales representative, program analyst, or other positions that required the use or adaptation of computer programs and systems.
Specialized Experience : Must have at least 36 months experience, education, or training that approaches techniques and requirements appropriate to an assigned computer applications area or computer specialty area in an organization. Experience planning the sequence of actions necessary to accomplish the assignment where this entailed coordination with others outside the organizational unit and development of project controls. Experience that required adaptations of guidelines or precedents to meet the needs of the assignment. Experience preparing documentation on cost/benefit studies where is involved summarizing the material and organizing it in a logical fashion.
Knowledge, skills and abilities (KSAs) listed below will be used in the selection process. KSAs are important to the entire selection process and should be addressed specifically and completely within the resume''.
1. Knowledge of Oracle RDBMS, operating systems (OS), physical and virtual data storage media to define and allocate storage capacity in the design of Oracle RDBMS.
2. Knowledge of Oracle RDBMS monitoring and tuning techniques to optimize operational performance.
3. Knowledge of IT and relational database system security priciples and methods.
4. Knowledge of database query languages, table relationships, and views.
5. Knowledge and skill in the recovery of data and databases.
Quality of Experience : Level of time is not of itself qualifying. Candidates'' experience should be evaluated on the basis of duties performed rather than strictly on the rank of the individual; however, established compatibility criteria/assignments must be followed. The applicant''s record of experience training, and education must show possession of the knowledge, skills, and abilities needed to fully perform the duties of the Miscellaneous Administration and Program Positions.
_Substitution of Education for Specialized
Experience:_ At the GS-11 level, a Ph.D. or equivalent, or 3 years of progressively higher level graduate education leading to such a degree. Major study-computer science, information science, information systems management, mathematics, statistics, operations research, or engineering, or course work that required the development or adaptation of computer programs and systems and provided knowledge equivalent to a major in the computer field.
_Military Assignment (DUAL STATUS ONLY):_ Occupants of this position must maintain continuous military membership in the North Carolina Army National Guard (NCARNG). Assignment to a compatible _Enlisted_, _Warrant Officer_ or _Officer_ (O3 & below) position in the NCARNG is mandatory. (_ENL MOS_: 25B/U/Z _WO BRANCH_: 255A/N/S _OFF BRANCH_: 25, 53)
__
_Security Clearance:_ Employment is subject to attaining and maintaining a security clearance as required by the position (ANACI minimum).
__
_Direct Deposit:_ The applicant selected for this position will be required to participate in the Direct Deposit/Electronic Funds Transfer Program.
Once the application process is complete, a review of your application will be made to ensure you meet the job requirements. To validate your qualifications for this job, a review of your r sum and supporting documentation will be made and compared against your responses to the occupational questionnaire. The rating you receive is based on your responses to the questionnaire and supporting documents. If, after reviewing your r sum and supporting documentation, a determination is made that you have misrepresented your qualifications and/or experience, your rating will be adjusted to more accurately reflect your abilities. Please follow all instructions carefully. Errors or omissions may affect your rating.
To apply for this position, you must complete the occupational questionnaire and submit the documentation specified in the Required Documents section below.
The complete application package must be submitted by 11:59 PM (EST) on Monday, June 23, 2014 to receive consideration.
To begin, click Apply Online to create a USAJOBS account or log into your existing account. Follow the prompts to select your USAJOBS resume and/or other supporting documents and complete the occupational questionnaire.
Click Submit My Answers button to submit your application package.
It is your responsibility to ensure that your responses and appropriate documentation are submitted prior to the closing date.
To verify your application is complete, log into your USAJOBS account, , select the Application Status link and then select the More Information link for this position. The ''Details'' page will display the status of your application, the documentation received and processed, and any correspondence the agency has sent related to this application. Your uploaded documents may take several hours to clear the virus scan process.
To return to an incomplete application, log into your USAJOBS account and click Update Application in the vacancy announcement. You must re-select your resume and/or other documents from your USAJOBS account or your application will be incomplete.
You are encouraged to apply online. Applying online will allow youto review and track the status of your application.
NOTE: If you applied online and your application is complete, do NOT fax the papaer application (1203FX) as this will overwrite your prior online responses and may result in you being found ineligible.
If you completed the occupational questionnaire online and are unable to upload supporting document(s):
1. To fax your documents, you must use the following cover page and provide the required information. The Vacancy ID is 1100615
2. Fax your documents to .
If you cannot complete the Application Package online, you may fax all of your materials. The complete application package must be submitted by 11:59 PM (EST) on Monday, June 23, 2014 to receive consideration. Keep a copy of your fax confirmation in the event verification is needed.
To complete the occupational questionnaire and submit via fax:
Click the following link to view and print the occupational questionnaire View Occupational Questionnaire
Print the 1203FX form, follow the instructions and provide your responses to the occupational questionnaire items
Fax all six pages of the completed 1203FX form along with any supporting documents to . Your 1203FX will serve as a cover page for your fax transmission.
The following documents are REQUIRED for this job announcement:
Current Resume (list your duties/responsibilities related to the qualifying experience listed above)
Qualification Questionnaire (On-line or OPM Form 1203-FX)
The following documents are NOT required for this job announcement :
Transcripts (optional - __required if using education to substitute for experience__)
Military Resume (optional -explain actual duties performed with the MOS/AFSC, etc.)
Miscellaneous (optional - related certifications, licenses, etc.)
Demographics Data (optional - Applicants are requested to identify, in a separate attachment, their race, gender, and national origin. Submission of this information is voluntary and will be used in support of the NCNG Equal Employment Opportunity Programs.)
Your document(s) can be submitted electronically using the document upload process or by fax. _Please ensure that your resume contains your full name, address, phone and at least your last four digits of your social security number_.
Note: Please ensure that your resume contains the basic information outlined under the Applying for a Federal Job link:
Once the online questionnaire is received you will receive an acknowledgement email that your submission was successful. After the closing date, a review of your complete application will be completed to validate your qualification status. If qualified, your documents will be forwarded to the hiring official. If further evaluation or interviews are required, you will be contacted.
Ensure that your email and phone contacts are current.
The following Web addresses are provided for your reference to explore the major benefits offered to most Federal employees.
Flexible Spending Accounts - The Federal Flexible Spending Accounts Program (FSAFeds) allows you to pay for certain health and dependent care expenses with pre-tax dollars.
Health Insurance - The Federal Employees Health Benefits Program offers over 100 optional plans.
Leave - Most Federal employees earn both annual and sick leave. Visit:
Life Insurance - The Federal Employees'' Group Life Insurance Program (FEGLI) offers: Basic Life Insurance plus three types of optional insurance.
Long Term Care Insurance - The Federal Long Term Care Insurance Program (FLTCIP) provides long term care insurance for Federal employees and their parents, parents-in-law, step parents, spouses, and adult children. /
Retirement Program - Almost all new employees are automatically covered by the Federal Employees Retirement System (FERS). FERS is a three-tiered retirement plan. The three tiers are: Social Security Benefits, Basic Benefit Plan, Thrift Savings Plan.
This link provides and overview of the benefits currently offered to Federal
1. If you are a _male applicant_ who was born after 12/31/59 and are required to register under the Military Selective Service Act, the Defense Authorization Act of 1986 requires that you be registered or you are not eligible for appointment in this agency.
2. Please do not send/fax/courier/email any resumes to the National Guard Human Resources Office. You must apply on-line or fax your resumes to the fax number listed on this announcement with the prescribed Cover Letter. __The Human Resources Office can only process materials received through USA Jobs.__Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
