Senior Application Oracle Database Administrator at SUNSHINE ENTERPRISE USA LLC

Charleston, West Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

03 Jul, 26

Salary

0.0

Posted On

05 Apr, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Database Administration, PL/SQL, SQL Optimization, UNIX/LINUX Shell Scripting, Data Modeling, Oracle RMAN, Oracle Warehouse Builder, Fine-grain access control, Database cloning, ETL processes, Performance tuning, Database security, Technical leadership, Connectivity management, System maintenance

Industry

Wholesale

Description

Job Title: Senior Application Oracle Database Administrator Location: West Virginia Department of Transportation (WVDOT) Employment Type: Temporary / Contract (IT Staffing Services) About the Role 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. Key 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 Requirements Required Qualifications 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 Preferred Skills (Not Required but a Plus) 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

The Senior Application Oracle Database Administrator will maintain, manage, and optimize Oracle database systems to ensure high availability and security. They will also provide technical leadership and assist programming staff with PL/SQL debugging and SQL optimization.