DMAS Oracle ERP DBA 4
IN PERSON IVs ONLY
Must live within 2 hours drive of Richmond due to on site requirements
*Must be within 2 hrs drive of Richmond VA. Although majority of work will be remote, they must be close enough to drive in for occasional ON SITE meetings and special events when required.
* or . Agency is not able to provide sponsorship. ABOUT THE ROLE Oracle Database & System Administrator to support the DMAS accounting system, Oracle EBS (GL, AP, AR) and the 25 Oracle APEX applications and the underlying Oracle Databases. This includes quarterly security patching, system and database upgrades, problem resolution and deployments. This role requires knowledge of Oracle EBS and Oracle database features. Experience with applications developed using Oracle APEX versions 21and 24 and workflow features. This position may require some night and weekend work due to patching.
Experience with Oracle Application database administration version 19
Experience with Oracle APEX versions 21 and 24 with workflow
Experience with deploying changes for APEX applications
Experience with Oracle E-Business Suite R12running in Linux environment
Oracle E-Business Suite (EBS) System Administration
Oracle database upgrade experience
Experience with Windows and Linux OS
Experience with Oracle database maintenance, patching/upgrades, creating Oracle service requests, resolving issues promptly
Experience with the Oracle database job scheduler
Strong understanding of RDBMS principles, Oracle database related best practices and good understanding of software development life cycle
Ability to work independently, effectively communicate with team members, and provide accurate and realistic effort estimates
Strong verbal and written communication skills
Experience with SQL, PLSQL
Experience with Unified Auditing is a plus
Experience with writing scripts to perform routine data loads
Some experience with designing Oracle solutions and software development
Experience with migrating Oracle EBS and databases from on-prem Private Cloud Appliance (PCA) servers to Oracle Cloud Infrastructure
Experience with waterfall and agile SDLC methodologies
Ability to create usable technical documentation.
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
| Oracle Application database administration version 19 | Required | 5 | Years |
| Experience with Oracle APEX versions 21 and 24 with workflow | Required | 5 | Years |
| Experience with Oracle E-Business Suite R12 running in Linux environment | Required | 5 | Years |
| Oracle database upgrade experience | Required | 5 | Years |
| Oracle E-Business Suite (EBS) System Administration | Required | 5 | Years |
| Experience with Windows and Linux OS | Required | 5 | Years |
| Experience with Oracle database maintenance, patching/upgrades, creating Oracle service requests, resolving issues promptly | Required | 5 | Years |
| Experience with the Oracle database job scheduler | Required | 5 | Years |
| Strong understanding of RDBMS principles, Oracle database related best practices | Required | 5 | Years |
| Demonstrated the ability to work independently, effectively communicate with team members, and provide accurate and realistic effort estimates | Required | 5 | Years |
| Strong verbal and written communication skills | Required | 5 | Years |
| Ability to create clear and usable technical and non-technical documentation. | Required | 5 | Years |
| Experience with writing scripts to perform routine data loads | Required | 5 | Years |
| Experience with SQL, PLSQL | Required | 5 | Years |
| A good understanding of software development life cycle and experience with waterfall and/or agile SDLC methodologies | Required | 5 | Years |
| Experience with deploying changes for APEX applications | Desired | 5 | Years |
| Some experience with designing Oracle solutions and software development | Desired | 5 | Years |
| Experience with migrating Oracle EBS, APEX Applications and databases from on-prem Private Cloud Appliance (PCA) servers to Cloud | Desired | 5 | Years |
| Experience with Unified Auditing is a plus | Nice to have | 2 | Years |
| Experience within healthcare environment | Nice to have | 0 | |
Questions
| No. | Question |
| Question1 | Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment? |
| Question2 | Please list candidate's email address. |
| Question3 | In what city and state does your candidate permanently reside? Local Richmond candidates preferred bc of on site requirements. If your candidate is local to Richmond, have you (vendor) taken the necessary steps to verify this residency? NO NEED TO UPLOAD Drivers License - just simply confirm here. |
| Question4 | If candidate is not local to Richmond, they must be within 2 hours driving distance to Richmond and willing to come to the office for meetings and special events. (NO EXCEPTIONS). If selected, does your candidate agree to this arrangement? |
| Question5 | required. Agency does not have ability to sponsor. Pls confirm if your candidate meets this requirement. |
| Question6 | If selected, must be willing to come ON SITE for an IN PERSON interview. Please confirm your candidate is aware and will come on site for an interview. If an interview is requested and they are not able to come IN PERSON, they will be removed form consideration. |
| Question7 | This position may require some night and weekend work due to patching. Please confirm your candidate is aware and agrees to the arrangement if requested. |