Description:

Scope:

The Oracle Applications DBA is responsible for maintaining the Oracle E-Business Suite environments within TTM. The successful candidate will work on a team that will support the Global operations (North America and Asia based systems) in a 24 X 7 manufacturing environment. This position reports to the Director of IT – Regional Business Systems. Oracle Applications DBAs spend the majority of their time managing, debugging and fixing issues with the various technology components on the applications tier. The successful candidate will work closely with management, developers, network administrators, and users to resolve critical issues.
Duties and Responsibilities:

Migrate code from Development > Test > Production using a customized migration program

Perform system refreshes based on Oracle Rapid Clone process

Provide support to business analysts & developers when they log Oracle Service Requests.

Manage and monitor performance and functionality issues

Determine Applications upgrade or migrations strategy with business owners

Improve documentation processes

Research, test, apply and track application patches

Debug/Edit and restart multi-step OEM jobs

Manages concurrent manager log , output files and performance

Monitor and track Oracle Applications usage

Define archive / purge strategies for Audit, Workflow and Concurrent Manager tables

Test , audit and document backups and Disaster Recovery processes.

Provide expertise in SQL tuning, Disaster Recover, backup and recovery support, installation and configuration of Oracle software.

Proactively monitor and support the health, performance, and integrity of Oracle based systems.

Perform preventive maintenance functions on the database and application as appropriate

Ensure 24x7 availability and performance of mission critical systems.

Provide on-call support including coordinating and messaging required for maintenance windows

Essential Knowledge and Skills:

Must be able to work independently and possess good written communication skills in both English and Simplified Chinese. 

Experience in support, upgrade and administering Oracle E-Business Suite applications and databases

Knowledge of Oracle Applications Database Administration utilities, patching procedures and cloning techniques.

Strong interpersonal, written, and oral communication skills

Customer service orientated

Ability to be collaborative in a dynamic environment and

Experience working with a global team

EBS Rapid Clone

Fluent in SQL

Fluent in Oracle PL/SQL

Minimum 2 years Oracle EBS on Linux/Unix

Experience working with Change Management processes and tools

Ability to work in a fast paced, dynamic environment, with shifting priorities

Experience navigating the Oracle support organization, creating and working Oracle SR’s to resolution using Oracle Support, database patching, and database upgrades

Understanding of Oracle architecture and tools, including but not limited to :- Oracle Memory/Process Architecture Automated Storage Management [ASM] Networks and how they impact Oracle Server architecture Data Pump Knowledge of RMAN

Oracle Enterprise Manager 12c/13c

Relaxed office environment

Ability to work for long periods of time at your computer and collaborate with the rest of the team. 

Limited travel required

Education and Experience:

BS/MS in Computer Science, Business or related field required

Preference given to Oracle Certified candidates

1-2 years experience with Oracle EBS environments 12 or higher.

Experience with Linux Server Administration

Java

SQL Developer

Oracle RAC

Dataguard

Linux shell scripting

SVN code management

Export Statement: Must comply with TTM Export Control Policies and Procedures and all applicable laws including ITAR, EAR and OFAC. b) Reinforce to all employees the commitment of TTM management to abide by all US Export laws and regulations. c) Understand and follow authorization procedures for bringing foreign visitors into facilities (VAL). d) Support Export Compliance Officers and others in their efforts to ensure compliance with the Corporate Export policies through implementation and enforcement of these procedures, provide training to all facilities and departments and support periodic audits as required. e) Provide feedback to Corporate Export Compliance Office for continuous improvement of procedures and overall Export Compliance program. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability or protected veteran status.