RESUME

Mohammed Azhar Ali

Address: Phoenix-AZ -USA

Ph No: 480-***-****

E-mail: ali.dba06gmail.com

Objective

Seeking a challenging position in the field of databases with a progressive company that will effectively utilize my acquired expertise and experience.

Skill Summary

An Oracle DBA with almost 8+ years IT experience in Oracle (11gR2, 10g, 9i) 11g RAC, 10g RAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, Golden Gate, data guard ASM, Logical Backup etc. spanning various industries like Insurance, Banking, Financial, Consulting etc. in variety of environments like UNIX, LINUX, Windows NT 4.0/2000/2003 in production, test as well as development databases.

M.B.A with 8+ years’ experience in the domain of database administration.

Currently designated as an Lead Oracle DBA with Syntel Consulting., Phoenix,

Extensive experience in Administering, Installing and Troubleshooting Oracle Databases and RAC Databases Systems.

Installed oracle database server on HP-UX, Solaris, IBM AIX, Red Hat Linux environment.

Providing 24X7 on call support for OLTP,OLAP/DWH production databases.

Enrolling users, Assigning Roles and Profiles, maintaining system security through monitoring user access to the database

Creating and Managing Table spaces in database.

Good Knowledge of Oracle Security and Vault.

Planning for Backup and Recovery of database information and maintaining Hot Backups, Cold Backups, Logical Backups using Exports and Imports.

Good Experience and Knowledge of Golden Gate.

RMAN Backup & Disaster Recovery.

Experience on Cloning Databases.

Creating and maintaining physical data models

Good knowledge of ITIL processes

Strong experience with Partitioning and Oracle DBA Functions

Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DWH databases.

Experience using Grid Control monitoring tools

Strong query and database tuning skills

Creating and Maintains Tables, Tables partitions, Indexes and database objects..

Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Experienced in using 10g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle Enterprise Manager.

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE,11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.

Experience with SAN storage systems

Fast troubleshooting and resolution skills

Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).

Manage storage growth and planning, including partition management

Experienced in Oracle Support processes for technical requests through Oracle and other Support

Experience in Administering, Installing and Troubleshooting Oracle Databases on VMware.

Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.

Goods hands on experience in Oracle database patching and upgrade.

Implementing and Supporting DATAGUARD( Physical Standby) on Production Databases.

Database Up gradation from 9I to 10g, 10g to 11g

Monitoring and Administrating database through OEM.

Configuring and Managing the Automatic Storage management (ASM).

Knowledge of SQL server 2005/2008 database.

Knowledge of Nosql DB(Mongo DB)

Technical Skills

Operating System HP-UX 10.x, 11.x, Sun Solaris 5.9,5.10,, AIX 5.1, 5.2, RHEL

5.6,5.8 and Windows 95/98/ME/NT/2005/2008XP.

Database Oracle 12c/11g/10g/9i/8i

Language SQL, PL/SQL, UNIX Shell Scripting,

RAC Utilities SRVCTL, CRSCTL, CRS_STAT, CRS_START

CRS_STOP, OCRCONFIG, OCRCHECK,OLSNODES,

Oracle Utilities Oracle Enterprise Manager(OEM), EXP/IMP,

RMAN, ASMCMD,EXPDP/IMPDP,DBUA,NETCA,Golden Gate

DBCA, EMCA, DBV, NID, CSSCAN, OraChk,OSwatcher,TFA

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Ticketing Tools Remedy, Scotty, Service Now, Itrack, Manage Now

Monitoring Tool OEM,12c Grid

Application Apache,Tom cat, Web logic servers,People soft HRMS

Other Tools PL/SQL Dev, Toad, Shareplex, Autosys

Professional work experience

Syntel Consulting Services. May-2011 To CURRENT

Current Project:

1)Client : American Express, Phoenix, Arizona, US

Project

American Express, Phoenix, Arizona

Database

Oracle 11G,12C

Storage

ASM

Role

ORACLE RAC DBA & ORACLE DBA.

Tenure

June-2013 To Present

OS Environment

Unix

Location

Phoenix-Arizona-US

Providing 24X7 support for production databases.

Supporting and Monitoring the Oracle RAC databases.

Documenting database operations through Tickets, Changes

Monitoring the ASM disk group and adding the disk to the disk group when required.

Monitoring the Database health check and growth.

Providing Technical support to Production Environment and developers

Health Checks (Production Database status, Tablespaces Free Space, Backup status, Other Scheduled Cron Jobs status).

Managing the user accounts.

Creating Users, Profiles Granting specific Privileges and roles to the Users.

Killing User Session.

Control File, Redo log File and Archive Log Maintenance

Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed

Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches

Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control

Starting and Shutting down the RAC databases

Creating and Relocating RAC database services to instances

Switchover and Failover RAC database with Data guard Broker

Managing Mount point space

Enable the Flashback feature in RAC environment and make use of it for flashback the database, table and query.

Recovering database objects using Flashback ON/Recyclebin utilities(10G)

Logical backup using Exp/Imp and Datapump.

Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.

Automated routine DBA tasks like backup’s and stats by using Grid control job’s

Provided Assistance to application team at the time of SQL tuning in applications.

Gathering STATS for tables, indexes, schemas, database level.

Generating AWR,ASH AND ADDM reports.

Putting table in KEEP/RECYCLE POOL.

Pin & unpin SQL procedure .

2)Client: Wells Fargo India Solutions Pvt. Ltd.

Project

Wells Fargo India Solutions Pvt. Ltd.

Database

Oracle9i, 10G,11G.

Storage

ASM

Role

ORACLE RAC DBA & ORACLE DBA.

Tenure

June-2011 To Dec-2012

OS Environment

Unix

Location

Hyderabad. India

Oracle Real Application Clusters(RAC) Role & Responsibilities:

