Talent.com
Oracle E-Business Database Administrator Consultant

Oracle E-Business Database Administrator Consultant

Abacus Service CorporationPhiladelphia, PA
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

Position Title : Oracle E-Business Database Administrator Consultant SO Date : July ,

This Service Order ( "SO”) is issued pursuant to Contract ( "Contract”) between the City of Philadelphia ( "City” or "CoP”) and [Vendor Name (blank until selected)] . This Service Order shall automatically terminate upon the earlier of the termination or expiration of the Contract as it may be extended through renewal terms; the specified End Date set forth below; OR when Services have been performed under the SO totaling the Maximum Budget of $, set forth below . Provider is responsible for tracking hours to ensure that the approved number is NOT exceeded. Total hours used and total hours remaining must be reported weekly. The City shall have no obligation to pay for Services under this SO in excess of the Maximum Budget, or for services performed after the termination or expiration of the Contract.

The resource(s) covered under this SO will support the System Lifespan Assessment – Oracle eBusiness Suite Upgrade version This project will encompass planning for the upgrade of the Oracle E-Business System (EBS) from version

  • to version for the City's customer information and water billing system. The water billing system uses the basis 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 basis 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 to 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 to the latest subversion of , including risk assessment and rollback strategies.
  • Perform technical analysis, impact assessment, and design pre-upgrade validation to ensure a smooth transition.
  • Determine impact to basis customer information / water billing system and factor into upgrade plan.
  • Plan installation and configuration of Oracle EBS , including WebLogic, Fusion Middleware, and Online Patching (ADOP).
  • Define optimization of the Oracle Database (if required) in alignment with EBS compatibility.
  • In collaboration with the Basis custom module's vendor, define code customizations and retrofitting as needed to ensure compatibility with
  • 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 architecture, including database, application tier, and customizations. Evaluate system compatibility with EBS , including database versions, third-party software (including basis water billing system), and hardware. Perform a custom code impact analysis of basis. 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 environment to create a sandbox for dry runs. Create plan for upgrading the database to a certified version (, Oracle Database c) as per EBS 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 upgrade roadmap, including : Running Rapid Install for 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.
  • Skills / experience of the assigned staff :

    Required Skills & Experience :

    Technical Skills :

  • years of hands-on experience as an Oracle EBS DBA with expertise in versions and on the WINDOWS Server Operating System
  • Strong knowledge of Oracle Database (g, c, c), including RMAN, Data Guard, and performance tuning.
  • Experience with Oracle EBS 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.
  • Expected duration : Reporting to Project Manager Name (or his / her designee) :

    Months Graham Quinn

    Additional Background and On-Boarding Details Item Response Is this SO for a new position? Yes Is an onsite interview a must or is the hiring manager open to screening over a Skype (or other) video call for out of state candidates? Yes How many interview rounds will be conducted for the position? Is there a chance of extension in the duration of the assignment, beyond the budget / duration included in the SO? No Will the position require the candidate to be onsite completely or there is a possibility of working remotely (partially / completely)? Hybrid Can a vendor suggest a different Resource Title based on the position and budget assigned to that position, if the position requires a niche skill? No

    Services and / or Deliverables shall be subject to acceptance by the City.

    Within days following the completion of Services and / or Deliverables required under this Service Order, the City shall issue its written statement of Acceptance of the Services and / or Deliverables, provided that the Services and / or Deliverables meet all performance standards and criteria set out in this Service Order or elsewhere in the Contract.

    serp_jobs.job_alerts.create_a_job

    Database Administrator • Philadelphia, PA

    Job_description.internal_linking.related_jobs
    Oracle E-Business Database Administrator

    Oracle E-Business Database Administrator

    DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA
    serp_jobs.job_card.full_time
    Calibri,sans-serif"> <...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior SQL Database Administrator

    Senior SQL Database Administrator

    InteProsPhiladelphia, PA, United States
    serp_jobs.job_card.full_time
    Senior SQL Server Database Administrator – Performance Tuning Specialist.We are seeking a highly skilled Senior SQL Server DBA with deep expertise in performance tuning, query optimization, and tro...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Manager IT Analytics Platform and Database

    Manager IT Analytics Platform and Database

    Cooper University Health CareMerchantville, NJ, US
    serp_jobs.job_card.full_time
    IT Analytics Platform & Database Manager.The manager of the IT Analytics Platform & Database will manage operations and ensure efficiency of the analytics platforms including Tableau, MS Fabric and...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    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
    Business Analyst - Enterprise

    Business Analyst - Enterprise

    Apidel TechnologiesTrenton, NJ, US
    serp_jobs.job_card.full_time
    Very Seneior BA experienced with Project development work and / or function / business process analysis.Develop workflows, requirements, QC testing and production support for projects.Experience workin...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Database Administrator

    Database Administrator

    ASB ResourcesTrenton, NJ, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Client is looking for a mid-level SQL Server DBA consultant with experience in SQL Server database administration, clustering, always on availability groups, server management, backup & restore...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    SQL Server Database Administrator

    SQL Server Database Administrator

    EnvestnetBerwyn, PA, US
    serp_jobs.job_card.full_time
    SQL Server Database Administrator.This is a hybrid role, with in-office work required at our Berwyn, PA office location.Envestnet is transforming the way financial advice is delivered through its c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Lead Data Architect (AWS, Azure, GCP)

    Lead Data Architect (AWS, Azure, GCP)

    CapTech ConsultingPhiladelphia, PA, US
    serp_jobs.job_card.full_time
    CapTech is an award-winning consulting firm that collaborates with clients to achieve what’s possible through the power of technology. At CapTech, we’re passionate about the work we do a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • 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
    Senior SQL Database Administrator (Philadelphia)

    Senior SQL Database Administrator (Philadelphia)

    InteProsPhiladelphia, PA, US
    serp_jobs.job_card.part_time
    Senior SQL Server Database Administrator Performance Tuning Specialist.We are seeking a highly skilled Senior SQL Server DBA with deep expertise in performance tuning, query optimization, and trou...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    Oracle E-Business Suite DBA

    Oracle E-Business Suite DBA

    QED NationalUSA, Pennsylvania, Philadelphia
    serp_jobs.job_card.full_time
    Job Title : Oracle E-Business Suite DBA.Location : Philadelphia PA (100% Onsite).Rate : $50 to $65 / hour on W2 (Based on experience). Develop a comprehensive upgrade plan for Oracle EBS 12.Perform tech...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Database Administrator

    Database Administrator

    RICEFW Technologies IncTrenton, NJ, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    NJOIT is looking for a Mid-Level SQL Server Migration DBA to support planning, execution, and validation of database migrations with practical experience in SQL Server administration / migration tool...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Architect (AWS, Azure, GCP)

    Data Architect (AWS, Azure, GCP)

    CapTech ConsultingPhiladelphia, PA, US
    serp_jobs.job_card.full_time
    CapTech is a team of master builders, creators, and problem solvers who help clients grow efficient, successful businesses. We unite diverse skills and perspectives to transform how data, systems, a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior SQL Server Database Administrator (Hybrid)

    Senior SQL Server Database Administrator (Hybrid)

    Serigor Inc.Philadelphia, PA, US
    serp_jobs.job_card.full_time
    Senior SQL Server Database Administrator (Hybrid).We are seeking a highly skilled Senior SQL Server Database Administrator to join our dynamic IT team. This role is critical to ensure the performanc...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Pharmacovigilance Systems Database Administrator

    Pharmacovigilance Systems Database Administrator

    SystimmunePrinceton, NJ, US
    serp_jobs.job_card.full_time
    We are seeking a technically proficient and detail-oriented Safety Database Administrator to support our global pharmacovigilance (PV) operations. This role is critical to ensuring the integrity, se...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    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_30
    PostgreSQL Database Administrator

    PostgreSQL Database Administrator

    EnvestnetBerwyn, PA, US
    serp_jobs.job_card.full_time
    PostgreSQL Database Administrator.This is a hybrid role, with in-office work required at our Berwyn, PA office location.Envestnet is transforming the way financial advice is delivered through its c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Database Specialist

    Database Specialist

    TradeJobsWorkForce08075 Riverside, NJ, US
    serp_jobs.job_card.full_time
    Database Specialist Job Duties : Plans database upgrades by maintaining , evaluating, and improving a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Sr. Consultant

    Sr. Consultant

    Robert HalfHammonton, NJ, US
    serp_jobs.job_card.full_time
    We are looking for an experienced Sr.Consultant to join our team in Hammonton, New Jersey.In this role, you will lead complex Oracle Cloud implementation programs, manage cross-functional teams, an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    NJOIT Database Administrator

    NJOIT Database Administrator

    Software Technology IncTrenton, NJ, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    MsoNormal" style="tab-stops : 153.NJOIT is looking for a Mid-Level SQL Server Migration DBA to support planning, execution, and validation of database migrations with practical experience i...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days