Senior Application Oracle Database Administrator

SUNSHINE ENTERPRISE USA LLC • Charleston, WV

1d

About The Position

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

Requirements

• Education (one of the following): Bachelor's degree in Computer Science or a related field from an accredited institution, OR Minimum of six (6) years of equivalent work experience as a direct substitution for the Bachelor's degree
• Oracle Database Maintenance & Management: Minimum of ten (10) years of experience with the maintenance and management of Oracle database systems
• Oracle Connectivity: Minimum of five (5) years of experience in providing connectivity to an Oracle database
• PL/SQL Debugging Assistance: Minimum of five (5) years providing assistance to programming staff in debugging triggers, procedures, functions, and packages (PL/SQL Code)
• SQL Optimization: Minimum of five (5) years of experience optimizing SQL execution for Oracle SQL procedures, functions, packages, and triggers
• UNIX/LINUX Shell Scripting: Minimum of five (5) years of experience writing and maintaining UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environment
• Data Modeling: Minimum of five (5) years of experience in Data Modeling
• Oracle RMAN Backup: Minimum of five (5) years of experience in the utilization of Oracle RMAN backup to include full and incremental backups and cloning a database
• Oracle Warehouse Builder: Minimum of two (2) years of experience using and administering Oracle Warehouse Builder
• Fine Grain Access Control: Minimum of two (2) years of experience in fine grain access control in an Oracle database
• Communication Skills: 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 Professional - DBA)
• Experience with Oracle RAC (Real Application Clusters) or Oracle Data Guard
• 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
• Perform data modeling to support application development and database design
• Utilize Oracle RMAN for backup operations, including full and incremental backups and database cloning
• Administer Oracle Warehouse Builder for data integration and ETL processes
• Implement and manage fine-grain access control in Oracle databases
• Collaborate with application analysts, project managers, and business stakeholders to support database-related needs

What This Job Offers

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