Database Administrator - Oracle (EBS)

Career Area: Technology, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other.  We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.

The Database Administrator is responsible for ensuring the stability, security, availability, and performance of the Oracle E-Business Suite (EBS) 12.2 platform running on Oracle Database 19c, supporting business continuity through the comprehensive administration of applications, databases, middleware, and the associated technology infrastructure.

Hands-on Oracle EBS (E-Business Suite) Applications 12.2 and Oracle database 19c. Support Oracle EBS on 19c database with multitenant architecture. Manage RHEL OS (Red Hat Enterprise Linux Operating System) virtualized environment. Support EBS environment cloning. Implement and administrate TLS (Transport Layer Security) 1.2 certificates for Oracle EBS for end-to-end encryption for all backend (behind the load balancer) services in an Oracle EBS deployment. Work on WebLogic/Fusion Middleware administration. Administrate ORDS (Oracle REST Data Services) and Oracle ECC (Enterprise Command Centre). Handle Oracle Apex (Application Express), Bash scripting and automation. Manage EBS full stack security patching. Configure, administrate and register OAM (Oracle Access Manager) and OID (Oracle Internet Directory) for single EBS sign-on. Design HA (highly available) architectures and DR (disaster recovery) plans. Manage Data Guard setup and administration. Handle Rubrik backup and configuration. Manage Oracle Database performance with tuning Full knowledge of Oracle RAC (Real Application Cluster) technology with ability to administer and support. Handle Oracle ASM (Automatic Storage Management) and OEM (Oracle Enterprise Manager). Mentor others to enhance their technical competence and its application to achieve more effective technical solutions. Coach others in promoting, defining, analyzing, and providing superior technical solutions to business problems. Provides effective solutions to moderate technical challenges through strong technical competence, effectively examining implications of events and issues.

Requirements This position requires a bachelor’s degree or foreign equivalent in Information Technology, Computer Engineering, Mechanical Engineering, or a related field Advanced English-speaking level is required. Must have skills Systems Software Infrastructure Knowledge of computer architecture and system software interaction; ability to design and build fundamental architecture of operating systems, database management systems, communications protocols, compilers and other development tools. Oracle EBS (E-Business Suite) Applications 12.2 for general application support Supporting Oracle EBS on Oracle 19c or 26ai database with multitenant architecture RHEL OS (Red Hat Enterprise Linux) virtualized environment EBS environment cloning for general support and awareness of EBS technology stack ADOP (Application DBA Online Patching) cycle in EBS EBS full stack security patching Configuring, administering, and registering OAM (Oracle Access Manager) and OID (Oracle Internet Directory) Implementing and administering TLS 1.2 certificates for Oracle EBS WebLogic / Fusion Middleware administration Administering ORDS (Oracle REST Data Services) and Oracle ECC (Enterprise Command Center) Knowledge of creating and managing cloud computing systems consisting of hardware, virtualization, storage, and networking components Technical Excellence Oracle EBS Application support Oracle 19c or 26ai administration EBS