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. Use 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. Responsible for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS. Review and implements 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 coordinates the monitoring and tuning requirements for RDBMS optimization of performance. Analyze database operations to identify bottlenecks and takes 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 relational database management systems (RDBMS). Review RDBMS accounting information and takes action to improve efficiency. Review system documentation, user 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 implements 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 devises 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. Each applicant must fully substantiate (in her/his own words) that they meet the requirements of the specialized experience listed below; otherwise, the applicant will be considered unqualified for this vacancy. DO NOT COPY THE VACANCY ANNOUNCEMENT OR THE POSITION DESCRIPTION. IF YOU DO THIS YOU WILL BE CONSIDERED UNQUALIFIED FOR THE VACANCY. Please ensure that you have included beginning and ending dates (month and year) for all jobs listed on your resume. Military Grades:
E6 - O2 Compatible Military Assignments:
OBR:
25 OAC:
53 ECMF:
25 General
Experience:
Must have 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. Use 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. Responsible for the management of quality assurance and system efficiency functions of assigned RDBMS systems by enforcing the prescribed RDBMS. Review and implements 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 coordinates the monitoring and tuning requirements for RDBMS optimization of performance. Analyze database operations to identify bottlenecks and takes 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 relational database management systems (RDBMS). Review RDBMS accounting information and takes action to improve efficiency. Review system documentation, user 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 implements 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 devises 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. Each applicant must fully substantiate (in her/his own words) that they meet the requirements of the specialized experience listed below; otherwise, the applicant will be considered unqualified for this vacancy. DO NOT COPY THE VACANCY ANNOUNCEMENT OR THE POSITION DESCRIPTION. IF YOU DO THIS YOU WILL BE CONSIDERED UNQUALIFIED FOR THE VACANCY. Please ensure that you have included beginning and ending dates (month and year) for all jobs listed on your resume. Military Grades:
E6 - O2 Compatible Military Assignments:
OBR:
25 OAC:
53 ECMF:
25 General
Experience:
Must have 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.
|
|
 | |
