At least 10+ years relevant Oracle Apps DBA experience- EBS Expertise in all major versions of Oracle technology stack including Database, iAS, Forms, Reports, Enterprise Manager, WebLogic, Workflow Mailer and JVM
Expertise in SQL tuning and database tuning, Concurrent Manager Tuning
- Hands-on operational expertise as an Oracle Apps DBA, with technology including High Availability (RAC), Dataguard, and Backup/Recovery
- Expertise with Oracle EBS 11i, 12.1, 12.2 including full life-cycle, implementation experience, configuration and administration of the application
- Strong knowledge of underlying Oracle Applications database architecture schemas/products,database objects, file system structure, tables, views, packages, procedures, functions, triggers, sequences, indexes, and constraints.
- Expertise in performance tuning across the entire stack (Database and Application Tier)
- Knowledge of Oracle maintenance/patching mechanics and EBS architecture with adpatch and adop.
- Hands-on operational expertise with UNIX, Linux
- Strong experience with Oracle PL/SQL and Unix shell scripting
- Understand and be able to troubleshoot Oracle Middleware configurations supported by WebLogic Skills
- Expertise in Oracle application and database performance tuning
- Strong knowledge of key application functionality, tables and relationships
- Deep knowledge of Oracle EBS and related Tech Stack configurations and deployments
- Expertise in Oracle Database architectures such as ASM and RAC.
- Knowledge of cloud technologies AWS, GCP, Oracle (OCI) would be an advantage.
- Experience with administration, installation and/or debug of other Oracle Technology components would be an advantage such as WebLogic components, Essbase, Golden Gate would be advantage.
- Oracle EBS SSO integration experience, would be a nice to have
- Should have good communication and documentation skills