The System Administrator should have both Technical and functional capabilities in Oracle Application in R12 version in perspective to system administration with following skills but not limited to
Capacity planning performance analysis and tuning (Oracle Database/SQL DB/Oracle EBusiness suite r12.2)
Maintains database by identifying and solving database requirements
Identifies database requirements by interviewing customers; analysing department applications programming and operations; evaluating existing systems and designing proposed systems.
Recommends solutions by defining database physical structure and functional capabilities database security data back-up and recovery specifications.
Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
Supports database functions by designing and coding utilities.
Maintains manpower and technical knowledge by attending educational Servicesshops; reviewing manpower publications; establishing personal netServicess; benchmarking state-of-the-art practices; participating in manpower societies.
Advanced Database Administrator Skills and Qualifications:
Experience with database performance tuning database security promoting process Improvement problem solving presenting technical Information and quality focus.
Advanced database management data maintenance operating systems and attention to detail.
A. Oracle EBusiness Suite (ERP) services:
Install patch and maintain ERP instances.
Clone ERP instances. Refresh test instances with production data.
Monitoring of ERP services.
Access control on ERP instances.
Develop and maintain application recovery run books for EBusiness suite instances.
Backup and restore EBusiness suite instances.
Install patch and maintain WebLogic instances.
Perform maintenance activities using AD utilities.
Performance Tuning.
B. Oracle Database services:
Install patch and maintain Oracle database and RAC instances.
Tablespace and data file management.
Performance Tuning
Backup and recovery.
Scheduled maintenance jobs and automation.
C. MS SQL Server services:
Install patch and maintain MS SQL server standalone and cluster instances.
Log file management
Database backup and recovery
Performance tuning