Oracle Application DBA
Resume:
Oracle Apps DBA/DBA Abdul Gaffar
**********@*****.***
Synopsis
Oracle certified DBA with 6+ years of experience in Oracle Apps and Core Environment including Application Setup, High Availability Database Design in RAC and E-Business suite installation, cloning, Adpatch, Opatch, upgradation in Supply chain, Banking, Telcom, Retail and Government organizations.
Skills & Experience
Oracle Server Installations / Upgrades, Space Management, Backup & Recovery, Disaster Recovery, Database, Application Tuning, Patching and Security Administration.
Support, maintenance and administration of Production and Development Oracle Application Release 11.5.10.2 & Release 12.1.1, 12.1.2, 12.1.3, 12.2.
Installation, Upgrade and Maintenance of Oracle e-Business Suite.
Utilities like ADPATCH, ADADMIN, ADCTRL, ADSPLICE, ADLICMGR, ADRELINK, ADIDEN, ADOP.
Cloning of Oracle application instance with Rapid Clone.
Establish and maintain sound backup and recovery policies and procedures. Setup, maintain documentation and standards.
Responsibilities include Installation of Oracle E-Business Suit on UNIX /Linux/Solaris servers platforms.
Configuration of Oracle Enterprise Manager.
Performing Backup and Recovery administration for Oracle Database including Hot and Cold Backup. (Using OS, RMAN).
Performing Logical Backup (Full, User, and Table) and Bulk loads (using Data Pump).
Administrating through Oracle Enterprise Manager (OEM).
Maintenance of archive redo log files.
Adding the required User Logins, Groups and Users. Granting and Revoking Permission to/from the users.
Upgraded the Oracle Application R12.1.1 to R12.1.3
User creation with appropriate roles attached, routine backups, and regular restores 2
Provide Technical Support to Application Support Group.
Identifying Performance issues & applying best practices to overcome them.
Advanced UNIX and Windows Skills.
Raising SR and provide assistance to Oracle Support Team.
Configuration of Maximum Availability.
Configuration of DR (Disaster Recovery).
Configuration of Weblogic Server on Database 11g.
Installation, patching, cloning and basic troubleshooting of Oracle Utilities –
Installation and cloning of web logic server.
Installation of Oracle Database software 12c Release 2
Configured Instance in Oracle database 12c Release 2
Oracle In-Memory feature use to improve the performance of a Database
Used Log Miner to recover table.
Hands on experience in Oracle Database 12c New features like In-Memory, Spatial and Multitenant.
Installation of SOA and OBIEE.
Converting from single node to multi node using RAC. Technical Skills Set
OS : UNIX, HP-UX, Red Hat Linux, Win NT / 2000 / 2003 RDBMS : Oracle Versions 12c,11g,10g, / 9.x
DB Technologies : RAC, Standby database
Backup & Recovery : Hot Backups, Oracle RMAN, Data Pump,OEM, Log Miner File systems/SAN : Raw File systems, HP EVA
Middleware : Fusion Middleware
Languages & GUI Tools : SQL
Monitoring Tools : OEM, OAM, 10g GRID control, Toad Education
Bachelor of Technology
Electronic and Telecommunication Engineering from Jawaharlal Nehru University. Oracle Certifications
Oracle Database 11g : Administration I
Oracle Database 11g : Administration II
3
Current Job Profile
Organization : Whitehall, UK.
Client : Saudi Business Machine (SBM)
Position : Oracle Application DBA
Environment : Oracle Application R12.1.3 on Multi Node Architecture. Organization : Arabic Computer System (ACS), Riyadh, KSA. From July, 2017 to Present Client : Ministry of Water & Electricity (MOWE), Dammam, KSA. Position : Oracle Application DBA
Environment : Oracle 10g R2, Oracle Application 11i, ERP Modules. Organization : System Front Information Technology EST, Jeddah, KSA. From June, 2016 to May, 201.
Assignment : Oracle Applications, RAC, Database Administration. Position : DBA Consultant
Environment : RHEL, Solaris, 11gr2 Oracle Applications R12.1.3, 12.2, 11gR2 RAC Environment
Responsibilities as Apps DBA
Applied product specific fix patches, family pack, Maintenance pack, RUP’s, CPU all types of patches
Implemented and Supported weblogic server 10.3.6,SOA,OEM 12c.
Very strong in administering and troubleshooting Concurrent Managers, applications sys admin tasks, oracle Applications Managers (OAM) issues.
Troubleshooting Oracle Apps related issues and taking feedback from users regarding system performance
Experience in Apache, Forms, Reports Server administration.
Experience in Starting and Stopping of all Application Services.
Trouble Shooting Concurrent Managers and defining.
Cloning of Oracle Application through Rapid Clone
Generate & Compile forms & reports
AD utilities.
Configuration changes in Oracle Application
AD ADMIN tasks
Enabling audit trail
Creating users and responsibilities
Adding and configuring Printers
Enabling sign on audit and audit trail
Managing profiles
4
Responsibilities as Core DBA
Solving day to day issues.
Gather schema, Table & Indexes Statistic periodically to improve performance.
Database cloning with RMAN.
Analyze performance by generating report like ( AWR,ADDM, ASH)
Refresh the database from production with hot or cold backup.
Creating the indexes and rebuilding the indexes.
Compressed the backup with RMAN features.
Scheduling the hot backup and monitoring.
Managing user privileges and roles.
Maintenance and Installed Oracle database 11gR2, 12cR1 and 12cR2.
In-Memory database feature configure to improve the performance of DB.
Installation of RAC on Linux.
Recovered production database using RMAN with zero data loss.
Backup & Recovery experience using RMAN/User Managed/Logical.
Migrate database from Linux to HP-UX
Responsibilities on UNIX
Creating and managing users, files and directories
Changing the permissions and ownerships
Managing the disk space
Checking and installing packages
Setting up of remote connectivity using telnet, vnc. Responsibilities on RAC
Monitoring the RAC database and cluster services.
Configure RMAN in cron tab utility.
Create Disk Group and providing the space to exiting disk group with the raw devices.
Installing RAC
Creating tablespaces, tables and users for custom application and maintained security.
Monitoring database alert log file, data block corruption, segment fragmentation, performance issue, security threads, contention issue like deadlock in the DB, I/O, memory, CPU, etc..
Maintaining RAC
RMAN setup for RAC
Database creation in RAC
Performance monitoring of the database.
5
Previous Client Details:
Organization : Oracle India.
Duration : March, 2012 to February, 2016
Client : iGatePatni
Assignment : Oracle Applications, RAC, Database Administration. Environment : RHEL, 11gr2 Oracle Applications R12.1.3 11gR2 RAC Client : Ooredoo (QTEL), the largest telecom Provider in the State of Qatar Assignment : Oracle Applications, RAC, Core Database, and Database Administration. Environment : RHEL, Solaris, 11gr2 Oracle Applications 11.5.10.2 Client : Verve Communication Private Ltd.
Assignment : RAC, Core Database, Database Administration, ASM Environment : HP-UX
Client : Hamad International Airport, one of the largest airports in the Middle East.
Assignment : RAC installation
Environment : RHCE
Client : Darwish Trading Company, leading trading in the State of Qatar Assignment : Implemented Dataguard
Environment : Windows
Client : Ministry of Municipality and Environment
Environment : 11gr2 RAC health monitoring
Client : Qatar Postal Services
Environment : Database upgrade 10.2.0.4 to 11gr2
Personal Profile
Sex : Male
Marital status : Single
Languages Known : English, Urdu, & Arabic
Nationality : Indian
Visa Status : Transferable Iqama available (Saudi Arabia)
Contact this candidate