Oracle Information Technology

Muhammad Asif Qureshi

Sr.Oracle DBA & System Admin

Oracle Certified Professional (OCP 12c DB)

With Gulf Experience (KSA), Driving License

Language: English, Arabic, Urdu

Current Location: Dubai - United Arab Emirates

Visa Status: Visit visa

Mobile: +971- 551017279

Email: ***********@*****.***

Linked In Address: https://www.linkedin.com/feed/

Blog Address: http://muhammad-asif-dba.blogspot.ae/

Summary

Over 10 plus years experience in Database Administration on Solaris, Linux & Windows platforms.

Extensive Knowledge and experience of Oracle database 10g/11g/12c & third party Tools & Utilities.

Performed Logical and Physical database design. Monitored databases using performance and Edge diagnostic utilities.

Designed strategies for performing database backups and recovery.

Migrated data between different Oracle software versions, platforms and other database products.

Experience in administering, monitoring, configuring Veritas Net backup & Backup Exec on Windows, Solaris Sparc, Oracle Linux.

Experience in administering of Windows 2012 servers on virtual machine using windows Hyper-v,Oracle VM.

Experience in administering of Oracle E-business Suite.

Professional Experience

Alaa For Industry (AFI) (Sept 2004 to 2018)

Dammam - Saudi Arabia.

Al-Rashoodi & Partners Holding Company (AFI Groups)

AFI is one of the largest and most diverse industrial companies in the Arabian Gulf which has various subsidiary companies with diverse business interests.

SR.ORACLE DBA & SYSTEM ADMINISTRATOR

Responsibilities:

Architecture, designing, developing and supporting RAC environment.

Installing & configuring Oracle cluster ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, un-installation & cleanup of cluster ware).

Troubleshoot performance issues for the RAC instances (GC events).

Upgrade of 10g R2 RAC to 11g R2 RAC.

Add or Remove Node from RAC.

Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.

Experience with ‘graceful’ switch-over and switchback between primary and standby databases.

Replicated to a disaster recovery site for increased server manageability and availability.

Installed & configured Oracle 10g,11g,12c database on Oracle Virtual Box in Production & development environment.

Installation,Cloning,upgrade,patching of Oracle E-business suite (12.1 / 12.2 on Oracle Linux.

Created primary objects such as tables, views, indexes and modified control space allocation for tables.

Analyzed tables to generate statistics and query the data dictionary for relevant table information.

Participated to develop a plan for high availability, data protection and disaster recovery for enterprise data.

Installed Oracle database instance, expended initialization parameter file and created and managed the operating system file that comprise database storage for data guard configuration in development environment.

Creating and maintaining logs, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.

Developed scripts for database start up and shutdown, tune the rollback segment and multiplex control communicated and interfaced with Oracle support visa meta link troubleshoot day-to-day database issues.

Designed and developed and Oracle database constraints, and triggers to support and Internet client.

Loaded the client's data into database and executed performance tests using SQL & data loader tool.

Enrolling users and maintaining system security, develop database monitoring and performance tuning strategies. Write script to automate routine administrative tasks.

Monitoring and optimizing the performance of the database.

Monitoring Oracle database through third party tool Spotlight software.

Performed user recommended enhancements for quicker queries and performed daily, weekly and monthly checks of Oracle database.

Upgraded Oracle 10g database version to 11g database on Solaris Sparc environment.

Migrated SQL Server 2008 database to Oracle 11g database using SQL developer tool.

Performed database cloning for development and server migrations.

Upgraded Oracle database patches.

Backup and Recovery using Oracle’s RMAN tool used offline/online for recovery in a production environment via Korn shell scripting.

Utilized logical backup (Export/import) utilities for Oracle database data movement.

Analyzed the performance for the database and performance tuned the database.

Communication with vendors regarding system planning and solutions, maintenance contracts, support related issues, bug reports and patches, problem reports etc.

UNIX / Linux Administrator Experience :

Installation, Disk partition, Unix File System, Auto mounting, patch/package installation, file system backups and administration.

Installed Solaris 10 sparc 64-bit operating system using jump start server.

Sun Cluster 3.2 Installation, Configuration and daily Administration. Monitoring Cluster status, logical host, cluster switch over, resource groups and data services.

Oracle Solaris shell scripting.

Veritas Net backup Administrator Experience:

Responsible for all Veritas Net backup procedures and backup polices, setting up Master, Media and Client Servers.

Configured multiples data backup copies on different LTOs.

Installed patches & upgraded Veritas Net backup versions 6.5 to 7.5.

Configured backup & restored windows 2008 Active directory GRT (Granular Restore Technology) backup using veritas net backup.

Implemented a Net backup environment using disk based backup with deduplication.

Restored Lotus Domino e-mail Server on Production environment using Veritas Net backup.

Monitoring daily,weekly backups schedule using net backup activity monitor.

Windows 2012 Server Administrator:

Installed & configured windows 2012 servers on virtual machine.

Installation, configuration & maintenance of workstations, servers, desktops, notebooks & network.

Responsible for configuring and managing Windows 2012 virtual Servers backup & restore using export/import.

Hardware & Software Skills

Databases: Oracle 10g/11g/12c, MySQL, SQL Server 2012/2008, MS Access.

Hardware: Oracle Sun T7-1 Sparc Cluster, Sun M5000 Cluster Server, Sun Fire V1280, Sun Fire V240, HP Blade c7000 enclosure Server,HP Proliant DL380G7 server, HP Proliant DL380G7 Server Dell Desktop, Apple, HP LTO-4, Sun StorageTek SL24, LTO-6, M3000 Server, S7 Sparc

Storage : Oracle FS-1 Storage, Sun Stor Edge 3500, Sun StorageTek 6100, HP P2000 G3 San, Lacie, iomega.

Networking: Cisco 2800, Astaro Security Gateway.

Operating Systems: Windows 2012,2008,2003 Solaris Sparc 10/11, Mac OSX, Linux Suse Enterprise 10/11.

Applications:Baan ERP, Lotus Notes, MS office 2010. Oracle E-Business 12.1/12.2

Backup: Net backup 7.7,Backup Exec 2010, Windows Backup Tool.

Professional Training and Certification

Computer Science Diploma Faith College of Information Technology – Pakistan 1999

Oracle Specialized Course Orasoft Education Center – Pakistan 2000

Crystal Report Training Conducted by AFI – KSA 2005

Veritas Net backup Specialized Course Symantec – UAE 2007

Windows 2012 Server Administration Training Al Khaleej Training Center & Education – KSA 2013

Oracle Certified Professional (OCP)

Candidate-Id OC1414417 Upgrade Oracle 12c Database

Oracle Certified Professional (OCP)

Candidate-Id SP3230212 Oracle 8

SQL,SQL*Plus, Pl/SQL

Database Administration

Backup & Recovery Workshop

Network Administration

Performance Tuning Workshop

Education

MBA Master in Business Administration with Specialized in Information Technology. University of East Hyderabad Sindh – Pakistan 2006

Bachelor in Commerce University of Sindh – Pakistan 1999

High Secondary (Science Group) Govt: College Hyderabad Pakistan – 1996

Secondary School Himayat-ul-Islam Boys high school Hyderabad – 1994

Contact this candidate