Qualifications, Experience, Knowledge & Skills
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
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
Troubleshoot with SQLNET and TCP/TP configuration
Adhere to Company Policies, Process & Procedures.
Single sign-on with Active Directory Integration
Fusion middleware .
Must have proven knowledge in computer programming language.
Must have a thorough understanding in systems and data processing policies, practices and procedures.
Must have a thorough understanding in systems analysis and design techniques.
Must have expert knowledge of the systems development life cycle. Demonstrated knowledge of project management concepts and techniques required. Must have familiarity of financial statement preparation, budgeting and financial analysis concepts and techniques.
Must be able to manage a staff responsible one or more components of the systems development life cycle.
Must have the ability manage multiple teams that analyze applications and systems. Must be able to program complex systems requiring minimal interfaces.
Must possess strong problem-solving skills to determine the programming effects on existing systems. Must have strong decision-making skills for problem identification and solution recommendation.
Must possess strong project leadership and management skills.
Must be able to develop, implement and present applications development strategies.
Must have strong written and oral communication skills to prepare and communicate programming plans and procedures as well as to interact with all levels within the company.
Database administration using Oracle latest release
Professional certification (eg OCP) on Oracle latest release (preferred)
Administration of mission-critical production databases, including RAC configuration
Administration and deployment of Oracle Warehouse Builder
SQL, PL/SQL performance tuning, using Oracle Enterprise Manager
Management of database, data warehouse and Oracle Warehouse Builder deployment using formal configuration management tools
Linux / Unix shell scripting (RHEL5 preferred)
ITIL or similar service management methodologies
|Job Location:||Abu Dhabi, United Arab Emirates|
|Company Industry:||Employment Placement Agencies/Recruiting|
|Career Level:||Mid Career|