Oracle Management

Sajid Pasha Mail: *************@*******.***

Mobile No: +91-903*******

Profile Summary

An incisive professional with 4+ years of Oracle Database & IT Industry experience. Currently working as Oracle Database Administrator at Chamfer Software Technologies. Expertise in Oracle Database Administration. I would like to perform in an optimum way to obtain High availability goal of an IT infrastructure for the growing organization.

Professional Summary

Around 4+ years of work experience in Oracle Database Administrator.

Installing the Oracle servers and creating the DB.

Managing users, roles, privileges.

Experience on Tablespace management & security management.

Experience in handling space related issues of Tablespaces.

Refreshing the tables from production to other environments through IMPDP/EXPDP

Data migration using export/import or Datapump.

Managing Control files, online Redo logs and Archive logs.

Experience in Database duplication with RMAN (by using auxiliary database), Cold and Hot backups.

Taking the compressed backups and Incremental backups using RMAN.

Experience on Migrating the Database from NON ASM to ASM.

Worked on Upgradation on standalone databases.

Good experience on patching activities.

Applying Quarterly PSU Patches and all the supported databases.

Checking alert logs for errors and resolving the errors.

Skilled in setting up and managing oracle physical standby using DATAGUARD.

Having Good knowledge on cluster Installation.

Good Experience in RAC Environment.

Experience on Configuration of ASM and maintaining the database.

Creating the disk group like External, Normal, and High according to requirement.

Qualification:

B.Tech(Computer Science Engineering) from JNTU Hyderabad 2011.

Professional Experience

Working as Oracle Database admin for Chamfer Software Technologies Hyderabad from Mar 2012 to Present.

Technical Skills:

Databases : Oracle 10g, 11g, 12c.

Operating Systems : Linux, OEL and CentOS

Languages : Sql, Pl/Sql.

RDBMS Tools : RMAN, Datapump, Exp/Imp, ASMCMD.

RAC Tools : SRVCTL, CRSCTL, OCRCONFIG,CLUVFY.

Netware : Putty, VNC Server, Winscp,Ftp.

High-Availability : DataGuard, RAC

Monitoring tools : Toad, SQL Developer

Projects Undertaken

Project#1

Project name : SABIC

Operating System : Linux, OEL.

Database : Oracle 11g,12c

Role : Oracle Database Administrator.

Responsibilities:

Installed 12.1.0.2 RDBMS software.

Upgraded the database from 11.2.0.4 to 12.1.0.2

Downloaded the oracle software from OTN and installing RDBMS(11.2.0.4) software

Upgrading the databases from 11.2.0.3 to 11.2.0.4.

Prepared and scheduled the manual shell scripts to take web catalog and RPD backups.

Migrating the databases from one server to another servers(IMPDP/EXPDP)

Generating the AWR and ADDM Reports to trouble shoot the database performance issues

Experience in loading the data into the database from files through SQLLDR.

Experience in scheduling the monthly, weekly and daily refreshes.

Manual configuration of Enterprise Manager Console.

Moving the tables server level, Database level, schema level through Impdp/Expdp

Working on TOAD and SQL Developer

Monitoring the RAC instances.

Project#2

.

Project name : ALCOA.

Operating System : Linux, OEL

Database : Oracle 10g and 11g

Role : Oracle DBA.

Responsibilities:

Cold database backup and restoration

Database creation, Tablespace management, User Management

Analyzing database and tables

Logical Backups (Import/Export, Data pump)

Raising SR with Oracle Support teams for any kind of issues

Hands on Experience in RAC environment.

Managing the Oracle clusterware using: CRSCTL,OCRCONFIG, OCRDUMP utilities.

Taking back-up of ocrfiles.

Maintaining RAC database using command line utility srvctl.

Production Support for Oracle 10g/11g Databases.

Installation, Maintenance & Configuration of Databases.

Database Backup and Recovery (RMAN, hot and cold backups), Logical Backup using Oracle Utilities (Export and Import, Datapump).

Database level Performance Tuning like generating reports to analyze the Database performance (Explain plan, TKPROF, AWR reports and SQL trace).

Regular monitoring of Alert log file on day-to-day basis for errors.

Involved in activities like Re-org for the entire database.

Managing standby database using Data Guard verified failover and switch over operations, performing number of development and test clones from production databases.

Project#3

.

Project name : UTCL(Ultra Tech Cement).

Operating System : Linux.

Database : Oracle 10g and 11g

Role : Jr. Oracle DBA.

Responsibilities:

Daily monitoring the performance of database

Performing oracle installations, Database Creation

Performing backup and recovery operations if needed

Backup -- Cold/Hot/incremental Backup manually, using exp/imp utilities

Configuring RMAN and performing different type of Backups

24 X 7 Production support.

Performing daily health checks

Writing Shell Scripts for DBA activities

Space Management, Users Management, Roles, and Privileges etc.

Managing Tablespaces, Datafiles, Control files, Redo Log files.

Creating Databases, Creating table spaces with storage parameters.

Creating Database objects, Users, Roles, Profiles for the databases..

Checking alert log file.

Personal Information

Name : Sajid Pasha

DOB : Oct 4th 1989

Current Organization : Chamfer Software Technologies

Designation : Oracle Database Administrator

Personal Mail ID : *************@*******.***

Current Location : Hyderabad

Marriage status : Married.

Place: Hyderabad Yours Sincerely,

(Sajid)

Contact this candidate