Rana Ullah

Email: ac0eoa@r.postjobfree.com, Voice: +1-306-***-****

Toronto L4J 9K8 Canada.

Summary of Qualifications

I have extensive Oracle E-Business DBA experience ranging from E-Business versions V11.5.6 to R12.1.3, 12.1.3 to 12.2.5 and Oracle databases ranging from version 7 thru 12c (12.1.0.2)

I have good Experience in implementing and upgrade of Oracle E-Business Suite 11i/R12 including HRMS on IBM (AIX), HP UNIX, Linux Red Hat 4, 5 and Sun Solaris8,10 platforms in Oracle 9i/10g/11gr2 RAC, ASM multi-node architecture for development, testing and production environment running under Load Balancer and Parallel Concurrent Processing (PCP), Involved in RAC multi-node Oracle E-Business Architecture design, integration and implementation in Oracle RAC with E-Business, N-Tier multi-node and Shared APPL_TOP environment.

Worked in Oracle Data warehouse databases, Oracle Database partitioning and ETL environment consisting of data bases sizes 500GB- 35TB.

Expert experience in Hot and Cold Backup and Recovery, cloning of databases and e-Business R12 using RMAN and flash copy.

HANDS ON experience with Oracle E-Business Suite (EBS) 11i/R12 installation, configuration, upgrade, patching, cloning and backup/recovery. Involved in migration of (OFA to Hyperion).

Technical Skills

Tools/ Languages/ OS

No of Years Experience

Tools/ Languages/ OS

No of Years Experience

Oracle Forms and Reports (9i/10g/6i/6/5/4.5)

10

ERWIN/ER-Studio/ Optima, Visio

6

Oracle Database (7,8i,9i,10g,11g)

10

Data Modeling, Data Loading and Migration using SQL Loader and External Table from Text, CSV, Excel Files.

10

SQL*PLUS, PL/SQL, SQL*Loader

10

SQL Developer, TOAD

10

Workflow Builder (2.6)

2

MS Office

10

Windows XP/2000/NT/98/95/3.1

10

MS Front Page, HTML, JavaScript

1

Oracle Designer (6i/9i/2000)

5

Oracle ERP R12 Red Hat Enterprise Linux 5.8 64 Bit

1

Oracle ASM, Data Guard and RAC

2

Oracle ERP 11i Red Hat Enterprise Linux 5.4 32 Bit

1

Project Management

1

Oracle WebLogic Application Server, Java

2

Query Optimization and Performance

4

Data Base Backup and Recovery (RMAN, User Managed)

7

Oracle eBusiness Upgrade R12

Upgrade from: (11.5.6 to 11.5.8), (11.5.10.2 to R12.1.1), (R12.0.4 to R12.1.1), Completed Oracle E-Business upgrade from 10.5.10.2 to 12.1.1 and then upgraded to 12.1.3 at IDRC (April 2012-April 2013), e-Business upgrade from 12.1.3 to 12.2...5, Oracle Database upgrade from 10g to 11gr2 in an E-Business environment.

Software

