JOB SUMMARY:

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

• AP, AR, Configurator, Flow Manufacturing, MSCA, EAM, GL, ASCP, OM, Inventory, KanBan, Quality, eSignatures, eRecords, Depot Repair, Logistics, Contracts, Service, Trading Community Architecture, iSupplier, iProcurement, SLM, Procurement, Advanced Pricing, OEM, Costing, BOMs, Routings, Discrete Manufacturing, ECC, 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
• PTC Windchill
• Microsoft SQL Server
• Oracle Linux 7 & 8
• Azure DevOps, Azure Cloud, Ansible and Scripting is an advantage

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.
• Strong knowledge of ADOP, AutoConfig, cloning, AD utilities and patching processes.
• Proficiency in SQL, PL/SQL, shell scripting, and RMAN.
• Experience with Oracle WebLogic Server, Forms/Reports and Workflow administration.
• Understanding of Oracle RAC, Data Guard, and ASM (preferred).
• Excellent problem-solving skills and the ability to work in a team-oriented environment.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 EBS 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.

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 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, Postgres, Azure DevOps and Terraform is an advantage

COMPETENCY/SKILL REQUIREMENTS:

• Ability to work with limited supervision
• Ability to work remotely to resolve issues
• Ability to document and follow procedures
• Knowledge and understanding of Networking and Troubleshooting

SUPERVISORY RESPONSIBILITIES:

• Mentoring of Teammates in similar responsibility.