Designs, monitors, supports, and maintains databases of moderate to advanced complexity.
This class is intended for use as a senior level role that designs and supports database management systems (DBMS) of medium complexity and assists in the design and support of DBMS of high complexity.
Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s). Designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Plays a lead role in the development and design of database and warehouse applications across multiple platforms and computing environments. Plays a lead role in the development of an overall data architecture that supports the information needs of the business in a flexible but secure environment. Develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Assists in developing long term strategic plans.
Moderate to complex knowledge of database management systems, concepts and design methodologies. Knowledge of database structures, operating systems, data security, systems integrity and monitoring and auditing activities. Ability to integrate technical systems with agency goals and objectives. Ability to prepare and present technical and nontechnical reports in a clear and concise manner. Ability to establish positive working relationships with technical staff, customers and others involved in database management. Ability to manage subordinate technical staff in the design and support of database management systems.
A bachelor's degree in computer science, information systems or a related field and experience in systems development and maintenance, technical support or the support of complex database management systems. Related experience may be substituted for the bachelor's degree on a year-for-year basis.