This Position Is No Longer Available
  1. Overview
  2. Duties
  3. Qualifications & Evaluations
  4. Benefits & Other Info
  5. How to Apply

Job Title:IT Specialist (DATAMGT)

Department:Department of the Army

Agency:Army National Guard Units (Title 32)

Job Announcement Number:AR13-268 370176

This position is closed and no longer accepting online applications through USAJOBS.

The contents of the announcement can still be viewed.


$60,520.00 to $94,300.00 / Per Year


Friday, September 06, 2013 to Monday, October 07, 2013




Full Time - Excepted Service Term


1 vacancy in the following location:
Salem, OR United StatesView Map


All groups of qualified individuals


Oregon Army National Guard
nationwide Technician Vacancy Announcement

IT Specialist (DATAMGT)

Location: JFHQ-DCSIM in Salem Oregon 
Appointment Type: Excepted Service Term (Indefinite)
PD #: D1627
Salary Range: $60,520.00- $94,300.00
*Candidates must be able to obtain and maintain a Secret Security Clearance
*Individual selected must have or obtain a Security+ certification within 6 months from the date of hire*
*Individual selected must have or posses MCSE Data Platform within 12 months from date of hire*
*Candidates must have a valid state driver's license*
*May convert to permanent without further competition*
*PCS is not Authorized*  

MEMBERSHIP IN THE NATIONAL GUARD IS REQUIRED: Individuals in the 3rd Area of Consideration must meet all military requirements of achieving 20 years of service prior to age 60. This is an Excepted Service position that requires membership in the Oregon National Guard as a condition of employment. Selectee will be required to wear the military uniform. Acceptance of an Excepted Service position constitutes concurrence with these requirements as a condition of employment.

1st Area: Current permanent full time technicians of the Oregon Army National Guard.
2nd Area: Current members of the Oregon Army National Guard.
3rd Area: Individuals eligible to become members of the Oregon Army National Guard.
Application materials must be received in our office by Monday, October 07, 2013. Failure to provide complete information may result in your not receiving consideration for this position. Please refer to the Qualifications and Evaluations section to understand the qualification requirements, and How To Apply Section for detailed instruction on applying.


  • Military Requirement: Officer, Warrant Officer and Enlisted
  • Military Rank Requirement: Max Rank-O3/CPT
  • Officer MOS: 25 & 53
  • Warrant Officer MOS: 255A/N/S
  • Enlisted MOS: 25B/U/Z


Back to top

