IT SPECIALIST (DATAMGT)(T32)

Summary

THIS IS A NATIONAL GUARD TITLE 32 EXCEPTED SERVICE POSITION.

This National Guard position is for a IT SPECIALIST (DATAMGT)(T32), Position Description Number D1627P01 and is part of the AL USPFO, National Guard.

ORGANIZATION: USPFO, MONTGOMERY, AL

SELECTING OFFICIAL: CW4 M. BARNES

Duties

Help

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.

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.

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.

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.

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.

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.

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.

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.

PLEASE CONTACT HRO FOR COMPLETE POSITION DESCRIPTION.

Requirements

Help

Conditions of employment

• NATIONAL GUARD MEMBERSHIP IS REQUIRED. If you are not sure you are eligible for military membership, please contact a National Guard recruiter prior to applying for this position.
• This is an excepted service position that requires membership in a compatible military assignment in the employing state's National Guard, required prior to the effective date of placement.
• Selectee will be required to wear the military uniform.
• Applicants who are not currently a member of the National Guard must be eligible for immediate membership and employment in the National Guard in the military grade listed in this announcement.
• May be required to successfully complete a probationary period.
• Participation in direct deposit is mandatory.
• May occasionally be required to work other than normal duty hours; overtime may be required.

Qualifications

MILITARY REQUIREMENTS: This is an excepted service position that requires membership in a compatible military grade in the Alabama Army National Guard. Applicants who are not currently a member of the Alabama Army National Guard must be eligible for immediate membership. If you are not sure you are eligible for military membership, please contact an Alabama Army National Guard recruiter at prior to applying for this position.

MINIMUM MILITARY RANK: SGT

MAXIMUM MILITARY RANK: CW3

EXPERIENCE REQUIREMENTS: Each applicant must fully substantiate (in his/her own words) that he/she meets the requirements of the Specialized Experience listed below: Otherwise, the applicant will be considered unqualified for this position. DO NOT COPY THE VACANCY ANNOUNCEMENT OR THE POSITION DESCRIPTION. DOING SO MAY RESULT IN DISQUALIFICATION FOR THE POSITION.

GENERAL EXPERIENCE: 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: 1-year specialized experience equivalent to at least the next lower grade.

KNOWLEDGE REQUIRED BY POSITION:

Knowledge of a wide range of standards, principles, concepts, methods, policies, system testing principles and methods, and authorized system approaches pertinent to database management.

Skill in analyzing organization's data needs to identify, develop and implement a database management system that provides the most effective support for the organization.

Knowledge of the automated IT equipment available and needed to implement new or changed features of the involved database systems.

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 covering a myriad of interrelated data management considerations.

Knowledge of IT resources and infrastructure including automated systems, IT equipment and software, system technology, provisions and requirements of a variety of standardized administrative and technical database systems. Applies this knowledge in serving as the technical expert concerning the application, implementation, and maintenance of the organizations automated database system and the resolution of associated system problems.

Knowledge of the structures, functions, work processes/programs of the organization, as well as a high degree of analytical ability to gather, assemble and analyze facts, draw conclusions and devise solutions to problems which will increase the effectiveness of business processes.

Knowledge of project management principles, practices and methods to serve as the lead on special and/or teams to study and resolve broad-based data management problems and situations.

Knowledge of cost benefit analysis to analyze and study current and desired systems and recommend the most cost effective systems for local application.

Knowledge of and experience in the use of oral and written communication methods and techniques to accomplish continuing coordination with customers and make presentations at meetings.

Knowledge of database query languages, table relationships, and views.

Knowledge of IT and relational database system security principles and methods.

Broad knowledge of system design, programming techniques, local operating system software, and RDBMS concepts in order to achieve optimum performance and utilization of the RDBMS.

Analytical ability to gather, assemble and analyze facts, draw conclusions, and devise solutions to problems and increase the effectiveness of the RDBMS.

Knowledge of RDBMS monitoring and tuning techniques to optimize operational performance.

Knowledge of RDBMS, operating systems (OS), physical and virtual data storage media to define and allocate storage capacity in the design of RDBMS.

Knowledge of, and skill in applying advanced troubleshooting techniques relative to RDBMS, programming techniques, hardware platforms and system software.

Knowledge of Internet technologies to analyze the potential of systems, networks, and RDBMS.

Knowledge of system software design and knowledge of computer language sufficient to develop or monitor development of schema that interface with vendor software.

Education

SUBSTITUTION OF EDUCATION FOR SPECIALIZED EXPERIENCE:

Ph.D. or equivalent doctoral degree

or 3 full years of progressively higher level graduate education leading to a Ph.D. or equivalent doctoral degree

You must provide transcripts or other documentation to support your Educational claims. To receive credit for Education, you must provide documentation of proof that you meet the Education requirements for this position.

Additional information

If you are a male applicant who was born after 12/31/1959 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 (;br>
**This position may be authorized a recruitment or relocation incentive for up to 25%. All incentives must be approved prior to the employee in processing.**

Expand Hide additional information

Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.

Benefits

Help

A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.

Review our benefits

Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.