Oracle Manager

Muhammad Shahbaz Ali – Oracle DBA

Email: ***************@*****.*** Mobile: +968-*****-***

Technical Summary:

Certified Oracle Database Administrator with seven years of experience. Have worked in Insurance, Banking and Development companies sectors in which administrated the production databases running on Oracle 10g RAC, Oracle 11g on OEL, RHEL operating systems. And experience of Oracle application servers 10g, Weblogic on AIX, Windows2008 Servers.

Having the experience of creating two DR sites with successful switchover and failover testing on three production databases running on Oracle 10g database with AIX supported by IBM Tivoli storage management system.

Experienced of OEL, RHEL and AIX system administration for Oracle database environment, including users, files system management and administration skills.

Technical Skills:

1.Oracle Database Administration(9i, 10g &11g)

2.Oracle Application Server Administration 10g & Weblogic.

3.Oracle Real Application Cluster.

4.Disaster Recovery Oracle Standby Servers.

5.Oracle Backup & Recovery.

6.Oracle Grid Control.

7.Oracle Database Upgrade.

8.Oracle Database Platform Migration.

9.Oracle Application Upgrade from lower to higher version.

10.Oracle database managing on Linux System.

11.Oracle database managing on IBM-AIX.

Willing to relocate: Anywhere

Work Experience:

Oracle DBA

Omani National Livestock development co (S.A.O.C), Salalah, Oman (May 2013 to Present)

Roles & Responsibilities:

Support of Production Database Oracle 11g and Weblogic Server 24/7.

Designed, Installed and configured of Oracle server software and related products.

Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.

Ensure databases adhere to corporate standards and policies. Worked with application vendor 3i InfoTech India/Dubai team, developers, change management team to ensure smooth life cycle progress from development through testing and production implementation.

Installed Oracle 11g Production and test databases from scratch including RHEL,OEL OS installation

Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.

Scheduling and maintained RMAN full and archives backups.

Database restoration using RMAN for testing environments.

Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning of database instance.

Day to day general database administration, managing users, resources, managing user privileges, grants and roles.

Administration of ERP system Orion application

Refreshed multiple databases for Development and Testing upon short request.

Created and maintain users, roles and privileges.

Involved in discussions with the management regarding the application changings.

Deployed Standby Database and Weblogic servers on remote sites.

Environment: Oracle 10g, 11g, OEL, RHEL, Windows 2008 64bits server, TOAD, OEM

Oracle DBA

IBM- Pakistan (Habib Bank Limited Project), Karachi, Pakistan (April 2012 to May 2013)

Role & Responsibilities:

Provided Database support 24/7

Conducting Installations of Oracle 10g, Oracle 11g databases, sizing/capacity planning for the Oracle database on AIX and Linux Servers

Configuring and using of Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks

Schedule database backup using RMAN on IBM TIVOLI storage management system including archives backup after every 15 minutes and restoration.

Improving the performance of the database by tuning database instance parameters

Constant monitoring of database and space management

Experienced in writing technical documentation

Setting up Oracle Standby Data Guard on two different sites and their administration.

Migration of production databases to DR Site using Switch over and Failover

Responsible to improve the performance tuning using STATSPACK, Index rebuilding

Proficient with performance related issues and determined to find the root cause.

Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space

Export and Import of User, Tables and Database using exp/imp and Data Pump utilities.

Administration of AIX platform including users groups creations and assigning privileges and file management administration

Environment: Oracle 10g/11g Data Guard, OEL,AIX, LINUX, IBM TIVOLI Storage

Oracle DBA

Adamjee Insurance Company Ltd, Karachi, Pakistan (September 2009 to April 2012)

Role & Responsibilities:

Design and develop technical solutions for effective & tactical deliverance of service provisioned deliverables and management timelines with 24/7 support.

Installed and configure Oracle 9i, 10g Windows, Linux and AIX servers.

Implemented 10g dataguard with Physical Standby DB (Maximum availability, Maximum Performance).

RAC administration including troubleshooting.

Installation & Configuration Oracle Application Server 10g R2 (Forms & Reports) on AIX and Linux

Upgrade existing 9.2.0.7 databases to 10.2.0.4 on RHEL.

Use of Datapump utility and IMP/EXP

Disaster recovery, administration and monitoring of physical backup and recovery of production systems.

Using of Oracle Backup and Recovery (RMAN backup /Cold backup / Hot backup / Datapump / IMP-EXP).

Follows organization’s change, configuration, and release management processes.

Installs/coordinates the installation of database-specific patches and major/minor version releases on development, test, and quality assurance and production systems.

Monitors, detects, diagnoses, resolves, and reports database system problems. (Performance & availability, etc.)

Create and maintain multiple databases on single machine

Expertise in Installation, Cloning and configuring Oracle Application Server 10g R2 on AIX.

Configured RMAN for backup & Recovery purpose on Production Environment & Disaster Recovery Site.

Performed performance and tuning on SQL Queries and data movement scripts

Tables, indexes, users are created and permissions are granted to users

Experience in taking Daily, Weekly, Monthly and Yearly Physical backups using RMAN

Involved in writing LINUX shell scripts for daily RMAN backups, tape backups, Index rebuilding to improve performance

Administered two production OLTP databases with more than 30 branches databases including test databases for different modules testing.

Using TCP/IP Protocol Configured SQL.Net files on server / client machines, and resolved client connectivity issues.

Configured and created required table spaces and datafiles with appropriate storage parameters as well as placement.

Managed disk space requirements for growth of data tables and indexes.

Run stats pack every day to get the statistics of the production databases.

Environment: Oracle 9i/10g, RAC, RMAN, DATAGUARD,OEM,TOAD, AIX,OEL,RHEL

Qualifications:

Masters of Information System Sciences, Lulea University of Technology, Sweden (September 2006 – September 2008)

Bachelor in Information Technology, Iqra University, Karachi, Pakistan

(2001 – 2005)

Technical Qualifications:

•OCP Oracle 10g Administration (September 2009)

•RHCE trained from TechnoED Institution

Additional Information:

•Date of Birth: 1st May 1982

•Marital status: Married

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

•Contact number: +968-***-*****

•Address: A-30, Anwar-e-Ibrahim, Malir City, Karachi

Total Experience:

•10 Years.

Contact this candidate