Job Description :
"Core Tasks :
Infrastructure capacity planning for Project / application platform project DBs
Database design and deployment.
Database Performance Tuning for platform projects.
Implement Backup and recovery strategy for databases.
SQL Performance Tuning during SDLC
Carry out in-depth technical problem analysis and resolution for Oracle databases
Data model review, deployment and migration for each subject area/workstream.
Prepare the upgrade plan for Databases, and upgrade platform DBs to latest version.
Database cloning and Refresh
Participate in SIT/UAT and production rollout of each project.
Work with Support teams to troubleshoot production issues.
Implement database Engineering standards and ensure compliance.
Identify and implement Oracle database process improvements.
Apps Role :
Knowledge of Golden gate is helpful.
Installation, configuration and upgrading of Oracle server software and related products.
Starting and Stopping the application
Monitoring the application related products like oacore, oafm apache etc.
Bouncing apache, oacore, oafm if needed
Establish and maintain backup and recovery policies and procedures.
Implement and maintain database security (create and maintain users and roles, assign privileges
Interface with Oracle Corporation for technical support."