Transportation Database Administrator 1 - Kanawha County

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.


Pay Grade 18

• 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

• 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

REQUIRED TRAINING/EDUCATION 

• Associate’s degree from a regionally accredited college, university, or business school
• Substitution: Two (2) years of 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.  

• 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.

• 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. 
• Substitution: Bachelor’s degree from a regionally accredited college or university with a major in computer science or related field may be substituted for the required training/education and experience.