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

Job Title:INFORMATION TECHNOLOGY SPECIALIST (DATAMGT)

Department:Department of the Army

Agency:Army National Guard Units (Title 32)

Job Announcement Number:NG950286

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

The contents of the announcement can still be viewed.

SALARY RANGE:

$68,809.00 to $89,450.00 / Per Year

OPEN PERIOD:

Monday, August 26, 2013 to Monday, September 16, 2013

SERIES & GRADE:

GS-2210-12

POSITION INFORMATION:

Full Time - Permanent

DUTY LOCATIONS:

1 vacancy in the following location:
Jefferson City, MO United StatesView Map

WHO MAY APPLY:

All qualified permanent and indefinite TECHNICIANS who are currently employed by the United States Propery and Fiscal Office in Jefferson City, Missouri.

JOB SUMMARY:

MISSOURI NATIONAL GUARD

ARMY TECHNICIAN VACANCY ANNOUNCEMENT

This position is located at the United States Property and Fiscal Office in Jefferson City, MO United States 1 vacancy

Incumbent will be assigned to Position Description Number D1627000 in SPMD 1522


APPOINTMENT FACTORS:  This is a Permanent Excepted Service position. This is a non-bargaining unit position.

NATIONAL GUARD MEMBERSHIP REQUIRED:  This is an Excepted position that requires active membership in a compatible skill in the Missouri Army National Guard and wear of the military uniform. Acceptance of an excepted position constitutes concurrence with these requirements as a condition of employment. Applicants who are not currently enlisted in the Missouri Army National Guard must be eligible for immediate enlistment or appointment. For enlistment/appointment information, contact 1-800-GO-GUARD (1-800-464-8273).

MILITARY REQUIREMENTS: Selected candidate will be required to be in a compatible military assignment prior to effective date of placement. Selected candidate must be MOS qualified within 12 months from date of appointment.

Warrant Officer – WMOS 255A, 255N, and 255S

Enlisted – MOS 25B, 25U, and 25Z

Supervisor must verify that selected individual occupies a compatible military position. Technicians will not be militarily senior to their full-time supervisor (grade inversion).

IMPORTANT NOTES: Permanent Change of Station (PCS) allowances are not authorized for this position. Required Security Clearance is Noncritical Sensitive.

Failure to complete management prescribed courses for full-time support personnel within the first year of employment or assignment, may be cause for reassignment or termination.

KEY REQUIREMENTS

  • AGMO Form 335-1-R is required - see instructions under How to Apply
  • Membership in Missouri Army National Guard is required for this position
  • Direct Deposit is mandatory
  • Individuals on incentive bonuses may be subject to recoupment,
  • contact the State Incentives Manager for more information

DUTIES:

Back to top

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. 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.


QUALIFICATIONS REQUIRED:

Back to top

Specialized Experience: Must possess 36 months of experience that demonstrates your ability to plan, design, coordinate, install, maintain and upgrade multiple relationship database management systems (RDBMS).  The specialized experience must also demonstrate the ability to manage and analyze standardized database systems to ensure problems identified are resolved in an efficient manner and recommending changes for maintaining the programming code; and knowledge of state-of-the-art information technologies pertaining to data management and knowledge of the characteristics of the organizations existing data requirements, new or changed data needs, and sources of data to conduct studies.

 

General experience: General technical, analytical, supervisory or administrative experience that demonstrates your ability to analyze problems of organization, workforce, information requirements, etc., and provide systematic solutions, and the ability to deal satisfactorily with others.


OTHER REQUIREMENTS:
To be eligible for Federal employment, male applicants born after December 31, 1959, must certify at the time of appointment that you have registered with the Selective Service System, or are exempt from having to do so under Selective Service law.

Be advised that if selected for a military technician position where membership in a reserve component is a condition of employment, your bonus will be terminated and may or may not be subject to recoupment. Questions pertaining to recoupment may be directed to the State Incentives Manager at (573) 638-9500 ext. 7647.

Pre-placement or baseline physical is required to newly hired personnel who may be potentially exposed to health hazards in the work environment or who are assigned to positions requiring specific standards of physical fitness prior to an effective start date of employment being established.

HOW YOU WILL BE EVALUATED:

