Oracle ERP DBA 4

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.

Responsibilities

• Quarterly security patching
• System and database upgrades
• Problem resolution and deployments
• Knowledge of Oracle EBS and Oracle database features
• Experience with applications developed using Oracle APEX versions 21and 24 and workflow features
• 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
• Able 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
• Able to create usable technical documentation

Requirements

• Green Card or US Citizen required
• 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
• 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
• Able to create usable technical documentation