Lead Business Analyst

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 21 and 24 and workflow features
• 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

Requirements

Green Card or US Citizen required. Experience with applications developed using Oracle APEX versions 21 and 24 and workflow. Experience with deploying changes for APEX applications. Experience with Oracle E-Business Suite R12 running in Linux environment. 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.