This class is responsible for performing a full range of database implementation and management functions for enterprise information systems.
Nature and Scope
This class is responsible for database management in support of applications and requires ensuring hardware configurations and network connectivity enables implementation and management of the database software. Work includes installation, configuration and upgrades to the database management system software and hardware. Positions are assigned to an agency's Information Technology section and are responsible for all database management functions for a large agency encompassing enterprise information systems. Positions assigned to this class are responsible for the physical database designs, database performance and tuning, security, backup, version control and integrity of the most complex databases. This class is differentiated from Database Administrator I by the complexity of the database and work performed. Principal contacts are with application developers, software vendors, customers, other state agencies and others outside state government to ensure that the physical design phases of new/revised application requirements are consistent with the database structure and methodology.
Positions have responsibility for centralized database management for a large agency with responsibility for integrating the database management systems across divisions and other state agencies.
Positions assigned to this class perform the principal accountabilities in a database environment employing the most complex database software; for example, Oracle, MS SQL Server, Sybase, DB2, IMS, Informix, and ADABAS; and operate in mainframe or client/server environments using multiple platforms and operating systems.
Essential functions are fundamental, core functions common to all positions in the class series and are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are descriptive and not restrictive, incumbents can complete job duties of similar kind not specifically listed here.
Monitors, coordinates and manages the selection, physical design, development, security, operation, processing, performance and maintenance of relational and/or other database, data storage and retrieval systems.
Coordinates and ensures database management systems interface with other information technology for sharing of data. Meets with customers to determine database requirements.
Develops database standards, documentation, security and authorization procedures.
Develops physical database and data warehouse/data mart designs and ensures appropriate modifications to databases; establishes databases; creates primary database storage structures (tablespaces/files, views and indices) based on estimated storage requirements. Modifies physical database objects/structures to reflect changes to the data model.
Establishes backup and recovery or replication plans to minimize data loss and system downtime.
Monitors and troubleshoots databases for potential or existing performance or security, problems, capacity requirements and makes modifications/adjustments to ensure availability of data.
Installs, monitors, diagnoses and debugs the database system software. Plans for projected software requirements and increased computer capacity relating to database requirements. Prepares plans for feasibility of conversion to database management systems from existing file structures.
Keeps current on new developments and techniques in data storage and database management. Identifies and evaluates the use of new and emerging tools, methods and technologies to improve database management, and data storage. Establishes and maintains contact with vendors and recommends database software and services.
May plan, assign, review and evaluate the work of two or more merit and/or contractual staff involved in database implementation and management.
Knowledge, Skills and Abilities
The intent of the listed knowledge, skills and abilities is to give a general indication of the core requirements for all positions in the class series; therefore, the KSA’s listed are not exhaustive or necessarily inclusive of the requirements of every position in the class.
Knowledge of the principles and practices of designing, developing, implementing, maintaining and controlling database management systems.
Knowledge of database management systems software and hardware configurations and tools.
Knowledge of the concepts, methods and techniques of data planning, data modeling and design.
Knowledge of the concepts, methods and techniques of information system development life cycle methodologies including the integration of application systems in a shared data environment.
Knowledge of project leadership principles and practices.
Knowledge of systems tasks using database management and data dictionary software systems.
Skill in database management, database design and internal security mechanisms.
Skill in database query languages.
Skill in implementing, controlling and evaluating database management systems.
Skill in using diagnostic and performance tools and other software products to maintain established standards for database management systems.
Ability to create, interpret and communicate a data model and to create and implement an efficient physical database design from application specifications.
Ability to predict growth based on application and data usage patterns and implement the necessary database changes to accommodate the growth.
Ability to evaluate and analyze user requests and develop effective plans for database development and maintenance.
Ability to apply data resource management and system analysis principles to the data planning, modeling and design process.
Ability to communicate effectively both orally and in writing.
JOB REQUIREMENTS for Database Administrator II
Applicants must have education, training and/or experience demonstrating competence in each of the following areas:
Six months experience in data resource management which includes systems analysis, design, and implementation.
Three years experience in designing, maintaining, analyzing and implementing database management systems which includes systems performance tuning, maintaining backup/recovery systems, using system tools to identify, correct or refer system issues such as system space management and database integrity.
Three years experience in applying database query languages such as using MS SQL Server, Sybase, DB2, Informix, Oracle, ADABAS, PL/SQL and other Oracle Based Tools.
Six months experience in database security which includes developing internal database security mechanisms and defining user requirements.
Six months experience in managing database management systems which includes installing upgrades, planning for future expansion, systems architecture, systems maintenance and integrating systems across operating units.