This position is located in an information management organization. Its purpose is to serve as the technical expert and project leader for database administration in the state. Administers multiple relational database management systems (RDBMS) and software packages residing on multiple hardware and software platforms. Incumbent performs duties with broad technical latitude.
Work involves supervising or performing work requiring knowledge of (a) the basic processes of administration, (b) the principles and standard practices of management, and (c) the techniques of organization, direction, coordination, and control. Experience, education, or training which provided a general knowledge of principles of organization, management, and administration. Experience using computer and automation systems.
--Incumbent serves as the organization’s senior database representative at state and NGB/agency meetings and seminars designed to arrive at solutions to mutual database application problems encountered and to provide knowledge and information concerning emerging technologies.
--Reviews existing and anticipated future database systems including current automated systems, current data shortcomings, data requirements of the organization/function, the intricacies and provisions of available standardized systems, special organizational/functional data requirements/situations that don’t conform to the provisions of existing standardized systems, and higher authority database system plans. Serves as the lead on teams assigned to study and resolve broad-based data management problems. Continuously coordinates studies and plans with organization managers as well as administrative and technical personnel at all levels. Recommends conversion to automated systems/databases where none currently exist or recommends modifications or workarounds to facilitate the satisfaction of organizational and functional needs within the overall provisions of standardized systems. Develops strategies to accommodate managers’ data needs, prepares drafts for their review by the using organization(s), and incorporates their review comments and concerns. Prepares study summaries for comparison of alternatives pertinent to the economic justification of costs, time and equipment usage and generates complex queries and reports. Develops recommendations concerning major project ramifications and to offset adverse impacts. Develops work plans, program logic, special instructions, detailed process flow charts and data management needs. Monitors program development and tests and debugs programs. Develops and implements database management strategies for the backup and recovery of database information resulting from system operational and performance problems.
--Assigns studies or portions of studies and program development to team members or analysts hired under contract. Technically reviews completed work projects and provides technical assistance and guidance as required. Manages contracts with private computer firms concerning data systems application studies. Prepares scopes of work and cost estimates for the work to be contracted. Ensures that the contractors’ progress complies with contract terms. Certifies work accomplishment, reviews and approves requests for payments. Ensures compliance with the terms and provisions of contracts and compliance with specifications. Recommends approval or disapproval of completed contractor work and takes necessary action to resolve problematic issues. Accomplishes all contract administration functions related to data management contracts including the review and signature of appropriate payment documents.
--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. Coordinates with specialists and managers at higher National Guard Bureau levels to obtain information to interface with systems at those levels to facilitate the acquisition and exchange of database information. Serves as the state’s data management representative at meetings and seminars both at the local and national level designed to arrive at solutions to mutual database management problems encountered and to provide knowledge and information concerning state-of-the-art techniques, software, and equipment.
--Interfaces with personnel within the same organization, local users, NGB, other agencies, and vendors in resolution of problems, recommendation of database application changes and system upgrading or enhancements. Provides interpretations of limited and/or conflicting regulations and guidance concerning database management and coordinates with appropriate personnel concerning the resolution of problem areas encountered. Interacts nationally with peers, vendors and other information systems (IS) sources to resolve database hardware/software problems.
--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.
--Ensures project coordination for the administration of all RDBMS software products (e.g. Oracle, Informix, SyBase, MS-Access, etc.) in support of required functions. Responsible for the introduction of new applications and ensures and establishes required users access and security procedures. Ensures compliance with plans, policies, standards, infrastructures, and architectures of RDBMS. Coordinates with other project leaders and managers at higher levels to obtain information to interface with systems at those levels to facilitate the acquisition and exchange of RDBMS information. Reviews and recommends operational procedures and software usage for the generation of alternate site file copy of essential Agency data files for continuity of operations.
--Responsible for the management oversight of quality assurance and system efficiency of all RDBMS systems by enforcing the prescribed RDBMS.
--Reviews and manages the implementation of RDBMS 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. Establishes 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 procedures.
--Serves as the technical expert for the definition and allocation of storage capacity requirements for the design of RDBMS. Performs oversight for design and modification of the storage structure and correlation between databases. Reviews the optimization of RDBMS configurations.
--Provides technical advice and coordinates the monitoring and tuning requirements for RDBMS optimization of performance. Performs high-level analysis of RDBMS 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 report designs and authorizes the implementation of reports to analyze file statistics such as individual file size, usage counts, data last referenced, etc., in order to formulate better file management policy.
--Serves as the reviewing authority for the development and documentation of internal Standard Operating Procedures (SOPs) for RDBMS development. Has oversight for the creation of new guidelines and recommends Engineering Change Proposal – Software (ECP-S) through proponent activity. Reviews written documentation to include user manuals, help files, and installation guides. Coordinates the demonstration of new and enhanced user applications to customers and management. 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.
--Develops system backup and recovery plans for all maintained RDBMS applications.
--Performs other duties as assigned.


Back to top

General Experience:
This series covers two-grade interval administers that manage, supervise, lead, administer, develop, deliver, and support information technology (IT) systems and services. This series covers only those positions for which the paramount requirement is knowledge of IT principles, concepts, and methods; e.g., data storage, software applications, networking. 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.

Education Requirements:
None to list for this position.


Specialized Experience:
Within their resume applicants must explain how they have gained the Specialized Experience required for this position. Applicants applying at the GS-11 level must have 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.


Method of Evaluating Qualifications:

Knowledge, Skills and Abilities (KSAs)

