Oracle ERP - System Administrator

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


Requirements

Bachelor’s degree in engineering / science / commerce / others