Overview
The System Administrator should have both Technical and functional capabilities in Oracle Application in R12 version in perspective to system administration with the following skills but not limited to :
Responsibilities & Duties
- 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.
- 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.
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.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.MS SQL Server services
Install patch and maintain MS SQL server standalone and cluster instances.Log file management.Database backup and recovery.Performance tuning.Requirements
Bachelor’s degree in engineering / science / commerce / others#J-18808-Ljbffr