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.