Salary: $2,086.54 - $3,055.77 BiweeklyLocation : Charleston, WVJob Type: Full-Time PermanentJob Number: DOT25SP026ADivision: West Virginia Department of TransportationDistrict/Subdivision: Information Technology DivisionOpening Date: 10/18/2024Closing Date: 12/31/2024 11:59 PM EasternNature of Work 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 Typical Duties and 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 Required Skills and Knowledge• 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 Education and Experience 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.
REQUIRED EXPERIENCE
- 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.
- 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.
Annual Increment Pay Paid Vacation Paid Holidays Paid Sick Leave Family Medical Leave Leave Donation Program Military Leave Employee Education Reimbursement & Leave Program Flexible Work SchedulesTraining Opportunities Promotion Opportunities Public Employees' Retirement System:
Employees enrolled in PERS Tier 1 contribute 4.5% of their gross salary. The Employer contributes 9%. Employees enrolled in PERS Tier 2 contribute 6.0% of their gross salary. The Employer contributes 9%.Deferred CompensationHealth Insurance Enrollment Additional Coverage Options including Dental, Vision, Flexible Spending Accounts,Disability Insurance and more. Life Insurance Credit Union Employee Discounts