Jobs Description
Total Years of Experience: 7-8 years Relevant years of Experience: 6-7 years Mandatory Skills for screening: a) Strong knowledge on Oracle eBS. b) Strong communication Skills to adapt in Agile Development Environment. Detailed Job Description a) Installation, upgrades, and managed services experience in Application (R12.1 and R12.2) and Database (11g, 12c) b) Must be well versed with AD utilities c) Cloning database and application d) Patching applications (Ad patch, ADOP), R12.2 WebLogic and databases (Opatch) e) Must have knowledge about concurrent managers f) Maintenance of database and application log files using standard concurrent programs g) Must be skilled in sysadmin activities like user administration responsibilities, request groups, register forms, printer setup, register custom applications, etc. h) Manage, monitor and configuring workflow i) Must have knowledge on R12.2 WebLogic monitoring and administration (OACORE, OAFM) j) Creating database users and maintaining password rights. Changing application user password. k) Backup and recovery l) Expertise in RMAN, hot and cold backups m) Monitoring database using OEM and custom scripts n) Database lock, space management, export and import of the database, performance analysis at DB and apps Level o) Must have good troubleshooting skills p) Knowledge of traces, tkprof and find poorly performing SQL,SQL Profiling, rewrite poorly performing SQL. q) Knowledge of oracle database wait events, Database and Application parameters r) Monitoring the Dr performance for maintaining the synch with prod s) Maintaining and establishing DB links between oracle to non- oracle t) OBIEE 11G/12c (BIP) installation, configuration, and patching. Threshold Band - 7A.RTH-Y.