MIAN MUHAMMAD ANWER

Riyadh, Kingdom of Saudi Arabia

Cell: +966- 507003739

E-mail: adgnqt@r.postjobfree.com

https://www.linkedin.com/in/miananwar/

EDUCATION

Master in Computer Science from NewPorts University Karachi (2004)

Bachelor's degree (Commerce) from Punjab University Lahore Pakistan. (2000)

Intermediate (Commerce) Board of Secondary Education Lahore Pakistan. (1998) CERTIFICATIONS & Workshop

Oracle Cloud Infrastructure (OCI) 2019 Certified Professional

Oracle Cloud Infrastructure (OCI) 2019 Certified Architect Associate

Oracle Autonomous Database Cloud Specialist Certified (2019)

Project Management Professional Training (PMP)

Oracle 9i Certified Database Administrator Professional (2002)

Oracle 10g Certified Database Administrator Professional (2009)

Oracle 11g Certified Database Administrator Professional (2015)

Oracle 12c Certified Database Administrator Professional (2019)

Oracle R12 EBS Certified Database Administrator Professional (2019)

Oracle E-Business Suite R12 Install, Patch and Maintain Applications from Oracle University Saudi Arabia (2010)

Oracle E-Business Suite R12 System Administrator Fundamentals from Oracle University Saudi Arabia (2010)

Oracle 11g Administration Workshop 11 from Oracle University Saudi Arabia (2010)

Attended SAP power user training for MM, FICO, HCM, PM

Oracle R12 Inventory Management from Oracle University (2013)

Oracle Solaris Cluster Administration from Oracle University Saudi Arabia (2014)

Oracle Collaboration Suite 9i, 10g from Oracle University Pakistan. (2006) PROFILE

Oracle Certified Professional Currently employed as an Oracle Sr. Consultant at Azeemi Technologies.

Successfully led the Oracle Applications R12 implementation and upgrade projects

Have the exposure to handle the VLDBs, EBS financial as well as SCM support along with Databases in live and Critical Environment.

Project coordinator in SAP-ECC6 implementation for MM, FICO, HCM, PM modules

Hands-on experience with RAC and Data Guard, Golden Gate implementation and administration

Successfully led the Database upgrade, migration, data center and cyber security upgrade and implementation projects

Have the experience to lead and mentor the Oracle Applications functional as well as DBAs team.

Have the experience in supporting on premise and on cloud and lead the implementation/upgrade of the E-Business Suite as well as industry specific applications business functions as per the organization requirement. Having vast experience to implement database advanced security like TDE, OLS, AVDF, Database vault.

Have the good experience to work with Implementation teams and resolve their Applications related issues.

Over 16 + years of experience in Oracle production life cycle especially EBS Applications, Database Administration in Oracle Environment (8i, 9i, 10g, 11g, 12c), Oracle Apps-DBA, up-gradation of Oracle Applications, Oracle RAC/Data guard, WebLogic, System Analysis, Database design, Development and Implementation and installations of Oracle Apps, Oracle Application Server, Internet Development Suite and Oracle Collaboration Suite (OCS). Oracle Cloud Infrastructure (OCI), Cloud DBA

Have the complete practical experience of core/apps database administrations, backup recoveries and performance tuning.

Database Administration e x p e r i e n c e includes Oil and Gas, Construction and FMCGs, Health Care, Insurance Organizations, In-house Development of Govt. and Semi Govt. Organizations, Stock Exchange Market

, Manufacturing and Management Information Systems of Textile Industry. Technical Skills

Hardware : ODA, Sun-Sparc, IBM, HP-UX

Operating System : Windows 2000/03 Server, Red Hat Linux/, Solaris, IBM-AIX, HP-UX RDBMS : Oracle 8i, 9i, 10g, 11g, 12c, 19c, Autonomous DB, SQL Server Development/Data Modeling Tools: Oracle Workflow builder, Oracle Discoverer 10g, XML Publisher, Oracle 9i, 10g Forms and Reports, PL/SQL Developer, Toad, Oracle Designer, Power Designer, Case Studio2, Erwin, SQL, PL/SQL, Oracle Migration Work Bench.

