Database Administrator I

State of Delaware•Dover, DE

12h

About The Position

This position is responsible for the management of the Division-wide Forensic Laboratory Information Management System (FLIMS). Work includes installing, configuring and upgrading database system software, developing physical database designs, database performance and tuning, security, backup, version control and integrity of the database. 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.

Requirements

Six months 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.
Six months 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.
Knowledge of data resource management which includes systems analysis, design, and implementation.

Responsibilities

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.