Installation, configuration, maintenance, troubleshooting and Upgrade of Oracle Applications R12.x.
Performing health checks, assessments and creating reports for Oracle Database and Applications in terms of configuration, performance & security.
Establish and maintain backup and recovery policies and procedures Implement and maintain database security (create and maintain users and roles, assign privileges).
Work as part of a team and provide 24 7 support if required.
Perform general technical trouble shooting and give consultation to development teams.
Interface with Oracle Corporation for technical support.
Patch Management and Version Control.
Perform performance tuning across different layers OS, Database, Applications.
Cloning Oracle Applications from Production to Test environments.
Essential Requirements :
Strong Knowledge in the implementation, configuration, maintenance, troubleshooting and Upgrade of Oracle Database and Oracle Applications.
Strong Experience in installing, configuring, upgrading and administering different versions of Oracle Database
Strong experience working as an Oracle Applications DBA in 12.x versions.
Good Conceptual knowledge of Oracle Application R12.1 & R12.2 architecture and technology stack differences
Good Conceptual knowledge of Oracle RDBMS internals, Backup & Recovery using RMAN, performance tuning, logical and physical design of database
Additional Requirements :
Good Knowledge in different OS platforms (Linux, Solaris, IBM(UIX), Windows)
Exposure to RAC and ASM Administration.
Good knowledge of PL / SQL.
Basic software networking skills.
Basic Shell Scripting Skills.
Experience from 3 to 4 years.
Other Qualifications :
Good English written / verbal communications.
Self-motivated individual who works well in a team environment.
Willingness to work in shifts & weekends as required.
Self-driven, ability to work under minimal supervision.