State of Maryland

A Database Specialist II is the full performance level of work designing, developing, implementing, maintaining and controlling database management systems for computers.  Employees in this classification do not supervise other positions.

Employees in this classification receive general supervision from a Database Specialist Supervisor or other administrator.  Employees may be required to work evenings, weekends and holidays and may be subject to call-in.

Positions in this classification are evaluated by using the classification job evaluation methodology.  The use of this method involves comparing the assigned duties and responsibilities of a position to the job criteria found in the Nature of Work and Examples of Work sections of the class specification.

The Database Specialist I and Database Specialist II are differentiated on the basis of degree of supervisory control exercised by the supervisor over these employees.  The Database Specialist I performs duties under close supervision at times and under general supervision at other times depending on the complexity of the specific duty being performed while the Database Specialist II performs the full range of duties and responsibilities under general supervision.  The Database Specialist II is differentiated from the Database Specialist Supervisor in that the Database Specialist Supervisor has supervisory responsibility for lower-level Database Specialists.

Defines databases including defining user requirements, developing data definitions, data flow diagrams and maintaining the data dictionary;

Develops logical and physical database designs and ensures appropriate modifications to the design models or schema;

Establishes initializing procedures and data element naming conventions;

Coordinates the installation and implementation of database management system software and related software tools with vendors, other information technology staff and systems users;

Maintains security and integrity of data by specifying access policies, standards, methods and parameters, by developing standards for applications programs, by establishing recovery plans to minimize data loss and system downtime and by performing back up routines for the database management system software and for the stored data;

Monitors database performance and makes modifications and adjustments to database architecture, storage methods and management system software to fine tune the database for optimum response time;

Monitors capacity and allocates space according to overall needs of system users, available data storage and database management system requirements;

Trains IT Programmer Analysts and system users on techniques for efficient use of database management systems;

Troubleshoots problems related to availability of data to system users, space, data base software, data flow, information storage, or data access;

Coordinates the database management system interfaces with other information technology units;

Evaluates technical information and makes recommendations to management regarding procedures, software and hardware for managing databases;

Prepares long and short range plans for feasibility of conversion to database management systems from existing file structures;

Reviews technical literature and attends workshops, seminars and training classes to keep abreast of the latest developments in database management systems and related information technology;

Performs other related duties.

Class Descriptions are broad descriptions covering groups of positions used by various State departments and agencies.  Position descriptions maintained by the using department or agency specifically address the essential job functions of each position.

Class Descriptions provide information about the Nature of Work, Examples of Work, General Requirements and Acknowledgements.  The Required Knowledge, Skills, and Abilities; Minimum Education and Experience Requirements; Special Requirements; and recruitment and testing procedures are set by the using agency.

This is a Skilled Service classification in the State Personnel Management System.  All positions in this classification are Skilled Service positions.  Some positions in Skilled Service classifications may be designated Special Appointment in accordance with the State Personnel and Pensions Article, Section 6-405, Annotated Code of Maryland.

This classification is not assigned to a bargaining unit, as indicated by the designation of S (Supervisor), M (Manager), T (Agency Head), U (Board or Commission Member), W (Student), X (Used by Agency or Excluded by Executive Order), or Z (Confidential).  As provided by State Personnel and Pensions Article, Section 3-102, special appointment, temporary, contractual, supervisory, managerial and confidential employees are excluded collective bargaining.  Additionally, certain executive branch agencies are exempt from collective bargaining and all positions in those agencies are excluded from collective bargaining.

This classification is one level in a Non-Competitive Promotion (NCP) series.  NCP promotions are promotions by which employees may advance in grade and class level from trainee to full performance level in a classification series.  In order to be non-competitively promoted to the next level in a NCP series, an employee must: 1) perform the main purpose of the class, as defined by the Nature of Work section of the class specification; 2) receive the type of supervision defined in the class specification and 3) meet the minimum qualifications of the classification.