Job Description

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

 

Responsibilities

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.

 

Additional Skills

 

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

Additional Information

Job Type
  • Full Time
  • Full Time

Functional Area

Software Development

Industry

IT-Software/Software Services

Education Required

Not specified

Experience Required

4-9 years

Skills Required

Oracle Certified DBA

Language

English