Oracle (RDBMS 7, 8i, 9i, 10g, 11gr2,SQL/PLUS, PL/SQL, OLTP, Data Warehouse, 10g Grid Control, Reports 6i/ 2.5, Forms 10g, 6i & 4.5, Oracle Apps 11i, 11.5.8, 11.5.10CU2, r12, Oracle Payables (AP), AR, PO, AP, Oracle General Ledger (GL), PA, FA, OE, TSM, Oracle Financial, Oracle Order Management, Oracle Supply chain, Workflow, iExpense, AOL, Oracle Purchasing, XML Publisher, Oracle Discoverer4i/10g/11g, OFA, Oracle Portal, Oracle WorkFlow, Exadata x2-2, Audit Vault, Data Vault, 12c Cloud Control

Work Experience

1.Database Administrator

eHealth Saskatchewan Regina Dec 2016 to date

1.1Responsible for up gradation production/nonproduction (Oracle 11gr2, 10g, 9i) databases instances.

1.2Responsible for managing production/nonproduction (Oracle 11gr2, 10g, 9i) databases instances.

1.3Apply database patches on different environments (Production, UAT, and development).

1.4Performance monitoring/tuning/troubleshooting (Oracle and Unix)

1.5Capacity Planning/Management (space/machine load/network).

1.6Cloning the database for different business needs (Cold, Hot and RMAN Cloning).

1.7Highlighted current inefficiencies and tuned a number of queries to run 10-100 times faster.

Environment: Sun Solaris10, Linux Red Hat, Oracle 10.2.0.4, 11.2.0.2 (11gr2)

2.Database Administrator

Sun Life Financials Toronto Canada Jan 2016 -Dec 2016

Responsibilities

2.1Responsible for managing production/nonproduction (Oracle 11gr2, 10g, 9i) databases instances to support different applications which include Data Warehouse, on different OLTP environments (AIX, LINUX, WINDOWS).

2.2Performed environment cloning for Midas e-Business databases after flash copy is done by ISM.

2.3Provided high level task and estimated time for upcoming expected upgrade project to 12.2.5 from 12.1.3.

2.4Setup and configure R12 patch wizard and time to time run patch analysis jobs as requested by Finance and PSC.

2.5Restored and recovered databases using RMAN for quarterly refresh of OCSM databases.

2.6Supported e-Business version 10.7 for Ministry of Environment Migrated/upgraded Oracle 9i/8i, 10g databases to Oracle 11g/11gr2.

2.7Plan/configure/maintain Disaster Recovery DB environments using Oracle Data Guard.

2.8Install, upgrade, configure and support 11g, 10g CRS as well as RAC and non RAC Oracle database instances on different platforms using ASM storage.

2.9Highlighted current inefficiencies and tuned a number of queries to run 10-100 times faster.

2.10Supported oracle databases integrated with third party vendor’s application like MP2.

2.11Install, configured and supported Oracle Discoverer 11.1.1.7 for Midas and OCAM Discoverer.

2.12Installed and configured Oracle Discoverer on two nodes load balancing architecture.

2.13Designed and architected on Oracle Discoverer databases, Web logic and fusion middleware on two node load balancing environment.

2.14Design and Architect PCI Data Security Standard project, involved in designing and migration of critical data for PCI. Documented and capture the entire data flow diagram of credit card data. Maintain audit trail of any updates to the credit card information.

2.15Install, upgrade, configure and support 11g, 10g CRS as well as RAC and non RAC Oracle database instances on different platforms using ASM storage.

2.16Installation, configuration, of Dataguard and Physical standby database.

2.17Installed, managed, maintained, configured and supported Oracle Identity Management Suite (Oracle IdM), Oracle Internet Directory (OID), Oracle Access Manager (OAM), Oracle Identity Manager (OIM). Integrated OIM/OAM with E-Business Suite, Web center, Oracle Internet Directory and Active Directory. Integrated OID, SSO, OAM with EBS.

2.18Setup and Configure Oracle WebLogic Server, Websphere and Oracle Fusion Middleware. Documented and setup Oracle Fusion Middleware for high availability.

Environment: Sun Solaris10, Linux Red Hat, Oracle 10.2.0.4, 11.2.0.2 (11gr2), Oracle E-Business Suite 11i (11.5.10CU2,r12), Oracle Payables (AP), AR, PO, AP, Oracle General Ledger (GL), PA, FA, OE, Oracle Financial, Oracle HR applications, Oracle Purchasing, Oracle Cash Management, iExpense, Oracle WorkFlow, ADI, Web ADI, Oracle Data Guard, TSM, XML Publisher, Oracle Tutor, Oracle Grid Control, (Oracle Discoverer 10g, 11g), Oracle Fusion middleware, RMAN, Oracle Financial Analyzer/ Hyperion, Oracle Express, TSM for RMAN backup, SSH (Secure Shell), COTS, Websphere,Oracle GRC Suite 8.x, RMAN. Web logic server 11g, OBIEE, Oracle GRC, Oracle IdM, OID, Oracle Access Manager, OIM

3.Oracle E-Business DBA

Alrazi HealthCare (A Project of Dhabi Group) Dec 2012 – Jun 2014.

Project: Oracle E-Business upgrade project from 11.5.10.2 to 12.1.1, 12.1.3

3.1Installation and Configuration of Oracle Applications R12 on Red Hat Enterprise Linux 5.8 64 bit.

3.2Experience with AD utilities, patching techniques and cloning of Oracle Applications environments.(with rapid clone)

3.3Involved in Oracle Financial Applications Database upgrade from 10.2.0.5 to 11.2.0.2.

3.4Involved Oracle E-Business from 11.5.10.2 to 12.1.3

3.5Installed, managed, maintained, configured and supported Oracle Identity Management Suite (Oracle IdM), Oracle Internet Directory (OID), Oracle Access Manager (OAM), Oracle Identity Manager (OIM). Integrated OIM/OAM with E-Business Suite, Web center, Oracle Internet Directory and Active Directory. Integrated OID, SSO, OAM with EBS.

3.6Experience of Oracle Security Products i.e. Oracle Database Vault, Audit Vault Implementation

3.7Integrating of Oracle Web Center portal with IDM.

3.8Setup and Configure Oracle Web Logic Server, Web sphere and Oracle Fusion Middleware. Documented and setup Oracle Fusion Middleware for high availability.

3.9Setup, configured and upgrade SOA, OAM and OBIEE from 10g to 11g on HA environment.

3.10Installed, configure Oracle Access Manager and integrated Oracle Access Manager with other component of Oracle 11g Middleware component.

3.11From time to time, fixed issues related to Oracle Access Manager in Dev, Uat and in Production.

3.12Setup and configure and supported Oracle Hyperion

3.13Worked and helped technical and Functional team to resolve the issues after upgrade the E-Business databases on 11gr2 and R12.

3.14Involved in handling and managing Oracle Data warehouse database.

3.15Performed Oracle Applications cloning of Oracle Applications Environments.

Environment: Sun Solaris10, Linux Red Hat, Oracle 10.2.0.4, 11.2.0.2 (11gr2), Oracle E-Business Suite 11i (11.5.10CU2,r12), Oracle Payables (AP), AR, PO, AP, Oracle General Ledger (GL), PA, FA, OE, Oracle Financial, Oracle HR applications, Oracle Purchasing, Oracle Cash Management, iExpense, Oracle Work Flow, ADI, Web ADI, Oracle Data Guard, TSM, XML Publisher, Oracle Tutor, Oracle Grid Control, (Oracle Discoverer 10g, 11g), Oracle Fusion middleware, RMAN, Oracle Financial Analyzer/ Hyperion, Oracle Express, TSM for RMAN backup, SSH (Secure Shell), COTS, Web sphere,Oracle GRC Suite 8.x, RMAN. Web logic server 11g, OBIEE, Oracle GRC, Oracle IdM, OID, Oracle Access Manager, OIM

4.Oracle Application/ E-Business DBA

The City School Networks Pakistan. Aug 2012 – Dec 2012

Project: Oracle E-Business upgrade project from 11.5.10.2 to 12.1.1, 12.1.3

Responsibilities in City School Networks: basic purpose of my hiring in City School was to participate in the following upgrade tasks for the upgrade project

4.1Involved in Oracle Financial Applications upgrade from 11.5.8 to Oracle Application 12. Completed upgrade documentations for release 12. Worked and helped with technical and Functional team to resolve the issues after upgrade to Oracle Applications 12. Implemented mandatory feature for Oracle Applications 12 of Oracle Applications Tablespace Model (OATM), Involved in testing with Functional and QA team.

4.2Planned and migrate Oracle 9i databases and Oracle E-Business Suite Application from Solaris 8 servers to new Solaris 10 servers.

4.3Oracle Applications Upgrade from 11.5.8 to 115.10CU2 on new Solaris 10 servers.

4.4Installed, configure and setup Oracle Grid Control to monitor Oracle Databases on new servers.

4.5Involved in setup RMAN database backup and recovery including creating scripts. Participated in Disaster Recovery exercise and provided performance benchmark to management for recovery.

4.6Setup and configured Data Guard for Solaris 10 new servers.

4.7Performed, setup procedure and documented Oracle Applications and Database cloning/ database refresh.

4.8Worked with the Technical Developers team to help them with the issues related to Developer 2000, oracle Forms 6i/ Reports 6i. Opened TAR with Oracle Support to fix RUP patch related issues. Analyze and applied Oracle Application patches using ADPATCH to fix functional and technical issues in Oracle Applications 11.5.10.

4.9Applied /upgrade RUP6 (11i.ATG_PF.H.delta.6) patches from RUP4 on DEV, UAT instance.

4.10Applied CPU Security Patches for database and E-Business Suite and Oracle Discoverer.

4.11Involved in performance and tuning tasks, bring down for some batch jobs from 8-10 hours to 20 sec

Environment: Sun Solaris 8,10, Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4, OLTP, Oracle E-Business Suite 11i (11.5.8, 11.5.10CU2,r12), AP, PO, AR, GL, PA, OE, iExpense, Oracle WorkFlow, ADI, Web ADI, Oracle Data Guard, Oracle Grid Control, Oracle Discoverer 4i/ 10g, RMAN, Oracle Financial Analyzer, Oracle Express, Oracle Warehouse Builder, Mainframe IMS (ZEKE Jobs), Oracle Warehouse Builder. TSM for RMAN backup, SSH, MS Sql server

5.Senior Oracle Database Administrator

World Call Telecom Limited (An Omantel Company) May2007 Aug 2012

I was the prime DBA of 14 Production databases and 100 non-prod databases. I was responsible for Oracle installation, upgrade, Backup / recovery and Provide Production Support for Data Warehouse databases consisting of database sizes between 2 – 35 Terabyte including Oracle E-Business database environments. Prepared and tested Disaster Recovery Plans using NetBackup, Veritas and RMAN.

5.1Responsibilities and work environment offer to work and support:

5.2Involved in 24 Oracle DB instances migration from Oracle 8i to 10g/11g/11gr2.

5.3Supported 9i/10g/11g databases on HP UNIX, Sun Solaris and Linux platform.

5.4Provided support for MS SQL server databases and DB2

5.5Implemented RMAN/TSM backups for oracle databases, tested DR setup as part of annual DR testing.

5.6Install, upgrade, configure and support Oracle11g, 10g CRS as well as RAC and non RAC Oracle, DB2, MSSQL database instances on different platforms using ASM storage.

5.7Highlighted current inefficiencies and tuned a number of queries to run 10-100 times faster.

5.8Design and Architect PCI Data Security Standard project, involved in designing and migration of critical data for PCI. Documented and capture the entire data flow diagram of credit card data. Maintain audit trail of any updates to the credit card information.

5.9Installation, implementation, configuration and setup of 10g/11g RAC on Solaris 10.

5.10Apply database patches on different environments (Production, UAT, and development).

5.11Install and configure OEM 10G and agent to monitor 10g/ 11g databases.

5.12Plan/configure/maintain Disaster Recovery db environments using Oracle Data guard (standby).

5.13Responsible for all standard database administrative tasks including proactive performance tuning, trouble shooting, import/export/data pump, backup and recovery using RMAN and VERITAS Netbackup.

5.14Setup and Configure Oracle Web Logic Server and Oracle Fusion Middleware.

5.15Actively provide leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments.

5.16Ensure day to day smooth operation of many large and small corporate databases running on Oracle 8i/9i/10g/11g and 11i /r12 database environments.

5.17Security implementations. Provide secure database environments for production purposes that meet company policies and SOX compliance

5.18Performance monitoring/tuning/troubleshooting (Oracle and Unix)

5.19Capacity Planning/Management (space/machine load/network)

Environment: Sun Solaris 8,10, HP-UX 11/11i, HPUX Itanium, Linux, AIX, HP, Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4, OLTP, 11gr1,11gr2, Oracle Applications 11i/r12, Oracle Data Guard, Oracle Data Warehouse, Cognose, Informartica, 10g RAC, 11g RAC, Oracle Grid Control, SAP Basis, Shared Point, Oracle Web Logic Server, VMware, Oracle e-Business 12.1.3., DB2, MS Sql server, PostgreSQL Database

6.Oracle DBA

Government College University Lahore October 2004 to May 2007

Project: Examination system, HR System, Admission System

6.1Worked closely with architects, developers & others to design, implement install and administer comprehensive databases version (8i, 9i).

6.2Upgrade the system according to the new requirements.

6.3Created Database, Schemas, objects, Indexes, Role, Privileges, Table Spaces, Data Files using Enterprise Manager and from query.

6.4Provided production support and fix issues. Fixed and configured Oracle Grid Control issues.

6.5Configured, build and setup Oracle Data Guard for new databases in production. Fixed Oracle Data Guard issues in production.

6.6Helped peel region development team to fix Oracle databases and MS SQL server issues.

6.7Performed a lot of Oracle Development Databases refreshes from product.

6.8Used Enterprise Manager for query Optimization and Performance (SQL Tuning advisor, SQL Access Advisor, Segment Advisor, AWR, ADDM,RMAN Backup, SQL Loader)

6.9Worked on Admission System and HR System for GCU in Oracle forms\reports 6i, Pl/Sql and Oracle 9i.

6.10Automating DBA Tasks to simply management using PL/SQL, Shell Scripts.

6.11Solve queries from Admission Office.

6.12Compile results of all the students and design reports for the Students and Management.

6.13Wrote PL/SQL packages, functions and procedures to enforce business rules and relationship uncovered in the Data model.

6.14Performed RMAN backup and recovery using Enterprise Manager.

6.15Configured Flashback recovery area for RMAN to Backup and recovery of (Data Block, Data files, Table Spaces, Partial and Whole Backup )

6.16Performed automated backup of the control file using RMAN in flashback recovery area.

6.17Performed Hot and Cold backup of the database Using RMAN in flashback recovery area.

6.18Performed recovery of Critical (System and Undo) Table Spaces form RMAN backup.

6.19Performed Flashback Query, Flashback Transactions, Flashback Transaction Version query, Flashback Table on the database for consistent view.

6.20Developed and Implement different reusable modules that are consistent throughout the applications

6.21Wrote PL/SQL packages, functions and procedures to enforce Examination system rules and relationship uncovered in the Data model.

6.22Perform a complete Backup of the Database.

6.23Developed PL/SQL triggers and master tables for automatic generation of primary keys.

Environment: HP-UNIX, AIX, Sun Solaris, Window 2000, Oracle 8.1.6, 8.1.7, 9i, MS Access, Excel, Applications11.5.8, AR, PO, AP, GL, OE, Alerts, OPM, AOL, OEM, Oracle Work Flow (Oracle 9.2.0.1.0, 9iAS Application Server), Oracle Forms 6i, Oracle Reports 6i, Crystal Reports, Visual Source Safe, Oracle Enterprise Manager, JAVA, PVCS Tracker, Oracle HR/Payroll, Oracle Discoverer 4i.DB2, MS Sql server.

7.IT Officer

Anjum Asim shahid Rehman (Grant Thornton) Jan 2004 to Oct 2004

7.1Installation of all IT related equipment (Software and Hardware).

7.2Trouble shooting of all the IT related equipment.

7.3Solve all the Networking related tasks.

7.4Discuss with end user to solve the IT related queries.

Environment: Windows 2000, 1998

Certifications:

Oracle certified Professional (DBA Track) 2013

Oracle certified Associates (DBA Track) 2013

Red Hat Enterprise Linux 5.7, 5.8 2012

Ms Office 2007 2008

Windows Server 2008 NT 2014

EDUCATION:

Master in Computer Science from University of Regina Canada (Continued.)

BSCS in Computer Sciences from University of Punjab Pakistan. (2000-2004)

Master of Business Administration from University of Punjab Pakistan. (2006-2008)

REFERENCE:

Will be provided on request.

Contact this candidate