Positions in this job family are assigned responsibilities involving data bases and system administration. This includes database design, implementation and maintenance, security administration, capacity planning, performance tuning and performance monitoring, job scheduling, data backup and recovery, business continuity planning and testing, installing vendor software products, coordination of and responsibility for system availability, ensuring the integrity, confidentiality and security of information.
The functions within this job family will vary by level and organization, but may include the following:
- Designs and implements on-line data bases, security access systems, data sets and jobs; defines parameters for file or space utilization; establishes direct access files or other file configurations as required; monitors space utilization and makes modifications as needed.
- Create queries, stored procedures, functions and data exports and imports; performs other data management processes utilizing database protocols.
- Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
- Provides applications development and other unit personnel with data base and data security information required to support application development and other activities; supports repository/data base dictionary requirements and activities; develops, implements and monitors control blocks and data definitions to support data bases.
- Installs and modifies vendor software products; conducts appropriate tests to insure compatibility of new or modified programs with operating system requirements; uses data base performance and tuning tools in order to monitor and enhance response times and system performance.
- Confers with computer operations, technical support, user and vendor representatives concerning data base requirements, system performance, software maintenance, capacity planning, and data security requirements.
- Reviews systems specifications for compliance with departmental, division and data base administration standards.
- Responds to data base operational emergencies as required including data base recoveries involving the use of data base log files which provide for the recovery of data bases with no loss of data and which do not require the user to reenter data into the data base.
This job family consists of five levels which are distinguished based on the complexity of the work, the experience required to perform assigned work, and the responsibility for providing leadership to others.
Level I Code: B52A Salary Band: K
This is the basic level of the job family where employees are primarily responsible for beginning level professional work involving the design of less critical databases and/or data security systems, limited to systems supporting a single application or assisting on projects which involve more complex database systems supporting multiple applications. This will also include receiving training in creating queries, creating and working with data extracts, database administration procedures, data base design, data base recovery, data security, capacity planning and other related tasks.
Knowledge, Skills and Abilities required at this level include knowledge of information technology, databases and their operational characteristics; and of data security systems. Ability is required to apply data processing analysis techniques and resolve and prevent data base integrity problems; to establish and maintain effective working relationships with others; and to communicate effectively.
Education and Experience requirements at this level consist of completion of twelve semester hours of information technology course work at an accredited college or university; or a comparable vocational or technical training program of at least 156 hours resulting in certification in database administration; or an equivalent combination of education and experience, substituting one year of experience in information technology for the required education; or a comparable vocational or technical education course resulting in certification in database administration or a bachelor's degree in a comparable vocation or an equivalent combination of education and experience, substituting one year of experience in information technology for the required education.
Level II Code: B52B Salary Band: L
This is the career level of this job family where employees are assigned responsibilities at the full performance level for performing a full range of duties in designing and implementing database and/or data security systems to support various applications and systems operations. Some responsibility may be assigned for providing guidance or training to other employees or serving as a team leader on some projects.
Knowledge, Skills and Abilities required at this level consist of knowledge of information technology; of repository/data dictionary systems; of data security systems; and of database maintenance utilities. Ability is required to apply data processing analysis techniques; to resolve and prevent database integrity problems; to communicate effectively; and to establish and maintain effective working relationships with others.
Education and Experience requirements at this level consist of those identified in Level I plus two years of experience in database design or data security administration.
Level III Code: B52C Salary Band: M
This is the specialist level of this job family where employees are assigned advanced responsibilities for design and maintenance of critical and complex data bases and jobs and the completion of special technical assignments associated with developing data bases and/or data security systems to support various computer applications requirements. This includes positions which are the only Information Systems Data Management position in a data processing division with independent responsibility for all aspects of data base design, maintenance and/or data security. Some responsibilities may be included for providing guidance and training to other programmers or technical personnel in the completion of various applications projects.
Knowledge, Skills and Abilities required at this level include those identified for Level II plus demonstrated ability to perform highly independent work in the design, analysis and maintenance of database and/or data security systems.
Education and Experience requirements at this level consist of those identified in Level II plus two additional years of experience in database design and/or data security administration.
Level IV Code: B52D Salary Band: N
This is the leadership level of this job family where employees are assigned responsibilities involving leadership and supervision of others in developing and maintaining database and/or data security systems to support computer applications and operations. This includes assigning and reviewing work, insuring completion of required work, and providing training and assistance to assigned staff and may include other responsibilities such as performance evaluation, approval of leave, and disciplinary actions.
Knowledge, Skills and Abilities required at this level include those identified in Level III plus knowledge of project management practices and supervisory principles and practices. Ability is required to review and supervise the work of others.
Education and Experience requirements at this level are the same as those identified for Level III plus two additional years of experience in database design or data security administration
Level V Code: B52E Salary Band: O
This is the management level of this job family where employees are assigned responsibilities for managing and directing highly specialized activities and functions involving multiple components of the Information Systems Data Management area. This includes the integration of various related functions across organizational and functional lines. This may include positions which are assistant administrators within a large division in a management information department which is large in size and scope.
Knowledge, Skills and Abilities required at this level include those identified in Level IV plus knowledge of the principles of business and public administration; of documentation standards for information technology; and of planning techniques. Ability is required to coordinate activities and resources within or between units, sections, or divisions and to assess and evaluate the performance of computer operating systems.
Education and Experience requirements at this level consist of those identified in Level IV plus two years of qualifying experience in a supervisory or administrative capacity.