Job Description :
Oracle Applications Database Administrator
Location:-San Diego, CA
Duration:-6+Months
Overview:
This Oracle Applications Database Administrator will join an experienced and customer driven operations team that manages, maintains and enhances production, development, and test database systems in a 24x7 mission critical environment.
We are looking for a highly motivated self-starter Oracle Applications Database Administrator professional. Desired candidate must have excellent interpersonal, communication, problem solving and analytical skills. In addition, this individual will be expected to perform at an extremely high level with little learning curve and must thrive under pressure while enjoying working in a team environment.
Essential Duties and Responsibilities:
Be able to provide all levels of application database support and off-hours support on a rotating basis.
Able to discuss (within own area of expertise) requirements with customers, and to challenge and clarify when appropriate. From the requirements, able to develop a high level design or plan, and then estimate the amount of effort required to deliver on time and budget.
Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
Works collaboratively with other teams including Project Managers, Developers, and Architects to ensure project success.
Ability to work with a team to provide written responses to technical proposals and /or reports/documentation for delivery.
Excellent professionalism, communication, and interpersonal skills
Ability to communicate proactively to management any potential issues that may hinder the ability to meet project deadlines.
Provide leadership to peers, management, and customers in relation to data engineering principles, technologies, methods and best practices across a broad spectrum of DE disciplines.
Oracle 11g or higher DBA certification is highly desirable.
Oracle Application DBA Knowledge and Skills Desired:
6+ years of professional Database Administration experience and a Bachelor of Arts/Science or equivalent degree in Computer Science or related area of study. Without a degree, three additional years of relevant professional experience (9+ years in total
Recent experience in managing development, test and production Oracle E-Business Suite R12 environments.
Must be well versed in cloning and patching application and databases.
Must have expert knowledge of concurrent managers.
Must be skilled in sysadmin activities such as user administration responsibilities, request groups, registering forms, printer setup, register custom applications, etc.
Manage, monitor and configuring workflow.
Creating database users and maintaining password rights.
Experience with upgrades, migrations and patch management of Oracle E-Business Suite environments (Database and Application Server
Oracle DBA Knowledge and Skills Required:
Experience in the installation, configuration and maintenance of the Oracle Database and Oracle Data Integrator including documenting all custom settings and configurations necessary for proper operations.
Well versed monitoring databases using OEM and custom scripts.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools;
Experience with backups, restores and recovery models including RMAN, hot and cold backups.
Experience setting up and configuring Oracle 11g/12c ASM, Oracle RAC, Grid Control, and Partitioning.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Oracle
Experience in implementing operational automation using scripts;
Knowledge of indexes, index management, and statistics;
Database lock, space management, export and import of the database, performance tuning at DB and apps level.
SQL and relational DBMS knowledge, including data modeling and ERD.
Work with leadership to research, define, interpret, and analyze complex, unstructured technical database problems and recommend solutions, and implement them.
Must have good troubleshooting skills.
Extensive PL/SQL and UNIX shell scripting skills.
DBA support in WINTEL, UNIX, HP-UX, and Linux operating environments.
Additional Desired Skills:
WebLogic
SOA
SQL Server
Java (JDeveloper, J2EE, Apache)
Oracle Application Server