Abacus Service Corporation ยท 5 months ago
Oracle E-Business Database Administrator Consultant
Philadelphia, PA
Full-time
Hybrid
Mid, Senior Level
$100K/yr - $100K/yr
7+ years expAbacus Service Corporation is seeking an experienced Oracle E-Business Database Administrator Consultant to lead the planning of an upgrade from Oracle EBS 12.1 to 12.2. The role involves developing a comprehensive project plan for the upgrade, analyzing the existing environment, and ensuring post-upgrade stability and performance optimization.
Health CareInformation Technology
Responsibilities
Develop a comprehensive upgrade plan for Oracle EBS from 12.1 to the latest subversion of 12.2, including risk assessment and rollback strategies
Perform technical analysis, impact assessment, and design pre-upgrade validation to ensure a smooth transition
Determine impact to basis2 customer information/water billing system and factor into upgrade plan
Plan installation and configuration of Oracle EBS 12.2, including WebLogic, Fusion Middleware, and Online Patching (ADOP)
Define optimization of the Oracle Database (if required) in alignment with EBS 12.2 compatibility
In collaboration with the Basis2 custom module's vendor, define code customizations and retrofitting as needed to ensure compatibility with 12.2
Design cloning, backup, and recovery processes to safeguard data during the upgrade
Create plan for troubleshooting and resolving performance, patching, and configuration issues post- upgrade
Work closely with functional consultants, developers, and business users to develop a comprehensive plan that ensures minimal disruption to business operations. The plan to include detailed technical choices (source constraints, target Database, target Operating System) and a feasibility assessment thereof
Conduct training and documentation for internal teams on new features and best practices
Conduct a system assessment to analyze the existing EBS 12.1 architecture, including database, application tier, and customizations
Evaluate system compatibility with EBS 12.2, including database versions, third-party software (including basis2 water billing system), and hardware
Perform a custom code impact analysis of basis2
Identify deprecated features, unsupported objects, and necessary modifications
Develop an upgrade strategy, including timelines, rollback plans, and resource requirements
Define test environments (development, test, and UAT) required for the upgrade process
Create plan for cloning of the production EBS 12.1 environment to create a sandbox for dry runs
Create plan for upgrading the database to a certified version (e.g., Oracle Database 19c) as per EBS requirements
Define required patches to prepare for the upgrade
Define a test plan to prepare for the upgrade
Follow Oracle's 12.2 upgrade roadmap, including:
Running Rapid Install for 12.2
Applying Release Update Pack (RUP) patches
Enabling Online Patching (ADOP framework)
Execute data migration scripts and update metadata as required
Verify integrity of concurrent manager processes, workflow mailers, and business-critical integrations
Work with developers to define how to retrofit and remediate customizations impacted by the new architecture
Conduct thorough functional and performance testing to ensure system stability
Optimize database and application performance, including SQL tuning, indexing, and JVM tuning
Validate patching functionality using Oracle's AD Online Patching (ADOP) feature
Perform cutover planning and execution for the final upgrade to production
Provide end-user support, documentation, and knowledge transfer to stakeholders
Qualification
Required
7+ years of hands-on experience as an Oracle EBS DBA with expertise in versions 12.1 and 12.2 on the WINDOWS Server Operating System
Strong knowledge of Oracle Database (11g, 12c, 19c), including RMAN, Data Guard, and performance tuning
Experience with Oracle EBS 12.2 upgrade processes, including ADOP (Online Patching), WebLogic, and Fusion Middleware
Proficiency in cloning, backup/recovery, patching, and migration of EBS environments
Strong knowledge of Windows environments, scripting, and automation
Hands-on experience with Oracle Applications DBA (AD utilities, AutoConfig, ADOP, rapid clone, etc.)
Experience in customization impact assessment, and code remediation
Understanding of Oracle Security, Concurrent Processing, and Application Tier Architecture
Ability to lead and execute complex upgrade projects with minimal supervision
Strong problem-solving and troubleshooting skills
Excellent communication skills to collaborate with cross-functional teams
Ability to work in high-pressure, dynamic environments with tight deadlines
Preferred
Experience with Oracle performance monitoring, tuning, and optimization
Ability to provide technical guidance to business and executive audiences in clear, concise, understandable, and actionable terms
Certification in Oracle DBA or EBS is a plus
Company
Abacus Service Corporation
Abacus Service Corporation is provides IT solutions for global health care businesses.
201-500 employees
H1B Sponsorship
Abacus Service Corporation has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2023 (2)
2022 (2)
2021 (4)
2020 (4)
Funding
Current Stage
Growth StageLeadership Team
S
Sam Akunuri
Founder and COO
Company data provided by crunchbase