Application Oracle Database Administrator

SUNSHINE ENTERPRISE USA LLC • Charleston, WV

1d

About The Position

The West Virginia Department of Transportation (WVDOT) is seeking a skilled Application Oracle Database Administrator to join our team on a temporary contract basis. In this role, you will be responsible for the maintenance, management, and optimization of Oracle database systems that support essential WVDOT operations. You will assist programming staff with PL/SQL debugging and ensure high availability and performance of database environments.

Requirements

• Bachelor's degree in Computer Science or a related field from an accredited institution, OR Minimum of three (3) years of equivalent work experience as a direct substitution for the Bachelor's degree
• Minimum of five (5) years of experience with the maintenance and management of Oracle database systems
• Minimum of two (2) years of experience in providing connectivity to an Oracle database
• Minimum of two (2) years providing assistance to programming staff in debugging triggers, procedures, functions, and packages (PL/SQL Code)
• Minimum of two (2) years of experience in optimizing SQL execution for Oracle SQL procedures, functions, packages, and triggers
• Minimum of two (2) years of experience in writing and maintaining UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environment
• Minimum of two (2) years of experience in the utilization of Oracle RMAN backup to include full and incremental backups and cloning a database
• Excellent verbal and written communication skills, with demonstrated ability to work with project managers, business analysts, application analysts, programming staff, and business stakeholders

Nice To Haves

• Experience in transportation or government IT environments
• Oracle certification (e.g., Oracle Certified Associate - DBA)
• Experience with data modeling
• Familiarity with Oracle Warehouse Builder
• Knowledge of fine grain access control in Oracle databases
• Familiarity with public sector database security and compliance standards

Responsibilities

• Maintain and manage Oracle database systems to ensure high availability, performance, and security
• Provide connectivity to Oracle databases for applications and users
• Assist programming staff in debugging triggers, procedures, functions, and packages (PL/SQL code)
• Optimize SQL execution for Oracle SQL procedures, functions, packages, and triggers
• Write and maintain UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environments
• Utilize Oracle RMAN for backup operations, including full and incremental backups and database cloning
• Collaborate with application analysts, project managers, and business stakeholders to support database-related needs
• Produce clear technical documentation and communicate effectively with both technical and non-technical audiences

What This Job Offers

• Career Level: Mid Level
• Number of Employees: 11-50 employees