ERP Analyst (Data Base Administrator) – Sundus Recruitment and Outsourcing Services – Dubai, United Arab Emirates


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 Details

Posted Date: 2020-07-26
Job Location: Abu Dhabi, United Arab Emirates
Job Role: Management
Company Industry: Employment Placement Agencies/Recruiting

Preferred Candidate

Career Level: Mid Career

Apply Now

Share This Post

Post Comment