Transportation Database Administrator 1 - Kanawha County

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

Do you have a valid Driver’s License license?, Do you have experience in Database server management?, Do you have a Associate’s degree?, * 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

Minimum Requirements

REQUIRED TRAINING/EDUCATION

• Associate’s degree from a regionally accredited college, university, or business school.
• Substitution: 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., * 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 substitute for the required training/education and experience on a year-for-year basis, through an established formula.

Pulled from the full job description

• Tuition reimbursement
• Military leave
• Employee discount
• Vision insurance
• Dental insurance
• Paid sick time
• Paid military leave, $54,250.14 - $79,449.97 Annually