As an Information Technology (IT) Analyst, you will have the opportunity to work both independently and with a cooperative team on complex projects that may span multiple infrastructure components or applications. You will develop your professional network and leadership skills, assisting in the creation and support of IT Solutions that enable Caterpillar success. Further, you will contribute real value by developing, integrating, and/or supporting in-house and purchased applications or infrastructure solutions in order to solve business problems.
Desirable Qualifications: Oracle Database Analyst
Experience in SAP Linux/Unix environments
Work as Oracle RAC DBA and provide operational support for SAP database.
Worked as DB2 database administration and maintenance
Install, Configure, Manage and Monitor Oracle Databases
Performance Optimization, SQL Optimization, Troubleshooting
Data Guard, Backup and Recovery
Scripting and Automation
Performs Oracle database installation, configuration, patching and upgrades in a SOX compliant environment
Configure and optimize AIX/Linux servers to support Oracle databases
Work with application service owners and technical leads to ensure project and service deliverables are met
Responsible for providing database expertise to project teams to maximize system availability, efficiency, and security
Work with development teams and 3rd party vendors throughout the development life cycle regarding optimal use of database resources and features
Assumes ownership of database related problems; pursues problem resolution and root cause analysis.
Responsible for opening, managing, escalating and resolving SRs with Oracle/SAP Support
Will be the subject matter expert on the supported applications and will provide support to the on call DBA
Responsible for validating the backup strategy and performing on demand backups and restores
Proficient Real Application Clusters (RAC) administration
At least 6-8 years of Oracle Database administration experience with Bachelor’s Degree.
The individual must possess strong technical, analytical, problem solving, excellent team interaction, interpersonal and communication skills.
Excellent working knowledge on SAP applications with Linux, Unix and Windows operating systems, for databases Oracle and knowledge on DB2.
AIX/Linux administration experience is a plus
Experience using Oracle Enterprise Manager is a plus
SAP Basis experience is a plus
Experience using SAP HANA/Sybase/Postgres/MySQL is a plus
Knowledge of Remedy preferred but not required
Cab Facility Provided