Job Description
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 TuningBackup 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 managementDatabase backup and recoveryPerformance tuningRequirements
Bachelor’s degree in engineering / science / commerce / others