Oracle Sales

Mohammed Aziz

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

Mobile # +91-958*******

Educational Qualification: B.TECH (Electronics & Communications Eng.),

JNTU, Hyderabad, India, 2004

CERTIFICATIONS:

OCP @ Oracle 10g DBA Certified Professional

OCA @ Oracle 10g DBA Certified Associate

(OC ID # 58476)

OCP @ Oracle 11g DBA Certified Professional (yet to receive the

certificate)

Profile Summary:

Having Oracle DBA Relevant Experience 5.2yrs, Total Experience 8.2 yrs

. Experience in Oracle 10g, 11g, 10g RAC, 11g RAC

Spanning across various industries like Finance, Pharmaceuticals,

Logistics / SCM

In variety of environments: UNIX, Linux, Solaris, Windows 2000/2003 in

Production.

. Expertise in Oracle, ASM, Data guard:

Installation, Migration, Administration, Production Support,

Configuration, Upgrades, Applying Patches, Space Management, Database

Security and troubleshooting.

. Managed Large Oracle Databases each sizing more than 1 TB.

. Proficiency in RMAN

Cloning and refreshing the database as per the requirement

Backup: Full, incremental and cumulative;

Recovery: Incomplete & Disaster.

Test Crash Recoveries: using Conventional, Hot and Cold backups.

Performed data migration using: Oracle export / import, Data pump,

SQL*Loader.

. Mentoring the team in Oracle Database capacity planning, space management

and storage allocation

. Hands-on with EXPLAINS PLAN, STATSPACK, AWR and ADDM to collect, maintain

Performance Statistics and improve the Database Performance.

. Monitoring activities for: On-Call, 24x7 Production DBA, Application /

Development DBA

. Handling Oracle Support processes for Technical Requests via Meta link &

other Support Procedures.

Oracle Skills:

RDBMS : Oracle 11g, 10g, 10g RAC

DB Mgmt. : TOAD 9.5, Enterprise Manager Grid

Tools : RMAN, OEM, SQL*Loader

Utilities : ASM, Export/Import, Patch Management, Data pump

Tuning Tools : TKPROF, EXPLAIN PLAN, AWR, ADDM

Languages : SQL, HTML, C, C++, JAVA, UNIX Shell Scripting

OS : Sun Solaris 9, 10, OEL 5.5, Red Hat Linux RHEL 4.x, 5.x, Win

2000 / XP

Employment History:

Presently working as:

. Oracle DBA Analyst @ IBM, Bangalore

Apr 2011 - till date

Previous Employment:

. Sr. Oracle DBA Administrator @ Sierra Atlantic, Bangalore

Oct 2008 - Mar 2011 (2 years 6 months)

. Sr. Network Administrator @ Grene Robotics PVT Ltd. Bangalore.

Jun 2005 - Sep 2008 (3 yrs 4 months)

Oracle Project Details

Company : IBM, Bangalore

Project : American Express, Phoenix, AZ

Duration : Apr 2011 - present

Role : Oracle DBA Analyst

Environment : Oracle 11g, Oracle 10g, RH Linux 5.x, Oracle 10g RAC, ASM,

OEM, RMAN

American Express is a diversified global financial services company leading

in global payments, network and travel sectors. American express

specializes in the credit card business model. It maintains high volumes of

data of its customers and clients.

Responsibilities:

* Installed and configured Oracle 10g /11g RDBMS on RHEL 4 & Sun Solaris

Environments.

* Installed Oracle 11g database on RHEL 4 version.

* installation and implementation of oracle 10g RAC on RED HAT LINUX -

5.5

* Installation and maintenance of oracle 10g RAC databases using ASM and

CRS.

* Experience in managing larger oracle databases each sizing at least

more than 800 GB.

* Migration of databases across different platforms.

* Involved in upgrades from oracle 9i to 10g and oracle 10g to oracle

11g.

* Applied interim patches using OPATCH utility, upgraded database to

10.2.0.4.

* Profile creation, user creation, role or privilege assignment based on

requirements.

* Set up, configured and maintained oracle data guard (primary and

standby databases) to ensure disaster recovery, high availability and

data protection.

* Managing disks and disk groups with ASM.

* Monitoring the status of CSS service and ASM instance.

* Managed crontab file, rescheduling the failed jobs (due to errors),

changing timing for the scripts to run if the job fails and adding new

jobs (scripts).

* Creation, configuration and setting up of RMAN catalog databases and

registering the target databases with the catalog.

* Worked on import/export, export data pump/import data pump and SQL -

Loader.

* Involved in implementing backup, recovery procedures, implemented hot,

cold, logical backup plans.

* Installing and configuring RMAN and flash recovery. Cloning databases

using RMAN as well as user managed cloning.

* Daily health check up of the database using stats pack, AWR, ADDM,

TKPROF, Explain plan.

* Monitoring of automated jobs, for startup and shutdown, health check

of databases, analyzing of tables and rebuilding of indexes.

* Participated in disaster recovery drills, documented databases.

* Partitioned large tables as part of performance enhancement.

* Schema/table re-organization for faster performance using

export/import. Date refresh in test databases using transportable

table spaces.

* Managing space, table spaces, segments and extents roll back segments.

Company : Sierra Atlantic, Bangalore

Project : Schering Plough Research Institute, Kenilworth, NJ

Duration : 04/2010 - 03/2011

Role : Senior Oracle Database Administrator

Environment : Oracle 10g, 9i, RH Linux 4, Sun Solaris10, Windows NT/2K

Schering-Plough Corporation is a United States-based pharmaceutical

company. It was founded in 1851 by Ernst Christian Friedrich Schering as

Schering AG in Germany. Involved in sales and marketing group, clinical

trials, drug sales and distribution and drug discovery group, involved in

sales force automation implementation.

Responsibilities:

* Installation and configuration of oracle 9i / 10g on different

servers.

* Installation, configuration of oracle 10g RAC on Red Hat Linux - 4.

* Involved in design and implementation of oracle 10g data guard both

physical/logical standby databases in high availability mode.

* Worked on automatic storage management (ASM) with EMC Storage for

managing data in SAN.

* Closely monitoring, administering log transport services & log apply

services in physical / logical DB.

* Up gradation from oracle 9.2.0.8 databases to oracle 10.2.0.3.

* Used shell scripting for RMAN and hot backup and recovery.

* Implemented backup using RMAN as a media management layer.

* Created and managed users, roles, privileges, profiles, schemas.

* Used export/import for schema, table and database refresh.

* Monitoring of scripts such as creation of users, creation and

assignment of roles, analyze space requirements and maintains table

spaces and database objects and also did the patch management for

oracle upgrade.

* Scheduling of failed jobs and editing the new jobs according to the

timings of the jobs.

* Involved in table space point in time recovery, disaster recovery and

database point in time recovery drills done in test environment.

* Performed all the database administration activity like space

management in database, user and roles administration, schema

management, regularly checking alert log of all the instances.

* Managing redo logs and data files like adding and resizing them as and

when required.

* Taking differential backup of the database using RMAN regularly on to

disks and tapes.

* Using RMAN jobs for all types of backup and recovery of oracle

databases.

* Was involved in configuration of physical standby environment for

disaster recovery.

Company : Sierra Atlantic, Bangalore

Project : GATI Ltd, Singapore

Duration : 10/2008 - 03/2010

Role : Oracle DBA Administrator

Environment : Oracle 9i, Oracle 10g, Red Hat Linux 4.x, Sun Solaris 9, RMAN

GATI is one of leading Logistics companies...

Responsibilities:

* Performed installation of oracle 10g on Red Hat Linux 4.

* General DBA activities like monitoring, space management, schema

management etc.

* Management of table spaces for users by granting quota on default,

temporary table spaces.

* Checking alert log and monitoring growth of the Table spaces.

* Archival space monitoring.

* Creation of table spaces, users and database objects as per

requirement.

* Taking differential backups of the database using RMAN regularly on to

disks and tapes.

* Planning and scheduling backups using cron backup, export /import and

various database issues.

* Testing recovery strategies by simulating database crashes on

development systems.

* Export and import of database objects to copy from one database to

another database.

* Monitoring of jobs running and re-scheduling the failed jobs according

to the timing.

* Added new user accounts, created profiles, roles and assigned them to

users as per requirements.

* Monitoring the data loading jobs (SQL*Loader, Import/Export).

* Involved in database migration between across platforms.

* Working on applying patches for oracle related problems.

Company : Grene Robotics, Bangalore

Duration : 06/2005 - 09/2008

Role : Sr. Network Administrator

Client four is one of the leading IT services Company.

Responsibilities:

* Performed installation of windows 2003 server.

* Managing DHCP, DNS, User Profiles, privileges for end users, LAN and

WAN.

* Troubleshooting hardware related issues.

* Installation and configuration of printers.

Contact this candidate