*Answering the KSA’s is NOT a requirement for consideration, but highly recommended *

   In addressing the KSAs you will describe, accurately and completely, the tasks, activities, education and experience which demonstrate your possession of the KSA listed.  Include all military experience, qualifications or training in MOS related to the position. Mere possession of an MOS is not necessarily qualifying experience; months of actual experience are the actual qualifying factor.

1.Knowledge of a wide range of standards, concepts, methods, policies, system testing principles & methods, backup & recovery models, and best business practices pertinent to database management and application development using MS SQL and MS SharePoint.


2. Skill in analyzing organization’s data needs to identify, develop and implement MS SQL and MS SharePoint solutions that provide the most effective support for the organization.


3. Knowledge of system design, programming & scripting techniques, local operating system software (MS Server), IIS web server, MS SQL and MS SharePoint concepts in order to achieve optimum performance and utilization.




Substitution of Education for Specialized Experience:
None to list for this position.

Oregon National Guard Core Values
Competence, Confidence, Courage, Commitment (CCCC)

Oregon National Guard Vision
Oregon National Guard will provide the citizens of the State of Oregon and the United States with the ready force of citizen soldiers and airman, equipped and trained to respond to any contingency natural or manmade.

Unit of military assignment is any supporting unit of  DCSIM.  Selectee will be required to participate in the Direct Deposit Electronics Funds Transfer Program. A law enforcement background check may be required prior to appointment to this position. By submitting a resume or application for this position, you authorize this agency to accomplish the check. This is a dual-status position and membership in the Oregon National Guard is required. By submitting this application you are affirming to the validity of the information you have provided.


Back to top

The Federal government offers a number of exceptional benefits to its employees. 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. For additional information visit:
Health Insurance - The Federal Employees Health Benefits Program offers over 100 optional plans. For additional information visit:
Leave - Most Federal employees earn both annual and sick leave. For additional information visit:
Life Insurance - The Federal Employees' Group Life Insurance Program (FEGLI) offers: Basic Life Insurance plus three types of optional insurance, for additional information visit:
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. For additional information visit:
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. For additional information visit:



Back to top
The Application Process
To apply for this position, you must provide a complete Application Package which includes all of the following parts:

1. Your resume
2. Explanation of Specialized Experience within your prior/current work history listed. 
3. Other documents specified in the Required Documents section, if any are listed.

The complete Application Package must be received in our office by 1630 hrs (4:40 pm PST) on Monday, October 07, 2013.
We are not currently accepting on-line applications. Please use the following information to submit your application.  
• By Mail: 
   Oregon Military Department
   PO Box 14350
   Salem, OR 97309
• Hand deliver to:
   Oregon Military Department
   1776 Militia Way SE Room 150
   Salem, Oregon.
• E-mailing is reserved for situations such as deployment, military schooling and extended TDY’s. Prior approval is required before an application is submitted via email.
Important information regarding completion and submission of your Application Package:
• Applications must typed or printed in legible dark ink. Please sign and date each application.
• Be sure to include the announcement number and position title on your application.
• You may staple your application. Do not bind, tab, or use document protectors.
• Submit only single sided copies of all application documents.
• Applications submitted using government resources will not be accepted.
• When mailing your application it is recommended that you obtain a delivery confirmation receipt showing the date your application was mailed. Please allow several business days for mail delivery prior to Monday, October 07, 2013.


Failure to provide complete information may result in your not receiving consideration for this position.
• Current Resume
• Explanation of Specialized Experience explained within your prior/current work history.
• Transcript (If using education to substitute for experience, you must submit a transcript)
• Job related certificates and licenses (Optional) - current only


Phone: (503)584-3841
Agency Information:
Oregon National Guard
PO Box 14350
ATTN Staffing
Salem, OR


After the announcement closing date, your application will be reviewed in full. If qualified your application will be forwarded to the hiring official. If further evaluation or interviews are required you will be contacted.

Back to top
Print Preview

Job Announcement Number:

AR13-268 370176

Control Number: