Title: Oracle Cloud Engineer (Database / Web Administrator)

State Role Title: Information Technology Specialists III

Hiring Range: $105,000 - $135,000

Pay Band: 6

Agency: Virginia Department of Health

Location: Dept of Health

Agency Website: https://www.vdh.virginia.gov/

Recruitment Type: General Public - G

Job Duties

The Database/Web Administrator serves as a consultant, assisting with the review of
various databases and application servers, such as WebLogic, Apex, ORDS, and DB.
Works with VITA to perform application and database upgrades and to resolve
network, storage, and app server issues. Maintains regulatory audit documentation
and ensures vulnerability fixes with ISOs. Collaborates with small teams,
development, CM, QA, ISOs, and other staff to ensure the core functionalities are
performed. May work additional weekend hours to perform upgrades and patches to
maintain servers.

Minimum Qualifications

* Oracle DBA: Considerable experience administering Oracle databases in a Linux environment.
* Apex/ORDS Expertise: Solid experience managing and supporting Apex (preferably v19 or higher) and ORDS (preferably v18 or higher).
* Linux Administration: Strong understanding of Linux administration for supporting Oracle databases and application servers (WebLogic, Fusion Middleware, OHS, Reports).
* Scripting and Automation: Hands-on experience with shell scripting and job scheduling to automate tasks.
* WebLogic Management: Recent experience setting up, upgrading, and configuring WebLogic 12.2.1.3/12.2.1.4 and Oracle HTTP Server (OHS) 12.2.1.3 on Linux.
* Oracle Database Management (19c+): Extensive experience managing Oracle databases using multi-tenant architecture (CDB/PDB), backups/restores, PL/SQL, OEM, RMAN, Data Guard, and handling production environments.
* Apex and ORDS Deployment: Hands-on experience setting up Oracle Apex (v19+) and ORDS (v18+) on WebLogic, interfacing with OHS to deploy applications.
* Database Upgrades and Patching: Experience performing database upgrades and applying quarterly PSU patches using OEM provisioning tools/fleet maintenance (OEM 13c or higher).
* Data Loading: Expertise in loading data using SQL*Loader and Data Pump utilities.
* Performance Tuning: Expertise in Oracle database performance tuning and SQL optimization.
* Database Character Set Migration: Experience migrating database character sets.
* Enterprise Manager Management: Experience managing and upgrading Oracle Enterprise Manager (v13c or higher).
* Backup and Recovery: Strong experience in backing up and recovering large databases from RMAN online backups.
* Database Security: Working knowledge of tablespace encryption and advanced Oracle security tools.
* Development Tools: Proficiency with SQL Developer/TOAD, Grid Control tools (Designer experience desired).

Additional Considerations

* RESTful Web Services: Experience with RESTful web services.
* Cloud Experience: Proven understanding of cloud environments (OCI/AWS/Azure) and managing large-scale environments on cloud platforms.
* OCI Expertise: Hands-on experience with Oracle Cloud Infrastructure (OCI) and migrating applications from on-premises to OCI.
* AWS Expertise: Strong experience building and managing Oracle Databases using AWS RDS. Knowledge of AWS cloud technologies (RDS, EC2, ELB, S3) with AWS certification preferred.
* Knowledge of printer configuration on application servers, experience customizing Apache FOP for PDF creation, and customizing Apex instances and workspace settings (all desirable).
* Demonstrated knowledge / training in Software applications, engineering, or equivalent experience.
* OCI/ AWS - Developer / DBA

Special Instructions

You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to “Your Application” in your account to check the status of your application for this position.

VDH accepts only on-line applications. Faxed, mailed, or e-mailed applications will not be considered. Applications are accepted until 11:55 p.m. on the job closing date. Applications and/or resumes should include relevant work history which indicates your qualifications for this position

Employment is contingent upon satisfactory results of a state and federal criminal history background check and the Department of Social Service’s Child Abuse and Neglect Central Registry check, U.S. HHSIG Exclusion List check, employment reference check and E-Verify. Other financial, credit, driving, background checks or completion of Statement of Economic Interests may be required for certain positions.

It is the policy of the Commonwealth and VDH that all aspects of human resource management be conducted without regard to race (or traits historically associated with race including hair texture, hair type, and protective hairstyles such as braids, locks, and twists); sex; color; national origin; religion; sexual orientation; gender identity or expression; age; veteran status; political affiliation; disability; genetic information; and pregnancy, childbirth, or related medical conditions. VDH employees have a shared Code of Ethics, which can be found in the bottom banner of our website: www.vdh.virginia.gov.

If you have been affected by DHRM Policy 1.30 layoff and possess a valid Interagency Placement Screening Form (Yellow Card) or a Preferential Hiring Form (Blue Card), you must submit the card before the closing date for this position. The Card may be submitted with the state application as an attachment.

As a V3 (Virginia Values Veterans) employer VDH Welcomes Veterans to apply!

Supplemental Questions: You may be required to respond to position-specific questions at the end of this application. This information will help us evaluate your credentials and qualifications for the job. Failure to respond to any questions may disqualify you from further consideration.

In support of the Commonwealth’s commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their Certificate of Disability (COD) provided by a Vocational Rehabilitation Counselor within the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their Certificate of Disability. If you need to get a Certificate of Disability, use this link: Career Pathways for Individuals with Disabilities, or call DARS at 800-552-5019, or DBVI at 800-622-2155.

Contact Information

Name: Rose Sandra Bose

Phone: 804-998-7871

Email: rose.bose@vdh.virginia.gov

In support of the Commonwealth’s commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at 800-552-5019.

Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.