• Capacity planning for hardware and software in the configuration and implementation
• Installation/Upgrading and Cloning.
• Advised management on long-term strategy, planning, and implementation of new releases of Oracle and related System Software
• Estimating Database size growth (Database Size Management), Estimating File System Growth (Physical Space Management), Estimating OS requirement to handle all Application components
• Knowledge of Application Modules Set-up and Implementation, complete Knowledge of system Admin Modules (FND, AD, APPLSYS, ICX..etc.)
• Installation/Upgrading and Cloning:
• Installing Oracle Application in multi-node architecture
• Building Multiple Test Instance using Oracle Application Cloning Process and Cloning Oracle application/Database
• Up-grading Oracle Application and Database to latest patch level using Maintenance Patch
• Installing 3rd party tools (Back-up Software, Monitor Software, Version Control Software and more)
• Installing Developer 6i, Workflow Builder and other Development tools on Developer machines.
• Maintaining Custom Interface to migrate Data in Oracle Application from other system
• Backups and Disaster Recovery: Implementing Comprehensive Backup/Restore mechanism and data replication, implemented Maximum Availability Architecture (MAA) using oracle Failsafe/RAC (Real Application Cluster) and Disaster Recovery (DR) using Standby DB mechanism, Configuration of Recovery Manager (RMAN) for Online Backup
• Security: Maintaining security system on Application level, Database level as well as Operating system Level, Implemented user and network security and auditing in Oracle Application.
• Optimization/Performance Tuning: Performance tuning & monitoring of the Oracle Application, Database and Unix kernel parameters, Database Space Management and Pinning Objects analyzing Schema, Optimizing Table and Index Partitioning, Troubleshooting Oracle Application Performance/Tuning Issues.
• SQL/Unix Shell Scripting: Shell scripts for automatic startup and shutdown of Databases as well as automated backups, session waits and locks and snapshot refreshes and load multiple data files.
• Automated daily Database, Application, and System health monitor with some kind of notification
• Regular Maintenance Activities:
• Performing DBA activities such as Security Management, Space Management, User and Responsibility set-up, Performance Tuning & Monitoring, Concurrent Manager Monitor, defining printers, and setup Oracle Alerts/Auditing
• Managing Oracle Applications Security, User and Data Auditing
• Managing Concurrent Programs and Reports, Maintaining User, System and Custom Profiles
• Troubleshoot with Oracle Applications Tech Stack including Up-gradation/configuration of HTTP Server (Apache), Jserver, Developer 6i (Forms server and Reports Server), Concurrent Manager, Jinitiator, OA Framework, JDK, XML, and JRE.
• Set-up Oracle Application Support Diagnostic Test Utility for AOL.
• Used Time Saving Techniques for Applications Patching, Activities include backup, SGA tuning, SQL tuning, Apps patches, and database refreshes
• Periodically refreshed Oracle databases and Applications, for business reasons
• Applying and Reviewing oracle application Patches
• Configured the Workflow Notification Mailer in Oracle Applications
• Knowledge of Application Debugging and Tracing, Assist/support the development and end user team (PL/SQL Tuning)
• Work closely with Oracle Support/Development Team (AOL, ASCP, and OM), Responsible for 24/7 Production/Testing Instances Support Job DetailsDate Posted: | 2016-03-22 | Job Location: | Abu Dhabi, United Arab Emirates | Job Role: | Technology/IT | Company Industry: | Information Technology | Monthly Salary: | US $5,000 |
Preferred CandidateApply Now - Jobs in UAE - Jobs in Abu Dhabi, United Arab Emirates - Jobs in Dubai, United Arab Emirates - Technology/IT Jobs in UAE - Search All Jobs |
