Post Job Free

Resume

Sign in

Oracle Apps DBA

Location:
Sudan
Posted:
March 26, 2017

Contact this candidate

Resume:

Yaser Ali elKhider Ali

Oracle e-Business Suite **i / R12 Applications Administrator

8i / 9i / 10g Database Administrator

Oracle Hyperion 11.1.2.1 Administrator

IT Trainer

Email

aczhs6@r.postjobfree.com

Cellular 002***********

009***********

Personal Details

Date Of Birth

10th July, 1979

Nationality

Sudanese

Languages

Arabic (Mother Tongue); English (S/W/R Fluently);

Japanese (S/W/R Beginner);

Summary

Over 9 years of experience in IT implementation, IT project management, Budgeting, and IT Training. Proficient in managing projects, installations, configurations, administration, backup and recovery, performance tuning in three environments: Oracle e-Business Suite 11i/R12, Oracle Hyperion 11.1.2.1 and Oracle OLTP environments. Experienced in Oracle 9i/10g Database Administration on various platforms, installing and configuring Discoverer 10g with Apps 11i, patching, cloning, and performance tuning various Apps components. Proficient in Oracle Metalink troubleshooting and analytical problem-solving. Moreover, strong in Oracle Tools including SQL*Loader, Oracle Enterprise Manger, RMAN…etc.

In addition, migration of data from earlier versions of Oracle, from other databases and other data formats and reengineering the data access through stored procedures, database backups and tuning using utilities like optimizer, auditing and Oracle performance monitor. Collaborative team player with robust abilities to coordinate and communicate with others.

Career Objective

An Interesting position in a progressive organization that offers opportunities for advancement.

Academic Qualifications

Technical Diploma in Japanese Language and Literature from the College of Business and Communication (Kawasaki, Japan)

2013 – 2014

BBI Honors (Bachelors of Business Administration in Information Systems)

University of Lincolnshire and Humberside, UK.

1997 – 2000

Awarded the High School Certificate in Science after successfully completing the 12 year UAE Ministry of Education High School Programme (Zayed Al-Awwal High School – AlAin)

1996 – 1997

Professional Qualifications

Oracle11i e-Business Suite Applications Administrator Certified Professional

Oracle10g DBA Certified Professional

Oralce10g DBA Certified Associate

Oracle9i DBA Certified Associate

Oracle 6/6i Developer Certified Professional

Oracle PL/SQL Developer Certified Associate

Oracle Approved Trainer

CIW (Certified Internet Webmaster) Master Designer.

CIW (Certified Internet Webmaster) Certified Instructor.

MCP (Certified Microsoft Professional) educated.

Expertise

Oracle e-Business Suite 11i / 12 installation, configuration, administration, and patching.

Oracle Hyperion 11.1.2.1 Installation, configuration, administration, and patching.

IBM Cognos 8 BI Administration v8.4

Managing oracle projects.

Oracle Database (9iRAC/10gRAC) Installation, configuration, Administration, monitoring, troubleshooting and optimizing database for ensuring high performance.

MS SQL server 2005/2008 Administration

Installing and configuring Discoverer 10g with Apps 11i.

Unix Solaris 5.10 (SPARC-64bit), Unix AIX, HP UNIX (TRU64), Redhat Linux 4, and Microsoft Server 2003.

SQL, PL/SQL programming; and Oracle Forms and Reports (6i/9i/10g), and unix shell scripting

Software design and development, networking and internet technologies.

Skills

Worked on latest releases of Oracle e-Business Suite, Oracle Hyperion, database, application server, and discoverer while implementing the best practice.

Configuring 10g Application server with 11i/12, using SSL in DMZ setup, and multi domain URLs.

Experience in defining/analyzing ERDs, Data models and physical database design

Relation management skills with customers, partners and internal groups.

Ability to understand, communicate, and coordinate with all internal disciplines including Project Management, technical staff, senior management, finance, legal, procurement and human resources, or externals disciplines including subcontractors and customers.

Technical ability to learn and understand products

Self-driven, results-oriented with a positive outlook, and a clear focus on high quality and business profit.

Oracle Metalink Troubleshooting and analytical problem-solving skills

Strong understanding of Oracle e-Business Suite structures, theories, principles, and practices.

Strong understanding of Oracle Hyperion application structures, theories, principles, and practices.

Strong understanding of database structures, theories, principles, and practices.

Scripting and automating repetitive administrative skills

Capable of working in teams under demanding circumstances

Ability to manage teams in-line with complex deadlines.

Excellent English and Arabic mastery, and very interested in learing new languages as well.

Ability to relocate.

Career Progress ( Experience )

November 2009 – May 2013 Senior Oracle e-Business Suite R12 Apps DBA and

Oracle Hyperion 11.1.2 Administrator

Abu Dhabi Gas Industries Ltd. (GASCO)

Apps DBA Job Duties:

Daily health checkup for all Oracle and SQL server databases, as well as the EBS and Hyperion applications.

Making sure that all scheduled backups has completed successfully.

Perform and manage Oracle EBS 11i/12 Post Production Support.

Regular database administration, backup, and disaster recovery procedures

UNIX support for the Solaris 10, Redhat Linux, and Oracle Linux.

Monitor, troubleshoot and optimize database ensuring high performance

Collaborate with software developers to achieve high performance from their database

Upgrade to new releases and ensure that highest versions are used.

Preparing shell scripts for the daily database and application backups.

Patching, Cloning, Performance Tuning various Apps components including database.

Setting up and managing a dedicated testing environment.

Hyperion Admin Job Duties:

Provide daily end user support.

Perform daily application health and performance checkup before users attending to use the system.

Insuring that the daily scheduled application and database backup was completed successfully without errors.

Perform application changes to entities, accounts, calculations/business rules, and migration of data.

