Oracle Apps DBA

Job Description

We are currently looking for Oracle Apps DBA for our UAE operations with the following skillset and terms & conditions.Job PurposeThe role holder is responsible for managing the operational delivery of Oracle E-Business Suite application & databasesExperience:Oracle Solution engineer with dependable application of the acquired experience in? Oracle EBS (R12.2.x) : Application upgrades, patching, performance fine tuning, securing the environment, sizing the environment for the business growth, Disaster recovery experience, regular clones, working with various monitoring tools. 24X7 Oracle SR, exposure to multimode mission critical environment would be added advantage? Oracle Database (19c onwards): database upgrades, RAC configurations, evaluating PSU updates and preparing Patch analysis, utilizing the advanced Features such as partitioning, compression, and data encryption etc. exposure to shell scripting in Unix environment will be added advantage.? Oracle WebLogic Server: Monitor, identify and handle the stuck thread situations, PSU patching , fine-tuning the WLS time-out thresholds and memory structures to get optimal/ reliable performance? Architecture: Design the data flow, propose the suitable components for the integrations with justifications.Prepare technology road map including upgrade/decommission process with various technical components in order to sustain the vendor support contracts.? Capacity Planning: Capture the business requirements, review the existing resource utilizations and prepare the forecast for the resources with evidences and justifications.? Project Management: Demonstrate the skills with preparation of project plan , factors consider at various stages of the project, proposing the times lines and collaborative efforts with involved resourcesMiscellaneous: In addition to extensive subject knowledge, we anticipate the applicant?s zeal to learn new technologies to solve the technical issues around his scope of work. The applicant?s attitude to take the ownership of the situation, share and participate in team?s common goal willJob Accountability? Installation, configuration and upgrading of Oracle EBS application and DB servers on difference operating systems like AIX and Linux.? Perform Oracle DB upgrades.? Perform Oracle EBS and DB upgrades? High skills in managing configuring and troubleshooting application servers.? High skills in managing configuring and troubleshooting DB servers and DB clusters.? Cloning of ERP applications using Manual and Rapid Clone methods for development and test purposes.? Patching and managing E-Business application/ database with Adadmin, Adpatch, Opatch and Autoconfig? Planning and Managing Backup and Recovery, Logical/Export Backups, Cold Backups, Hot Backup, RMAN Backups, Full and Incremental Backups? Create RMAN Scheduler Jobs for Incremental hot backups of 24/7 11g Database? Monitor disk & table space alerts, database wait events, hang analysis, locks using EM Grid control.? Create, Manage, and administer database objects, including tables, indexes, views, sequences, functions, packages, and procedures provided by development team.? Troubleshoot problems with Concurrent Managers.? Creating the Users and groups in the O/S. Creating the NFS mounts in the system.? Configuring, administering, and troubleshooting standby (logical/physical) databases environment in single DB instance and RAC/ASM environments.? Troubleshooting different performance issues? Hang analysis & Cluster eviction issues? SQL Tuning with different methodologies, SQL Profiles, and SQL restructure? Gather Statistics with different strategies based on workload and business? Database Tuning, Memory Tuning, Backup Tuning & Data Pump TuningDatabase Resource Manager (DBRM).QualificationBachelor?s degree in Computer Science / Information Technology or equivalentCertifications? Relevant certification in application management such as Information Technology Service Management (ITSM/ITIL) or equivalent? Relevant certification in database management such as Microsoft Certified Database Administrator (MCDBA) or equivalentSkill Set? 6 years of relevant experience in managing application and database operations? Knowledge of technical troubleshooting? Very good skills as Solution Architect? Very good Understanding of System Development Lifecycle? Expert knowledge of various Database systems like Oracle, SQL, mangoDb etc? Very good Knowledge of programming languages, such as Java, C++, Python and Perl? Very good Knowledge of configuration tests for application products? Excellent debugging and optimisation skills? Excellent planning and organizing skills? Ability to multi-task and work under tight deadline? Strong analytical skills? Fluent written and spoken English essential, Arabic preferredTerms and conditionsJoining time frame: 2 weeks (maximum 1 month)Additional InformationTerms and conditions:Joining time frame: maximum 4 weeks

Keyskills :