Database Experience: Installation & Configuration of Oracle Databases, Oracle Application Server, FWM-WebLogic Oracle E-Business- Suite 11, R12, Database Server Tuning and sizing, Application SQL Tuning, User-Space management, Oracle Database Advanced Securities (TDE, OLS, Wallet Configuration, Database Firewall) Backup/recovery techniques, loading data using SQL Loader, Oracle Cloud Infrastructure, Autonomous DB Middle Tiers: Oracle Internet Application Server 9i, 10g, Web-logic. Database Securities: TDE, OLS, Audit Vault, Database Firewall, Database Vault.

Email Utilities: Oracle Collaboration Suite 10g

ERPs: Oracle Applications 11i, R12, SAP, Oracle Primavera p6, (HMIS) Hospital Management Information Recovery/Backup tools used: Exp/Imp, RMAN, Cold backup, Hot backup, Symantec Net- backup, VERITAS, HP Data Protector.

Oracle utilities: SQL*PLUS, SQL*LOADER, STATSPACK, TKPROF, Explain Plan, ASH, AWR, ADDM, ASMM.

DBA: Oracle 8i, 9i/10g, 11g, 12c, 11i, R12 (Administration, patching, cloning, Up-gradation, Backup/Recovery and Performance Tuning), Cloud DBA

High Availability: Have the expertise in Oracle Real Application Clusters, Data Guard, Oracle Streaming, DB-Visit, Golden Gate, SharePlex, HVR

EMPLOYERS & DESIGNATIONS

1. Azeemi Technologies from 9th December, 2018 to Date as an Oracle Sr. Consultant 2. Rabigh Arabian Water and Electricity Company from 1st August 2011 till 6th December, 2018 as an Oracle Applications-Lead/ Sr. DBA

3. Abdullah A.M. AlKhodari Sons Company Saudi Arabia From 15th April 2008 to 31st July, 2011 as Oracle Applications-DBA

4. Punjab Social Security Health Management Company (Owned by Govt. Of the Punjab) From 7th July, 2007 to 10th April 2008 as an Senior Oracle Database Administrator 5. Netsol Technologies Pvt Ltd (CMMI Maturity Level 5 Company) From 8th September, 2006 to 6th July, 2007 as a Senior Software Engineer (Oracle)

