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
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 800-464-8273 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.
--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.