Once the application process is complete, a review of your application will be made to ensure you meet the job requirements. To determine if you are qualified for this job, a review of your resume and supporting documentation will be made and compared against your responses to the qualifications questionnaire. The numeric rating you receive is a measure of the degree to which your background matches the knowledge, skills and abilities required of this position and is based on your responses to the qualifications questionnaire. Your score may be adjusted to more accurately reflect your abilities based on information listed in your resume and/or supporting documents. Please follow all instructions carefully. Errors or omissions may affect your rating. Please ensure the accuracy of your information. Making a false statement in any part of your application may result in disciplinary action.


BENEFITS:

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. 

http://www.opm.gov/retire/retire_jobseekers.asp or http://www.usajobs.gov/ResourceCenter/Index/Interactive/Benefits#icc



OTHER INFORMATION:

ALL APPLICANTS ARE CONSIDERED WITHOUT REGARD TO RACE, RELIGION, COLOR, NATIONAL ORIGIN, SEX, POLITICAL AFFILIATION, AGE (WITH AUTHORIZED EXCEPTIONS) OR ANY OTHER NON-MERIT FACTOR.
 



HOW TO APPLY:

Back to top

To apply for this position, you must provide a complete Application Package, which includes the following:

1.      Your responses to the Occupational Questionnaire, and
2.      Your résumé, and/or OF-612
3.      Completed AGMO Form 335-1-R, Supplemental to Application for Employment Military Brief, and
4.      Any other documents specified in the Required Documents section of this job announcement.

NOTE:  If you are using education to qualify for this position OR education is a mandatory requirement to meet qualifications, YOU MUST submit copies of college transcripts that identify, for each course, the college or university, semester or quarter hours earned, grade and grade-point received.  Submitting a certificate or a degree will not suffice.  You must submit transcripts when required.

APPLICATION MATERIALS MUST BE RECEIVED BY 11:59 PM EASTERN TIME ON  Monday, September 16, 2013. FAILURE TO PROVIDE COMPLETE INFORMATION MAY HINDER YOUR CONSIDERATION FOR THIS POSITION. 

Please follow the instructions listed below for submitting the Occupational Questionnaire, Resume, AGMO Form 335-1-R, and Required Documents.  Please read all instructions before you begin.  You are solely responsible for the delivery of your materials.  We cannot be responsible for incompatible software, illegible fax transmissions, delays in mail service, etc.  Your materials will not be returned; therefore, do not submit original documents that you may need in the future (upload these documents from your files or submit copies instead).

To expedite the application process, it is recommended to have your resume and your AGMO FORM 335-1-R completed prior to beginning the Application Manager process.  This will aid in the upload process and make it more convenient for you.  You can access the AGMO Form 335-1-R by clicking on the following link:
http://www.moguard.com/cmss_files/attachmentlibrary/AGMO%20Form%20335-1-R%20Supplement%20to%20Application%20for%20Employment%20-%20Military%20Brief.doc.  

The most direct access to the application process of applying for a Missouri National Guard vacancy announcement would be through the Human Resources Home Page which provides a direct link to the vacancy announcement in USA JOBS.  The address is: http://www.moguard.com/technician-jobs.html.

 

You are encouraged to apply online. Applying online will allow you to review and track the status of your application.

 

NOTE: If you applied online and your application is complete, do not fax the paper application (1203FX) as this will overwrite your prior online responses and may result in you being found ineligible.


There are two options used to apply for our positions:

