Oracle Apps DBA

Found in: Appcast US C2 - 2 weeks ago

Versailles, United States Smart IT Frame LLC Full time

Job Title: Oracle Apps DBA

Location: Versailles, OH (Onsite)

Work Type: Contract


Job Description:-

Designs, specifies, and configures the Oracle database, to ensure it is up and running well by performing activities related to day-to-day administration, monitoring, and maintenance of Client Oracle R12.2 E-Business Suite (applications tier, middle-tier, and database tier). Administers, installs, maintains, develops and implements policies and procedures for ensuring the security, availability and integrity of these environments.

Specific technologies:

  • Oracle E-Business Suite 12.2.X Environment
  • EBS Modules
  • ECC
  • AP
  • AR
  • Configurator
  • Flow Manufacturing
  • MSCA (Mobile Supply Chain App)
  • EAM (Enterprise
  • GL
  • ASCP (Advanced Supply Chain Planning)
  • OM
  • Inventory
  • KanBan
  • Quality
  • eSignatures
  • eRecords
  • Depot Repair
  • Logistics
  • Contracts
  • Service
  • Trading Community Architecture
  • iSupplier
  • iProcurement
  • SLM (Supplier Lifecycle Management)
  • Procurement
  • Advance Pricing
  • OEM
  • Costing
  • BOMs
  • Routings
  • Discrete Manufacturing
  • Process Manufacturing
  • Vertex
  • Gemini
  • QAS
  • Essbase
  • OBIEE
  • EDI
  • Apex
  • Teklynx
  • Disaster Recovery
  • Multiple App Servers
  • Externally Facing Apps Server(s)
  • Oracle Database 19C
  • Oracle Agile
  • Oracle Database Primarily
  • PTC Windchill
  • Oracle Database Primarily
  • Microsoft SQL Server
  • Oracle Linux 7 & 8

ESSENTIAL/PRIMARY DUTIES:

  • Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
  • Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
  • Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
  • Perform day-to-day database administration and performance monitoring tasks
  • Resolves database performance issues, database capacity issues, replication, and other distributed data issues.
  • Ensure availability, performance, security, and operational efficiency.
  • Ensure the recoverability of all production data for operational and business continuity needs
  • Participate in Oracle ERP applications databases systems design and operations
  • Manage and monitor SLAs for uptime and performance of the Oracle production environment.
  • Perform root cause analysis, and resolution, for Oracle incidents
  • Under limited supervision executes the responsibilities of the job and ensures that commitments and deliverables are met.
  • Creates, develops, and reviews the physical data model created from the logical data model. Creates and implements the physical database design and structures.
  • Actively participates in supporting test plans, test environments, benchmarks and statistics.
  • Assist with the development of the technical architectures. Ensures the database management systems and tools support the defined architectures and business needs.
  • Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method).
  • Establishes physical database parameters.
  • Calculates optimum values for database parameters.
  • Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data.
  • Specifies which users can access databases and what data can be accessed by user.
  • Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
  • Modifies database programs to increase processing performance, referred to as performance tuning.

SECONDARY DUTIES:

  • A completed task, not how that task is completed
  • Responsibilities that are needed or desirable for better fulfilment of primary responsibilities
  • Assist in the resolution of complex problems in support of production; including on call support.
  • Perform core database management tasks including software installation, database creation and configuration, upgrades and patching, backup and recovery, space management, partition maintenance, and object reorganization.
  • Communicates clearly, and effectively, with local and remote users.
  • Manage and monitor SLAs for uptime and performance of Oracle Databases
  • Documentation of, and adherence to, all critical processes

EDUCATION and/or EXPERIENCE:

  • Bachelor's degree (B. A.) from four-year college or university; or three to five years related experience and/or training; or equivalent combination of education and experience.
  • Experience in Oracle EBS R12.2 or higher
  • Experience in Oracle 19C or higher
  • Experience with MS SQL Server

COMPETENCY/SKILL REQUIREMENTS:

  • Ability to work with limited supervision
  • Ability to work remotely to resolve issues
  • Ability to document and follow procedures
  • Ability to be on Call 24x7 on a rotational basis
  • Knowledge and understanding of Networking and Troubleshooting

SUPERVISORY RESPONSIBILITIES:

  • Mentoring of Teammates in similar responsibility.