6. Ora-Tech Systems Pvt Ltd (Oracle Corporation’s Partner Company) Lahore (From 1st July ’2005 to 7th September 2006 as a Technical Support Consultant

7. Ora-Tech Systems Pvt Ltd (Oracle Corporation’s Partner Company) Lahore Pakistan (From 1st January ’2003 to 30th June 05 as an Oracle Database Administrator

EXPERIENCE DETAILS

Organization : Azeemi Technologies Riyadh, Saudi Arabia Duration: 9th December, 2018 to Date.

Environment : Oracle E-Business Suite Release 11, 12, Oracle Databases 10g, 11g, 12c, Oracle Internet Developer 10g, WebLogic, Operating system Unix, Linux, Windows, Oracle Database Appliance (ODA), Oracle Cloud Infrastructure (OCI) Role : Oracle Sr. Consultant

JOB RESPONSIBILITIES

Oracle database appliance (ODA) configuration and implementation in Bare-metal and Virtualization

Installation, configuration and administration of Oracle databases 11g, 12c in RAC and NON-RAC environments on traditional and oracle engineered systems like ODA, Mini Cluster

EBS Cloud migration from on premise to OCI, virtual Cloud Manager configuration for lift and shift

Best practices backup/ recovery by using RMAN and standby configurations at different clients

Oracle Core and EBS databases health check, proactive and preventive maintenance as per SLAs

DMZ and SSL configuration for EBS to secure the I-modules over the internet

Implemented Oracle Database Advanced Securities to comply the local security rules like Database Firewall, OLS, TDE, Wallet Configurations for 10g, 11g and 12c.

Carry out the project as per defined scope and time lines

Developed and managed implementation of project communication strategies.

Having a clear understanding of Software Development Life Cycle (SDLC).

Patching Oracle application. Including family packs, mini packs and consolidated fixes all R12 modules.

Creating users, assigning responsibilities, managing concurrent processing, data auditing, Using AD utilities viz. adadmin, adpatch, ADOP, adctrl etc. to manage Oracle Application.

Multi box, RAC and NON-RAC installation of Oracle E-Business Suite, RAC Node addition and Deletion

Installation and configuration of WebLogic 12c

Up-gradation of an E-Business Suite from 11.5.10.2 to 12.1.3/12.2.

Migration and upgradation of an oracle E-Business platform from windows to Unix, Cloud DBA

Migration and upgradation of an Oracle core database from windows to Linux and vice versa

Configuration and Managing Oracle Workflow and its components.

Configuration of Oracle Web Applications Desktop Integrator(ADI)

Configuring Oracle Application Manager and Oracle Enterprise Manager.

Optimizing resource utilization in the existing Sun Sparc servers, windows and Linux Servers.

Cloning Oracle Applications with rapid clone/Manual for development and testing and incorporating customizations.

Using AUTOCONFIG to configure Oracle Applications.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.

Organization : Rabigh Arabian Water and Electricity Company Rabigh Saudi Arabia Duration: 1st August, 2011 to December 06, 2019.

Environment : Oracle E-Business Suite Release 11, 12, Oracle Application Server 10g, Oracle Internet Developer 10g, Operating system Sun Solaris Sparc (5.10, 11), Windows 2003, OEL 5 Role : Oracle Applications-Lead/ Sr. DBA

JOB RESPONSIBILITIES

successfully led the Oracle applications, Data center upgrade and migration project for various functions within the business especially Oracle Finance, Purchasing and Inventory, HRMS/Payroll under the supervision of an IT Manager and have a liaison with all the stake holders to get the things done timely.

Successfully led the implementation of the industry specific applications like power plant information system, operation and maintenance corporate system and an oracle project management P6,

Project Coordinator for SAP-ECC6 implementation in MM, HCM, FICO and PM modules

Ensured the clear business objectives, scope and requirements as per the standard oracle implementation and upgrade methodologies.

Established the in house problem solving channels regarding the EBS business systems applications and evaluate the needed external services for delivery.

Managed internal stakeholders' expectations and project progress, and ensure regular project updates reflecting any delays, issues and risks.

Developed and managed implementation of project communication strategies.

Coordinated the change management and migration strategies with external vendor.

Having a clear understanding of Software Development Life Cycle (SDLC).

Taken the initiatives in process improvements, Support and business systems management activities.

Supporting the corporate applications users in day to day business operations in APPS DBA, Functional and system administration tasks.

Liaison with software vendor and Hardware vendors as per SLAs.

Patching Oracle application. Including family packs, mini packs and consolidated fixes all R12 modules.

Creating users, assigning responsibilities, managing concurrent processing, data auditing, Using AD utilities viz. adadmin, adpatch, adctrl etc to manage Oracle Application.

Multi box installation of Oracle E-Business Suite

Up-gradation of an E-Business Suite from 11.5.10.2 to 12.1.3/12.2 and legacy applications database.

Migration of an oracle E-Business platform from windows to Unix

Configuration and Managing Oracle Workflow and its components.

Configuration of Oracle Web Applications Desktop Integrator(ADI)

Configuring Oracle Application Manager and Oracle Enterprise Manager.

Configuration and administration of Oracle Discoverer 10g with Release 11, 12.

Optimizing resource utilization in the existing Sun Sparc servers, windows and Linux Servers.

Cloning Oracle Applications with rapid clone/Manual for development and testing and incorporating customizations.

Using AUTOCONFIG to configure Oracle Applications.

Backup & Restore on-line and off-line backup planning, procedure, RMAN, exp/imp, restores process.

Tuning performance monitoring and necessary tuning, Optimization of Tuning Issues, Bitmap indexes, B-Tree Indexes.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.

Mentoring the Asst. DBA and other applications junior staff as per company policy.

Configuration of Oracle Disaster recovery for continuity of corporate business.

Configuration of Secure Socket Layer for secure and reliable access of an Oracle Instance for End users. Organization : Abdullah A.M. AlKhodari Sons Company Saudi Arabia Duration: 15th April 2008 to 30th July 2011.

Environment : Oracle E-Business Suite Release 12, Oracle Application Server 10g, Oracle Internet Developer 10g, Operating system Sun Solaris Sparc (5.10), Red Hat Linux AS 4.6 Role : Oracle Applications-DBA

JOB RESPONSIBILITIES

Lead the successful Oracle Applications implementation project

Supported the Oracle Applications Finance, SCM, HRMS/Payroll end users in their day to day business operations.

Supported External Vendor and In-house Consultants/End Users during Implementation of an Oracle Applications R12 in APPS DBA and system administration tasks.

Worked as a team member in implementation of an oracle E-Business suite module.

Configuration of Oracle Applications Audit Trail to monitor the user changes in Applications.

Patching Oracle application. Including applying maintenance and RUP 12.0.6 patch for all R12 modules.

Creating users, assigning responsibilities, managing concurrent processing, data auditing, Using AD utilities viz. adadmin, adpatch, adctrl etc to manage Oracle Application.

Single Node, Multi Node Installation of Oracle Application R12 (12.0.0, 12.0.4, 12.0.6).

Configuration and Managing Oracle Workflow and its components.

Configuration of Oracle Web Applications Desktop Integrator(ADI)

Configuring Oracle Application Manager and Oracle Enterprise Manager.

Configuration and administration of Oracle Discoverer 10g with Release 12.

Moving development and testing codes to various instances and testing them.

Optimizing resource utilization in the existing Sun Sparc servers.

Cloning Oracle Applications with rapid clone/Manual for development and testing and incorporating customizations.

Using AUTOCONFIG to configure Oracle Applications.

Setting up users to login to apps. Jinitiator Install and configurations.

Tuning Oracle server along with Operating System to obtain optimal performance.

Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Backup & Restore on-line and off-line backup planning, procedure, RMAN, exp/imp, restores process.

Tuning performance monitoring and necessary tuning, Optimization of Tuning Issues, Bitmap indexes, B-Tree Indexes.

Writing UNIX shell scripts for backup and recovery, Import and export procedure.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.

Defragmentation of database by objects.

Removing row chaining, row migration for better performance.

Configuration of UNIX based printers at the operating system and applications level.

Configuration of Oracle Standby for fail over by using Oracle Data guard.

Configuration of Secure Socket Layer for secure and reliable access of an Oracle Instance for End users. Organization : Punjab Social Security Health Management Company Duration: 7th July, 2007 to 10th April 2008.

Environment : Oracle 10g Database, 10g Internet Developer Suite, 10g Internet Application Server Operating Systems Red Hat Linux Advanced Server 3.0, 4.6 Role : Senior Oracle Database Administrator

JOB RESPONSIBILITIES

Lead the implementation of the Hospital Management Information System (HMIS) in social security hospitals as per the business needs.

Responsible for Maintenance, New Enhancements, Team Handling, Databases

Architect/administration, Version control, All Documentation, Standards, and Code Reviews as per the best SDLC practices.

Arranged the CRPs and UAT sessions to make sure that scope of work is in line with organization requirements as well as staff familiarity with the needed industry processes.

Extensively involved in the Performance Tuning of the Databases, backup and recoveries.

Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention.

Design and structuring of tablespaces, tables, indexes and users for the database.

Configuration of the Data Guard on 10g database for the high availability of the live databases.

Configured the Oracle Real Application Clusters to avoid from Instance downtime.

Configured the Oracle Streaming to share the same data of one Hospital on different sites of the Social Security Hospital Sites Concurrently.

Installation of Oracle 10g database 10g developer and 10g IAS on Red Hat Linux Operating systems.

Installation, administration and configuration of Oracle Internet Developer suite 10g with Oracle Application Server10g.

Security management which includes Creation of Users and Roles.

Space Management, which includes creation of Tablespaces, Tables and Indexes.

Actively participated in Application Tuning which includes SQL Tuning, Database design tuning and tuning at Instance level.

Organization : NetSol Technologies (SEI-CMMI -5/Oracle Certified Partner) Ltd Lahore Pakistan Duration: : 8th September 2006 to 6th July, 2007.

Environment : Oracle Databases 9i, 10g, Oracle Applications 11.5.10.2, R12 Operating Systems Red Hat Linux 3.0, 4.0, Windows 2003Servers

Role : Senior Software Engineer (Oracle)

JOB RESPONSIBILITIES

Installations, Configurations, Up-gradation, Administration of an Oracle Applications

Patching, Cloning, Performance Tuning of Apps and DB Tier

Have the experience to migrate the Very Large database from SqlServer 2000 to Oracle 9i, 10g.

Have the experience to provide guidance to Oracle Development team and suggest them Oracle recommended solutions accordingly.

Extensively involved in the Performance Tuning of the Database which includes identification of resource consuming/problematic SQL and thereafter tuning of SQL.

Responsible to handle the clients calls regarding oracle databases from all over the World.

Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention.

Design and structuring of tablespaces, tables, indexes and users for the database.

Installation of Oracle 9i database on Windows and Red Hat Linux servers.

Implemented Backup and Recovery Strategies.

Security management which includes Creation of Users and Roles.

Space Management, which includes creation of Tablespaces, Tables and Indexes.

Have the experience to monitor the indexes and rebuilt them to avoid index fragmentation.

Actively participated in Application Tuning which includes SQL Tuning, Database design tuning and tuning at Instance level.

Have the experience of implementing the Oracle Label security, Table Partitioning.

Have the experience of fulfilling the client’s requirements by writing stored procedures, Triggers, Functions. Organization : Ora-Tech Systems Pvt Ltd (Oracle Certified Partner) Lahore Pakistan Duration : 1st January ’2003 to 7th September 2006 Environment : IDS 9i, 10g, Database 8i, 9i, 10g, EBS-11i, Application Sever, OCS 9i, 10g Operating Systems Red Hat Linux 2, 3, 4 and Windows Servers Role : Technical Support Consultant /Oracle Database Administrator JOB RESPONSIBILITIES

Have the Experience to Handle Client’s requests regarding Oracle Core Product Life Cycle and E-Business Suite during large scale implementations.

Have the expertise to handle the Oracle Applications (Oracle Apps) as an Oracle Apps-DBA.

Have t h e e x p e r i e n c e in I n s t a l l a t i o n s, M i g r a t i o n s, Up-gradations, C o n f i g u r a t i o n s, C l o n i n g, P a t c h i n g, Administration and Maintenance of Oracle Applications.

Extensively involved in the Performance Tuning of the Database which includes identification of resource consuming/problematic SQL and thereafter tuning of SQL.

Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention.

Design and structuring of tablespaces, tables, indexes and users for the database.

Installation of Oracle 9/10g and other Oracle Products tools over different Servers.

Have the experience in Installation, Administration and Up-gradation of Oracle Collaboration Suite.

Installation, Up-gradation and configuration of Application Server 10g with 9i IDS, 10g IDS.

Implemented Backup and Recovery Strategies.

Actively participated in the up-gradation of Databases from 8i to 10g and from 9i to 10g.

Security management which includes Creation of Users and Roles.

Space Management, which includes creation of Tablespaces, Tables and Indexes.

Actively participated in Application Tuning which includes SQL Tuning, Database design tuning and tuning at Instance level.

Have the knowledge of Data Guard, RAC, and Replication. PERSONAL INFORMATION

Born on: 10th August 1980.

Passport #: LU1796793

Father Name: Jamaat Ali

Nationality: Pakistani

Religion: Islam

Marital Status: Married

Contact this candidate