OPTION A:  APPLY ON-LINE

  • To begin, click Apply Online to create a USAJOBS account or log in to your existing account. Follow the prompts to select your USAJOBS resume and/or other supporting documents and complete the occupational questionnaire.
  • Click the Submit My Answers button to submit your application package.
  • It is your responsibility to ensure your responses and appropriate documentation is submitted prior to the closing date.
  • To verify your application is complete, log into your USAJOBS account, https://my.usajobs.gov/Account/Login, 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 must submit a separate application package for each position.
  •  

    (Note: To ensure successful uploads to USASTAFFING, please ensure your documents are saved in an accepted file format and are not password protected. Accepted file formats include: JPG, PDF, TXT, RTF, DOC, WPD, XFD, FDF, XFDF or HTM/HTML.)

    OPTION B:  FAXING INSTRUCTIONS

    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 http://staffing.opm.gov/pdf/usascover.pdf and provide the required information. The Vacancy ID is 950286.
    2. Fax your documents to 1-478-757-3144.

     

    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, September 16, 2013 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:

     

    1. Click the following link to view and print the occupational questionnaire View Occupational Questionnaire.
    2. Print the 1203FX form, follow the instructions and provide your responses to the occupational questionnaire items http://www.opm.gov/forms/pdfimage/opm1203fx.pdf.  To fax documents, you MUST use the special cover page.
    3. Fax all six pages of the completed 1203FX form along with any supporting documents to 1-478-757-3144. Your 1203FX will serve as a cover page for your fax transmission.

    - Include the 8-character Vacancy Identification Number NG950286
     - Provide your Social Security Number and full name in the spaces provided or we will not be able to associate your document(s) with the rest of your application.
     - You may submit multiple documents for the same vacancy announcement using one cover page.
     - Fax your cover page and documents to 1-478-757-3144.

    Faxed documents submitted with missing information will not be processed. The following will prevent your documents from being processed:
     - Not using the special cover page mentioned above.
     - Missing, incomplete, or invalid Vacancy Identification Number
     - Missing or incomplete Social Security Number or name

    The following documents are required in addition to completion of the Occupational  Questionnaire:

    - AGMO Form 335-1-R, Supplement to Application for Employment Military Brief

    The AGMO Form 335-1-R is a supporting document that highlights your military service.  You can access this form by clicking on the following link:
    http://www.moguard.com/cmss_files/attachmentlibrary/AGMO%20Form%20335-1-R%20Supplement%20to%20Application%20for%20Employment%20-%20Military%20Brief.doc.

     

    - Resume, Optional Form 612, or any other written format

    Your resume, the Optional Application for Federal Employment (OF 612), or any other written format you choose to describe your job-related qualifications can be submitted electronically using the document upload or fax process. Please ensure that your resume contains your full name, address, phone and at least your last four digits of your social security number. The Optional Application for Federal Employment (OF 612) can be local at
    http://www.moguard.com/moguard-forms.html.

    NOTE: Be specific and always include dates and complete details of all job related experience.



    REQUIRED DOCUMENTS:

    The following documents are required and must be received before your name will be referred for employment consideration:

    All applicants are required to submit the following supporting document type(s):
       ·Resume

    Applicants may also submit the following supporting document type(s),which may not be required for all applicants:
       ·Cover Letter
       ·DD-214
       ·Other (AGMO Form 335-1-R, Supplemental to Application for Employment Military Brief)
       ·SF-50
       ·Transcript


    - If you are using education to qualify for this position OR education is a mandatory   requirement to meet qualifications, YOU MUST submit copies of college transcripts that identify, for each course, the college or university, semester or quarter hours earned, grade and grade-point received.  Submitting a certificate or a degree will not suffice.  You must submit transcripts when required. Photocopies are acceptable, but you will be required to provide originals if you are selected for this position.

    - If you are or have been a Federal employee, please submit a copy of your last Notification of Personnel Action, Form SF-50.  (This is not a requirement for current Technicians employed by the Missouri National Guard.)
     

    Your completed application--occupational questionnaire, AGMO Form 335-1-R, resume, and required documents must be completed and submitted before you will receive employment consideration. If you have submitted all your materials using the recommended method listed above, you have completed the application process.

    CONTACTING US:  After you have read all the instructions in this vacancy announcement, if you still have questions about this position or the application process, you may contact us at (573) 638-9811.

    AGENCY CONTACT INFO:

    Tracina R. Harrison
    Phone: (573)638-9500x7495
    Email: TRACINA.R.HARRISON.MIL@MAIL.MIL
    Agency Information:
    Missouri National Guard
    Human Resources Office
    NGMO-HRD-S
    2302 Militia Drive
    Jefferson City, MO
    65101-1203
    USA

    WHAT TO EXPECT NEXT:

    Once the application process is completed in its entirety, a review of your application will be made to ensure you meet the job requirements.  A review will be made of your responses to the occupational questionnaire and the documentation you submitted in your resume and on the AGMO Form 335-1-R to support your responses.  The selecting official will contact you for an interview if your name is referred for this position.

     

    Instructions for completing the OPM 1203-FX:
    If you are applying to this announcement by completing the OPM 1203-FX form instead of using the Online Application method, please use the following step-by-step instructions as a guide to filling out the required questionnaire.  You will need to print the vacancy announcement and refer to it as you answer the questions.  You may omit any optional information; however, you must provide responses to all required questions.  Be sure to double check your application before submission.

    Social Security Number

    Enter your Social Security Number in the space indicated.  Your Social Security number is requested under the authority of Executive Order 9397 to uniquely identify your records from those of other applicants who have may have the same name.  Providing your Social Security Number is voluntary, however we cannot process your application without it.


    Vacancy Identification Number

    The Vacancy Identification Number is 950286

    1. Title of Job

    INFORMATION TECHNOLOGY SPECIALIST (DATAMGT)

    2. Biographic Data

    3. E-Mail Address

    4. Work Information

    5. Employment Availability

    QUESTION 1:  Are you a permanent technician who is currently employed by the Missouri Army National Guard?

    If you answered Yes to this question, please respond No to Question 2.


    QUESTION 2:  Are you an indefinite or temporary technician who is currently employed by the Missouri Army National Guard     OR     a Missouri traditional guard member with the Missouri Army National Guard     OR    interested in guard membership in the Missouri Army National Guard?

    If you answered Yes to this question, please respond No to Question 1.


    6. Citizenship

    Are you a citizen of the United States?

    7. Background Information

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    8. Other Information

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    9. Languages

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    10. Lowest Grade

    Enter the lowest grade level that you will accept for this position.  Valid grade for this position is:
    12

    11. Miscellaneous Information

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    12. Special Knowledge

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    13. Test Location

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    14. Veteran Preference Claim

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    15. Dates of Active Duty - Military Service

    16. Availability Date

    You may leave this section blank if you can begin work in the near future.  If you will not be able to begin work in the near future, please provide the date you will be available for employment.  Please use the MM/DD/YYYY format.


    17. Service Computation Date

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    18. Other Date Information

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    19. Job Preference

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    20. Occupational Specialties

    Enter the appropriate occupational specialty code for this position.  The specialty code for this position is: 
    001 Information Technology Specialist (DATAMGT)

    21. Geographic Availability

    Select the location(s) in which you will accept employment.  Valid location for this position is:
    294040051 Jefferson City, MO

    22. Transition Assistance Plan

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    23. Job Related Experience

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    24. Personal Background Information

    If you are applying by the OPM Form 1203-FX, leave this section blank.

    25. Occupational/Assessment Questions:

    Respond to all the questions below. For each question, choose the response below that best describes your experience and/or training. Mark only one response for each question. Please note that your answers will be verified against the information you provide in your resume or application and information your references provide.

    1. Do you possess general technical, analytical, supervisory or administrative experience that demonstrates your ability to analyze problems of organization, workforce, information requirements, etc., and provide systematic solutions, and the ability to deal satisfactorily with others?

    A. Yes.
    B. No.

    2. Do you possess 36 months of specialized experience that demonstrates your ability to plan, design, coordinate, install, maintain and upgrade multiple relationship database management systems (RDBMS)? The specialized experience must also demonstrate the ability to manage and analyze standardized database systems to ensure problems identified are resolved in an efficient manner and recommending changes for maintaining the programming code; and knowledge of state-of-the-art information technologies pertaining to data management and knowledge of the characteristics of the organizations existing data requirements, new or changed data needs, and sources of data to conduct studies.

    A. Yes.
    B. No.

    3. IF YOU ANSWERED NO TO QUESTION 2, do you possess a combination of a Ph D. or equivalent, or 3 years progressively higher level of education in an accredited college or university in fields directly related to computer science, information science, or information systems management AND 24 months of specialized experience such as that described above in Question 2?

    A. Yes.
    B. No.

    4. Are you currently a member OR eligible to immediately become an active military member of the Missouri National Guard?

    MILITARY MEMBERSHIP IS REQUIRED FOR THIS POSITION

    A. Yes.
    B. No.


    For each of the following tasks, chose the statement from the list below that best describes your experience and/or training. Darken the oval corresponding to that statement. Please select only one letter for each item.

    A- I have not had education, training or experience in performing this task.

    B- I have had education or training in performing this task, but have not yet performed it on the job.

    C- I have performed this task on the job. My work on this task was monitored closely by a supervisor or senior employee to ensure compliance with proper procedures.

    D- I have performed this task as a regular part of a job. I have performed it independently and normally without review by a supervisor or senior employee.

    E- I am considered an expert in performing this task. I have supervised performance of this task or I am normally the person who is consulted by other workers to assist them in doing this task because of my expertise.


    5. Reviewed 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.

    6. Served as the lead on teams assigned to study and resolve broad-based data management problems.

    7. Coordinated studies and plans with organization managers as well as administrative and technical personnel at all levels.

    8. Recommended conversion to automated systems/databases where none currently exists or recommended modifications or workarounds to facilitate the satisfaction of organizational and functional needs within the overall provisions of standardized systems.

    9. Developed strategies to accommodate managers' data needs, prepared drafts for their review by the using organization(s), and incorporated their review comments and concerns.

    10. Developed recommendations concerning major project ramifications and to offset adverse impacts.

    11. Developed work plans, program logic, special instructions, detailed process flow charts and data management needs.

    12. Monitored program development and tested and debugged programs.

    13. Assigned studies or portions of studies and program development to team members or analysts hired under contract.

    14. Technically reviewed completed work projects and provided technical assistance and guidance as required.

    15. Managed contracts with private computer firms concerning data systems application studies.

    16. Prepared scopes of work and cost estimates for the work to be contracted and ensured that the contractors' progress complies with contract terms.

    17. Certified work accomplishment, reviews and approves requests for payments.

    18. Recommended approval or disapproval of completed contractor work and took necessary action to resolve problematic issues.

    19. Completed all contract administration functions related to data management contracts including the review and signature of appropriate payment documents.

    20. Provided 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.

    21. Coordinated 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.

    22. Served as the state's data management representative at meetings and seminars I5oth 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.

    23. Interfaced 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.

    24. Provided interpretations of limited and/or conflicting regulations and guidance concerning database management and coordinates with appropriate personnel concerning the resolution of problem areas encountered.

    25. Interacted nationally with peers, vendors and other information systems (IS) sources to resolve database hardware/software problems.

    26. Used software-engineering techniques, designs new applications that enhance existing systems.

    27. Coordinated with the applications' owning agency personnel to ensure NGB and state compatibility and to recommend priorities for systems development and implementation.

    28. Ensured project coordination for the administration of all relationship database management systems (RDBMS) software products (e.g. Oracle, Informix, SyBase, MS-Access, etc.) in support of required functions.

    29. Introduced new applications and ensured and established required users access and security procedures.

    30. Ensured compliance with plans, policies, standards, infrastructures, and architectures of RDBMS.

    31. Coordinated 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.

    32. Reviewed and recommended operational procedures and software usage for the generation of alternate site file copy of essential Agency data files for continuity of operations.

    33. Managed oversight of quality assurance and system efficiency of all RDBMS systems by enforcing the prescribed RDBMS.

    34. Ensured the application of information security/information assurance policies, principles, and practices in the conduct and oversight of RDBMS, policy, and planning functions.

    35. Provided assistance, advice and guidance to organizational users, both in the administrative and technical areas, concerning the use of the multiple relationship database management systems (RDBMS available for use.

    36. Used software-engineering techniques, and designed new applications that enhance existing systems.

    37. Closely coordinated with the applications' owning agency personnel to ensure compatibility and to recommend priorities for systems development and implementation.

    38. Established policy for the use of the data and any access constraints applying to exclusive or shared file usage (in which system deadlock might occur).

    39. Developed and reviewed the administration of file membership roles, file purge roles, file back-up procedures, and audit procedures.

    40. Served as the technical expert for the definition and allocation of storage capacity requirements for the design of RDBMS.

    41. Performed oversight for design and modification of the storage structure and correlation between databases.

    42. Reviewed the optimization of RDBMS configurations.

    43. Provided technical advice and coordinated the monitoring and tuning requirements for RDBMS optimization of performance.

    44. Performed high-level analysis of RDBMS operations to identify bottlenecks and took action to resolve problems and ensure consistency.

    45. Managed the flow of data between the various tiers of the architecture.

    46. Investigated amount of storage space consumed, access time statistics and frequency of use for a given RDBMS.

    47. Reviewed RDBMS accounting information and takes action to improve efficiency.

    48. Reviewed report designs and authorized 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.

    49. Served as the reviewing authority for the development and documentation of internal Standard Operating Procedures (SOPs) for RDBMS development.

    50. Oversaw for the creation of new guidelines and recommends Engineering Change Proposal - Software (ECP-S) through proponent activity.

    51. Reviewed written documentation to include user manuals, help files, and installation guides.

    52. Coordinated the demonstration of new and enhanced user applications to customers and management.

    53. Provided training on implementation, including classroom instruction and Computer Based Training (CBT) development.

    54. Troubleshot 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.

    55. Performed duties with the responsibility for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS.

    56. Reviewed and implemented security provisions to ensure authorized access and integrity of the RDBMS.

    57. Tested new DBMS software and implements updates and changes.

    58. Ensured resolution of DBMS inconsistencies across the installation in coordination with other information technology specialists and systems.

    59. Developed system backup and recovery plans for all maintained RDBMS applications.


     


    Back to top
    Dock
    Print Preview

    Job Announcement Number:

    NG950286

    Control Number:

    350374800