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