Job Description (APPS DBA)
1. Good experience on Oracle Database, EBS application , Fusion middleware, SSL/TLS, SSO with high availability and DR scenarios.
2. DB/EBS installation, configuration, upgrade, maintenance, patching, migration , Decommission and security enforcement.
3. Worked on Oracle Applications upgrade from R12.1.3 to R12.2.10, 11i (11.5.10.2) to R12 (12.1.3), R12.1.1 to R12.1.3.
4. Oracle Real Application Clusters (RAC), Oracle Data Guard, ASM.
5. Impdp/expdp tables, schemas from one database to other.
6. Cloning/refreshing non-prod databases from source.
7. RMAN backups, restores and disaster recovery plan processes and procedures.
8. Database performance analysis and tuning skills at the application and database layers.
9. Skills in analysing  AWR, ADDM, ASH, hang analysis, SQL tracing , wait events.
10. Good understanding of OS and Storage.
11. Basic scripting to automate repetitive tasks and routine administration of databases.
12. Troubleshooting peripheral integration systems from DBA centric activities perspective.
13. Working experience in OCI Cloud.
14. Supports application development projects by leading in the creation of standards and procedures related to database management systems.
15. Maintaining detailed technical documentation.
16. Troubleshoot database problems and implement corrective measures as required.