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 D1627000 and is part of the AL USPFO, National Guard. ORGANIZATION: USPFO, MONTGOMERY, AL SELECTING OFFICIAL: CW4 M. BARNES Responsibilities --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. --Performs other duties as assigned. PLEASE CONTACT HRO FOR COMPLETE POSITION DESCRIPTION. Requirements Conditions of Employment 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 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: Use the OPM Individual Occupation Requirements (IORs) (Alternative A) for positions in this series. Include experience, education, and/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: 1-year specialized experience equivalent to at least the next lower grade. In addition to the OPM IORs (Alternative A) specialized experience examples, specialized experience includes 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 REQUIRED: --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 (https://www.sss.gov/RegVer/wfRegistration.aspx). **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.**