Maintain access and security roles.

Perform application troubleshooting, as necessary for Hyperion Planning and HFM.

Install, build, and configure various Hyperion 11.1.2.x components in a distributed Windows environment including the Hyperion Foundation Services, Reporting and Analysis, Hyperion Planning, Essbase, Web Analysis and Financial Reporting.

Testing support for each of the products, including performance testing, integration testing between interfacing systems, and performance tuning.

Identifying, diagnosing and solving existing system issues.

Create and maintain consistent and thorough documentation of all processes and procedures for supported hyperion applications.

Maintain applications change/update and software upgrades.

Creating scripts for automating the daily backups for the application, essbase, and the RDBMS.

December 2006 – July 2009 Oracle e-Business Suite 11i / R12 Apps Admin and DBA

Dubai Holding – GroupIT, Dubai

Job Duties:

Working on live projects managing large databases

Classify key business processes and elements involved in project management, costing, billing, procurement, inventory management, and extentions.

Working closely with vendors’ teams as well as monitoring them for quality implementation of projects Suite modules, and reviewing the documents deliverable submitted by implementation vendor team during the handover process; and Scheduling in-house training courses for users and IT members on need basis.

Perform and manage Oracle EBS 11i/12 Post Production Support.

Installation of Oracle Real Application Clusters RAC

Monitor, troubleshoot and optimize database ensuring high performance

Creation of Oracle standby database and failover databases, and installing and configuring advanced replication.

Installation of the Multi-threaded server, Installation and configuration of printers

Implementing KEEP and RECYCLE pools, and building self-tuning database mechanisms.

Control user accesses and assign authority to all system users, and analyzing and deploying large databases.

UNIX support for AIX, HP/UX, Solaris 10, and Redhat Linux.

Regular database administration, backup, and disaster recovery procedures

Set-up and installation of backup and recovery software

Oracle disk architecture and disk load balancing, Oracle SQL Tuning, and Oracle design reviews.

Collaborate with software developers to achieve high performance from their database

Upgrade to new releases and ensure that highest versions are used.

Collaborate with vendors on implementing new solutions that requires database such as Maximo.

Installing and configuring Discoverer 10g with Apps 11i.

Implementing Disaster Recovery solution for apps using Maximum Availability Architecture.

Patching, Cloning, Performance Tuning various Apps components including database.

Monitoring Oracle Applications database including Forms, Web, Reports,

Setting up and managing a dedicated testing environment.

Configuring and Supporting Apps with multi Node RAC and multiple middle tier for High Availability.

Softwares used : Oracle e-Business Suite 11i/R12, Oracle RDBMS 9i/10g, Oracle Discoverer 10g, Data Masker, Toad 7.6, X-Manager, Putty, and MS SQL Server.

February 2003 – June 2006 Oracle Database Administrator and Faculty member

Al-Khawarizmi International College, Abu-Dhabi

Job Profile:

Installation, upgrading, database design and creation, configuration, administration, backup and recovery, performance tuning of ORACLE in both Data warehousing and OLTP environments. Migration of data from older versions and from other formats. Database auditing and working towards implementing highest security standards for running databases. Writing PL/SQL code for various batch processes, stored procedures and triggers to automate tuning and monitoring. Prepare and implement backup strategies. Associated with the development of in-house projects such as document management, client management, time resource management.

Software used : Oracle 8i/9i/10g

May 2001 – February 2003 Oracle Developer and Faculty member

AlKhawarizmi International College, Abu-Dhabi

Job Profile:

Module leader, Database design and Performance tuning, Front-end designand development, Oracle Reports, SQL, PL/ SQL coding, implementation and Training at site in Abu-Dhabi.

Software used: Oracle8i, Developer 6i Forms and Reports.

IT Proficiency

Applications : Oralce e-Business Suite 11i / 12, Oracle Hyperion 11.1.2.1, and Cognos BI 8.4.

Database : Oracle (9i/10g), SQL server 2005/2008

Application Server: Oracle 10g AS

Tools: EM, RMAN, SQL Loader etc.

Front End : Developer 6i Forms.

Reports : Developer 6i Reports.

OS : Windows 98/ME/XP/Server 2003, Unix Solaris 5.10 (SPARC-64bit), Unix AIX, HP UNIX, Shell Scripting.

Programming Languages : C, C++, SQL, PL/SQL, Visual Basic, Visual C++.

Web technologies : VBscript, JavaScript, ASP, XML, HTML,WebServers, and Apatche

Networking: TCP/IP, Microsoft Networking setup, and fundamentals of Cisco.

Fundamental Projects Associated

Upgrade of Maximo Oracle Database from 10.2.0.3 – 10.2.0.6

Abu Dhabi Gas Industries Ltd

Technical lead for the Oracle Hyperion 11.1.2.1 project implementation

Abu Dhabi Gas Industries Ltd

Upgrading Oracle e-Business Suite 11i to 12 RUP 4

Dubai Holding – Group IT

IBM Document Management System

Dubai Holding – Group IT

Upgrading Oracle e-Business Suite database to 10gR2 RAC

Dubai Holding – Group IT

Oracle e-Business Suite – Testing Envionment Sanitization

Dubai Holding – Group IT

IBM Portal REVAMP

Dubai Holding – Group IT

Primavera P6

Dubai Holding – Group IT

Maximo Enterprise Asset Management

Dubai Holding – Group IT

Hyperion Financial Management

Dubai Holding – Group IT

Bea SOA (Service-Oriented Architecture)

Dubai Holding – Group IT

Document Management System- In House Project

Al-Khawarizmi International College

Time Resource Management Software - In House Project

Al-Khawarizmi International College

Details to be firnished upon request.

References

Furnished promptly upon request.



Contact this candidate