Talent.com
Oracle E-Business Database Administrator

Oracle E-Business Database Administrator

DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Oracle E-Business Database Administrator

Location : Philadelphia, PA (Remote)

Contract Duration : 6+ MONTHS

Description :

  • The resource(s) covered under this SO will support the System Lifespan Assessment – Oracle eBusiness Suite Upgrade version 12.2.
  • This project will encompass planning for the upgrade of the Oracle E-Business System (EBS) from version 12.1 to version 12.2 for the City's customer information and water billing system.
  • The water billing system uses the basis2 application, which is built on an Oracle EBS foundation.
  • This effort will include developing a comprehensive project plan to upgrade the EBS software along with defining and planning any associated changes to the basis2 application.

Position overview / Statement of Work

  • The Office of Innovation and Technology and Department of Revenue IT unit are seeking an experienced Oracle E-Business Suite (EBS) DBA to lead the planning of an upgrade from Oracle EBS 12.1 to 12.2. The ideal candidate will have deep expertise in Oracle Database Administration, EBS architecture, and upgrade methodologies.
  • This role involves analyzing the existing environment, the ability to clone the system with standard EBS tool and designing an upgrade strategy that will ensure post-upgrade stability and performance optimization.

    • Key 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.

    • Work activities and Essential Functions :

  • Pre-Upgrade Planning & Assessment
  • 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.

    • Environment Preparation & Cloning

  • 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 12.2 requirements.
  • Define required patches to prepare for the upgrade.
  • Define a test plan to prepare for the upgrade.
  • Plan the components of executing the Upgrade Process

    • 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.
  • Plan Post-Upgrade Validation & Optimization to include but not limited to :
  • 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.

    • Required Skills & Experience :

  • 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.

    • Highly Desired / 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
  • Soft Skills & Other Requirements :
  • 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.
  • Certification in Oracle DBA or EBS is a plus.
    • serp_jobs.job_alerts.create_a_job

    Database Administrator • Philadelphia, PA, Pennsylvania, USA

    Job_description.internal_linking.related_jobs
    Senior Database Administrator II

    Senior Database Administrator II

    CGSPhiladelphia, Pennsylvania, United States, 19102
    serp_jobs.job_card.full_time
    Senior Database Administrator II.Employment Type : Full-Time, Mid Level.Department : Information Technology.Contact Government Services is seeking a Senior Database Administrator to assist with admin...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Data Storage Administrator - Cloud Architect

    Senior Data Storage Administrator - Cloud Architect

    EHS TECHNOLOGIES CORPORATIONPhiladelphia, PA, US
    serp_jobs.job_card.full_time
    Seven (7) years’ experience in software engineering or IT systems architecture, of which three (3) years must demonstrate experience as a Cloud Engineer / Architect with.Azure or AWS, developin...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Discovery Database Administrator (DBA) (Top Secret Clearance Required)

    Discovery Database Administrator (DBA) (Top Secret Clearance Required)

    CGSPhiladelphia, Pennsylvania, United States, 19102
    serp_jobs.job_card.full_time
    Discovery Database Administrator (DBA).Employment Type : Full-Time, Executive-Level.CGS is seeking a dedicated Discovery Database Administrator to join a fast-paced and hard-working team to assist w...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle Developer

    Oracle Developer

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle Developer, Enterprisewide Applications.Key Responsibilities Lead a five-year implementation project for the Oracle EBS suite across multiple locations Mentor j...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Business Systems Analyst II

    Business Systems Analyst II

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for a Business Systems Analyst II - SDLC Quality Control (Remote).Key Responsibilities Perform quality control reviews to ensure compliance with Bank standards Analyze trend...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Oracle Database Developer

    Oracle Database Developer

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle Database Developer to join their database migration and optimization team.Key Responsibilities : Lead complex Oracle database migrations from legacy systems to m...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Senior Database Administrator

    Senior Database Administrator

    EHS TECHNOLOGIES CORPORATIONPhiladelphia, PA, US
    serp_jobs.job_card.full_time
    Bachelor’s degree in computer science, information technology, or an equivalent technical degree from.Ten (10) years’ experience administering databases. MUST have one of the following c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Oracle Architect

    Oracle Architect

    Signature ConsultantsUSA, Texas, NJ
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Jersey City, NJ OR Dallas, TX OR Tampa, FL (Hybrid Role).Seeking an Oracle Architect to lead data integration and analytics strategies across Oracle platforms. This hands-on role supports Finance an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Oracle Cloud Order Management Consultant

    Oracle Cloud Order Management Consultant

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle Cloud Order Management Consultant.Key Responsibilities Configure and optimize Order Management flows for recurring and one-time products Collaborate closely wi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Jr. Database Administrator- Secret Clearance

    Jr. Database Administrator- Secret Clearance

    Enterprise Horizon Consulting GroupPhiladelphia, PA, US
    serp_jobs.job_card.full_time
    Enterprise Horizon Consulting Group (EHCG) is a Woman-Owned Small Business specializing in IT Consulting which has successfully delivered key capabilities to the Navy, Army, and NASA over the past ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Lead Data Architect

    Lead Data Architect

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for a Lead Data Architect.Key Responsibilities : Lead and implement major projects while supporting other projects within the software domain Define and drive technical visio...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

    Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

    CGSPhiladelphia, Pennsylvania, United States, 19102
    serp_jobs.job_card.full_time
    Senior Discovery Database Administrator (DBA).Employment Type : Full-Time, Executive-Level.CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced and hard-working te...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    PostgreSQL Database Developer

    PostgreSQL Database Developer

    CGSPhiladelphia, Pennsylvania, United States, 19102
    serp_jobs.job_card.full_time
    Employment Type : Full Time, Experienced level.Department : Information Technology.CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Busi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Medical Device Sales – Paid Internship

    Medical Device Sales – Paid Internship

    Medical Sales CollegeSwedesboro, New Jersey, US
    serp_jobs.job_card.internship
    Description Medical Device Sales - Paid Internship Looking for a rewarding and lucrative career in the medical sales industry? Our paid Internship may be the right path for you! Here are just some ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Database Architect SME

    Database Architect SME

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Architect, SME.Key Responsibilities Collaborate with stakeholders to design scalable database solutions based on business requirements Implement database stan...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Business Applications Analyst

    Business Applications Analyst

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    Key Responsibilities Provide daily support for over 20 Desktop Applications in the Business Processing Outsourcing organization Facilitate communication between BPO, remote clients, and Data Cen...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Oracle OAC Consultant

    Oracle OAC Consultant

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle Cloud OAC and Data Warehouse Consultant.Key Responsibilities Design and develop dashboards and reports using Oracle OAC Optimize and manage data pipelines and ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Earn At Least $2120 For Your First 184 Trips, Guaranteed.

    Earn At Least $2120 For Your First 184 Trips, Guaranteed.

    UberTrainer, PA, United States
    serp_jobs.job_card.full_time +1
    Earn at least $2120 driving with Uber when you complete your first 184 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours