Transportation Database Administrator 1 - Kanawha County

West Virginia Department of Transportation•Charleston, WV

2d•Onsite

About The Position

The Transportation Database Administrator 1 performs a full range of database management functions, including creating physical databases, calculating and allocating system storage structures, creating primary objects, and modifying, monitoring, and optimizing database performance as necessary. It is the responsibility of the employee to take the initiative to deviate from traditional methods or technologies when applicable. May supervise and assist in training of other information services staff. An irregular work schedule may be required of this position. Level of complexity involves complex, broad, and extensive problems that may come from both within and outside the organization. Performs other related duties as required.

Requirements

Knowledge of specialized techniques used in the operation or interpretation of results obtained through testing or maintenance operations
Knowledge of database management, database structure and internal security concepts
Knowledge of information processing concepts
Knowledge of project control techniques
Knowledge of SQL, DDL and DML (Data Definition Language and Data Manipulation Language)
Skill in preparing documents used in guidelines, documentation and communicating with various personnel
Ability to load and reorganize database data
Ability to evaluate and analyze application specifications and develop specifications for database implementation and maintenance to meet user requirements
Ability to present ideas in a clear, concise format using narrative statements and logic diagrams
Ability to maintain effective working relationships with information processing personnel and users
Ability to understand complex technical manuals
Associate’s degree from a regionally accredited college, university, or business school.
Two (2) years of full-time or equivalent part-time paid experience in database administration and management work with Universal DB2, ORACLE, INFORMIX, SQL Server, SYBASE, or any other multi-user database management on mainframe, mini, or client/server platforms.
OR Four (4) years of full-time or equivalent part-time paid experience in programming and analysis work using any variety of programming languages; two (2) years of which must be SQL experience and a variety of data storage techniques.

Nice To Haves

Two (2) years of full-time or equivalent part-time paid experience as a database administrator for Universal DB2, ORACLE, INFORMIX, SQL Server, SYBASE, or any other multi-user database management system or mainframe, mini, or client/server platforms may substitute for the required training/education.
Bachelor’s degree from a regionally accredited college or university with a major in computer science or related field may substitute for the required training/education and experience on a year-for-year basis, through an established formula.

Responsibilities

Receives requests from application programmers and analyzes the impact on the database environment
Analyzes entity relationship diagrams and makes recommendations for the applications usage of the database
Develops logical database design from the entity relationship diagrams and designs the physical database from the local design
Creates primary storage structures (tablespaces) after estimating storage requirements for the tables and indexes needed
Creates primary objects (tables, views, indexes) with appropriate parameters for the application, modifying as necessary
Creates synonyms for views and tables
Creates user accounts and maintains system security
Controls and monitors user access to the database
Installs and configures database management system software
Develops and implements the database management system security strategy
Creates and monitors an appropriate development and test environment
Analyzes database and application code for potential or existing performance problems
Implements and maintains a backup and recovery plan
May serve as a supervisory worker over programmers and support staff
Personal contacts may include individuals or groups from outside the Division of Highways or Department of Transportation. Certain meetings or conversations may take place outside of the agency in a somewhat unstructured setting.
Travel may be required; therefore, a valid driver’s license is required.