Oracle ERP DBA 4

GlobalPoint; Richmond (VA); Hybrid; USD 110,000 - 140,000; Full time

Job summary

A leading IT solutions provider seeks an Oracle Database & System Administrator to manage the DMAS accounting system, supporting Oracle EBS and APEX applications. The role requires expertise in Oracle database administration, emphasizing security patching and upgrades. Candidates must reside within a 2-hour drive of Richmond, VA, as onsite attendance is needed for specific meetings. Green Card or US citizenship is necessary. The position offers remote flexibility and involves some night and weekend work for patching.

Qualifications

• Experience with Oracle E-Business Suite administration.
• Strong understanding of database upgrades and patching.
• Ability to document technical procedures.

Responsibilities

• Support DMAS accounting system and Oracle EBS.
• Manage quarterly security patching and upgrades.
• Resolve database issues promptly.

Skills

Oracle Application database administration version 19

Oracle APEX versions 21 and 24 with workflow

Oracle E-Business Suite R12 in Linux

Oracle database maintenance

SQL & PLSQL

Independent work ability

Strong verbal and written communication

Knowledge of RDBMS principles

Experience with waterfall and agile SDLC

Education

Green Card or US Citizen

Job description

DMAS Oracle ERP DBA 4

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.

Green Card or US Citizen required. 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 21 and 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 R12 running 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.