IT SPECIALIST (DATAMGT) - TITLE 32
As an IT Specialist (DATAMGT), GS-2210-11, you will:
Provide 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. Using software-engineering techniques, design new applications that enhance existing systems. Closely coordinate with the applications' owning agency personnel to ensure NGB and state compatibility and to recommend priorities for systems development and implementation. Responsible for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS. Review and implement security provisions to ensure authorized access and integrity of the RDBMS. Ensure the application of information security/information assurance policies, principles, and practices in the conduct and oversight of RDBMS, policy, and planning functions. Implement the policy for the use of the data and any access constraints applying to exclusive or shared file usage (in which system deadlock might occur). Develop and review the administration of file membership roles, file purge roles, file back-up procedures, and audit procedures. Provide technical advice and coordinate the monitoring and tuning requirements for RDBMS optimization of performance. Analyze database operations to identify bottlenecks and take action to resolve problems and ensure consistency. Manage the flow of data between the various tiers of the architecture. Investigate amount of storage space consumed, access time statistics and frequency of use for a given RDBMS. Review RDBMS accounting information and take action to improve efficiency. Review system documentation, users manuals and training guides. Develop local state modifications to these documents to fit local operating procedures and to include instructions relative to locally developed supplemental applications. Provide training on implementation, including classroom instruction and Computer Based Training (CBT) development. Troubleshoot 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. Test new DBMS software and implement updates and changes. Ensure resolution of DBMS inconsistencies across the installation in coordination with other information technology specialists and systems administers. Develop system backup and recovery plans assigned RDBMS applications. Make recommendations on alternatives involving major projects. Analyze DBMS inconsistencies with other system administrators and devise recovery plans for failure resolution. Resolve a wide variety of system problems, which are caused by data errors, operator errors, hardware malfunctions and program errors. Trace and isolate causes of problems in hardware and software. Provide technical assistance to personnel involved in developing system design, programming, specifications and adapting commercially available software. Participate in the analysis of requests for new and modified applications. Determine equipment demands, number and kind of records, required files, data communication needs, procedures needed to obtain and organize information, and interfaces with other systems. Identify relationships, sequences and search strategies to be used. Provide DBMS maintenance of a data dictionary, listing the kinds of data in databases and how to access them. Coordinate and integrates data elements for a variety of projects in a number of dissimilar areas. Perform other duties as assigned. Military Grades:
SSG - 1LT Compatible Military Assignments:
OBR:
25 EMOS:
25 GENERAL
Experience:
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. SPECIALIZED
Experience:
Must have at least 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.
Estimated Salary: $20 to $28 per hour based on qualifications.
Provide 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. Using software-engineering techniques, design new applications that enhance existing systems. Closely coordinate with the applications' owning agency personnel to ensure NGB and state compatibility and to recommend priorities for systems development and implementation. Responsible for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS. Review and implement security provisions to ensure authorized access and integrity of the RDBMS. Ensure the application of information security/information assurance policies, principles, and practices in the conduct and oversight of RDBMS, policy, and planning functions. Implement the policy for the use of the data and any access constraints applying to exclusive or shared file usage (in which system deadlock might occur). Develop and review the administration of file membership roles, file purge roles, file back-up procedures, and audit procedures. Provide technical advice and coordinate the monitoring and tuning requirements for RDBMS optimization of performance. Analyze database operations to identify bottlenecks and take action to resolve problems and ensure consistency. Manage the flow of data between the various tiers of the architecture. Investigate amount of storage space consumed, access time statistics and frequency of use for a given RDBMS. Review RDBMS accounting information and take action to improve efficiency. Review system documentation, users manuals and training guides. Develop local state modifications to these documents to fit local operating procedures and to include instructions relative to locally developed supplemental applications. Provide training on implementation, including classroom instruction and Computer Based Training (CBT) development. Troubleshoot 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. Test new DBMS software and implement updates and changes. Ensure resolution of DBMS inconsistencies across the installation in coordination with other information technology specialists and systems administers. Develop system backup and recovery plans assigned RDBMS applications. Make recommendations on alternatives involving major projects. Analyze DBMS inconsistencies with other system administrators and devise recovery plans for failure resolution. Resolve a wide variety of system problems, which are caused by data errors, operator errors, hardware malfunctions and program errors. Trace and isolate causes of problems in hardware and software. Provide technical assistance to personnel involved in developing system design, programming, specifications and adapting commercially available software. Participate in the analysis of requests for new and modified applications. Determine equipment demands, number and kind of records, required files, data communication needs, procedures needed to obtain and organize information, and interfaces with other systems. Identify relationships, sequences and search strategies to be used. Provide DBMS maintenance of a data dictionary, listing the kinds of data in databases and how to access them. Coordinate and integrates data elements for a variety of projects in a number of dissimilar areas. Perform other duties as assigned. Military Grades:
SSG - 1LT Compatible Military Assignments:
OBR:
25 EMOS:
25 GENERAL
Experience:
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. SPECIALIZED
Experience:
Must have at least 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.
- Department:
2210 Information Technology Management - Salary Range:
$67,437 to $87,667 per year
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