Responsible For Installation & Configuration RAC Database.

Implementation of RAC using ASM on 2 Nodes.

Implementation of RAC using OCFS2 on 2 Nodes.

Monitoring of cluster ware files i.e., OCR files & Voting Disk files.

Monitoring the ASM instances on the multiple nodes.

Monitoring the ASM disk group and adding the disk to the disk group when required.

Monitoring the Database health check and growth with script.

Creation of RAC Database using DBCA Tools as well as Manual.

Migrating Non-RAC DB to RAC DB using RCONFIG utility.

Configuring the RAC database in Archive log mode.

Configure RMAN for the backup of RAC database using a Catalog Repository database.

Taking Backup through Shell Scripts.

Enable the Flashback feature of 10g in RAC environment and make use of it for flashback the database, table and query.

Clone the RAC database to single instance database using RMAN/Hot Backup.

Apply patches both Interim patches as well as Patch Set patch using Opatch and OUI in RAC environment.

Taking Backup of OCR and VD.

Upgraded RAC database from version 10.2.0.1 to 10.2.0.4

Upgrading of RAC database from 10.2.0.4 to 11.1.0..

Oracle DBA Role & Responsibilities:

Part of core Production DBA team maintaining production databases.

Providing 24X7 support for production databases.

Installation of 10g and 11g Database on Unix Platform.

Creation of Database using DBCA Utility.

Manual Creation of Database using Script .

Managing the Database Parameter file and Server Parameter file.

Control File, Redo log File and Archive Log Maintenance

Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed

Creating Users, Profiles Granting specific Privileges and roles to the Users.

Cloning the Database (User Manage, RMAN).

Preparation of Technical Documentation and User manual.

Database backup daily and weekly basis.

Taking Backup through Shell Scripts.

Installing and configuring Oracle NET on Server and Client machines.

Configure RMAN catalog database.

Backup (Hot backup, Cold backup)

Validating and Checking of corrupt block by using DBVERIFY utility.

Correcting Corrupted block by using RMAN

Refresh the database for Testing Purpose.

Used Exp/imp utilities.

Data Transport (schema level, tablespace level etc)using Data pump EXPDP, IMPDP

Configure ASM (Automatic Storage Management) in 10g on RHEL4.

Creation of Physical Standby(Data Guard).

Configured Production database and Standby database for Switch Over

Applying Patches Using OPatch,OUI.(Interim Patch and Patchset).

Upgraded database from 10g to 11g through DBUA.

Working with Oracle Support in case of any emergency help required to fix the issue by raising Service Requests(SRs)

Monitoring Checking of OS level Process using SAR,PS,TOP,DF command.

Coordinating activities between the project team and database administration.

Generating AWR,ASH report and ADDM report using sql-script.

Gathering STATS.

Creating and Rebuilding Indexes.

Previous Employer : Butler Technical Services (I) Pvt. Ltd.

Tenure : Nov-2010 To Apr-2011.

Previous Employer Projects:

Project

Select Family

Database

Oracle 10G

Role

DBA.

Tenure

Nov-2010 To Apr-2011

Location

Hyderabad,India

Role & Responsibilities:

Responsible For Installation & Configuration RAC Database.

Implementation of RAC using ASM on 2 Nodes.

Monitoring the ASM disk group and adding the disk to the disk group when required.

Monitoring the Database health check and growth with script.

Creation of RAC Database using DBCA Tools as well as Manual.

Migrating Non-RAC DB to RAC DB using RCONFIG utility.

Configuring the RAC database in Archive log mode.

Configure RMAN for the backup of RAC database using a Catalog Repository database.

Enable the Flashback feature of 10g in RAC environment and make use of it for flashback the database, table and query.

Clone the RAC database to single instance database using RMAN/Hot Backup.

Apply patches both Interim patches as well as Patch Set patch using Opatch and OUI in RAC environment.

Taking Backup of OCR and VD.

Upgraded RAC database from version 10.2.0.1 to 10.2.0.4

Performed Oracle software Installation Unix Environment.

Documenting database operations

Providing Technical support to Production Environment and developers

Creating databases according to clients need by generating scripts or by Database Configuration Assistant (DBCA).

Health Checks (Production Database status, Tablespaces Free Space, Backup status, Other Scheduled Cron Jobs status).

Managing the user accounts.

Creating Users, Profiles Granting specific Privileges and roles to the Users.

Killing User Session.

Control File, Redo log File and Archive Log Maintenance

Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed

Cloning of database to different machine for testing purpose through RMAN or Manual.

Installing and configuring Oracle NET on Server and Client machines

Recovering database objects using Flashback ON/Recyclebin utilities(10G)

Logical backup using Exp and Imp

Applying Patches (Interim and Patchset) Using OPatch and OUI.

Gathering STATS for tables, indexes, schemas, database level.

Generating AWR,ASH AND ADDM reports.

Putting table in KEEP/RECYCLE POOL.

Pin & unpin SQL procedure .

Previous Employer : Verdex Software Technologies pvt ltd.

Tenure : May-2007 To Oct-2010.

Company

Verdex Software Technologies pvt ltd.

Project

Arbain Aire Thermal Industries

Database

Oracle 10G

Role

Oracle DBA

Tenure

July-2008 To Oct-2010

OS Environment

Unix

Location

Hyderabad,India

Education

M.B.A (Master of Business Administration) from SRTMU Nanded(MS) India.

B.C.S (Bachelor of Computer science) from SRTMU Nanded(MS) India.

Achievement & professional profile:

AMEX Excellence Award

Syntel Stretch Award

Personal Details

Date of Birth : 17th June 1983

Marital Status : Married

Nationality : Indian

Languages : English, Hindi, Marathi,Urdu

Contact this candidate