EXPERIENCE SUMMARY:

• I am having more than 6+ years of Oracle DBA work experience.
• My main areas of experience have been IT Consulting/Oracle Database Administration, Oracle Exadata database machine administration, Administration of Oracle 10g Application Server, taking care of multi master replication across database spread across the globe using Oracle Golden Gate technology and provide production support along with support to Data warehouse databases.
• I have worked in Telecom & Manufacturing domain.
• Seeking a challenging career in IT Consulting/Oracle Database Administration as a DBA expertise, that utilizes my experience.

TECHNOLOGY:

• Sun Fire E15K, Sun Enterprise 3500, Sun Fire E25K, HP Super Dome, HP Itanium, HP 9000.
• HP Superdomes,
• (HP - UX platform).
• Oracle 10g Database Server (HP-UX platform).
• SUN Solaris 5.8, 5.9, 5.10, Enterprise 3500
• Windows NT, 2003 Server
• SQL & PL/SQL
• Oracle Cluster
• Data guard
• RMAN
• Datapump
• SQL*Loader
• Statspack
• OEM, 10g DBConsole.
• Oracle Golden Gate,
• Oracle Exadata Sun Database Machine.
• Oracle Server Enterprise Edition
• Oracle Enterprise Manager
• Oracle E-business suite
• Oracle 10g Application Server
• Oracle exadata storage cell software
• Oracle Golden Gate
• Oracle Warehouse builder

CAREER PROFILE :

Confidential

Team Lead

Responsibilities:

• Very good hands on experience with Oracle Exadata database machine.
• Hands on 11g database and grid installation and upgrade from 10.2.0.4 to 11.2.0.2.0 RAC on HP-UX and linux databases.
• Migration of Oracle 10g database from linux to Oracle 10g RAC on HP-UX.
• Installation of Oracle Cluster 10g and ASM and database.
• Installation and Configuration of Oracle Golden Gate with good experience in upgradation from 10g version to 11g.
• Worked on Oracle warehouse builder ETL tool.
• Installation of Oracle 11g OEM grid and configuring agents.
• Configured physical standby databases to using Oracle 11g duplication.
• 24/7 support for the production issues/incidents.

Hardware: HP, Unix, Linux

Languages: Oracle SQL, PL/SQL, Unix Shell scripting

Database: Oracle 8i/9i/10g/11g database,11g OEM, 11g Golden gate, Oracle application server

Special Software: SQL *Plus, Exp/imp, RMAN, Logmnr, SQLLDR.

Confidential

Team Member/Module lead

Responsibilities:

• Requirements gathering from the client.
• Design & Implementation of databases for various projects, creating logical & physical divisions of database.
• Resource and Efforts estimation.
• Configuration Management of Database related details using real application clusters.
• Implemented scripting for Backup routines, which includes Database Exports, Copying Database files to the remote Disk for Precautionary measure.
• Automated the Data conversion and migration from staging to production different environments
• Experience in RMAN for taking backup cold & hot backups of the database.
• Duplicating the databases using RMAN utility.
• Analyzing data, extracting database design.
• Net8 Configuration Assistant.
• Trouble shooting 24*7 production environment issues.

Hardware: Sun OS 5.8 / 5.9/5.10 , HP, Unix,Linux, Windows 2003

Languages: Oracle SQL, PL/SQL, Unix Shell scripting

Database: Oracle 8i/9i/10g/11i database

Confidential

Module Lead

Responsibilities:

• Estimated the hardware requirements.
• Installations & configuration of ORACLE 10G database for replication environments.
• Design and implemented capture process in schema level at source
• Defined the rule for capture, Propagation and apply process
• Design and implemented apply, propagation process.
• Resolved various issues related to oracle streams and stabilized the replication process

Hardware: Solaris 5.10

Languages: Oracle SQL/PL-SQL

Database: Oracle 10g database

Special Software: SQL *Plus, Exp/imp, RMAN, Logmnr, SQLLDR.

Confidential

Module Lead

Responsibilities:

• Estimating the hardware requirements
• Configuring public, private and virtual ip addresses for RAC configuration
• Configuring shared storage for Voting disk and OCR
• Installing and configuring CRS on all cluster nodes
• Installing Oracle 10g software for RAC with ASM
• Upgraded databases from 9.2.0.6 to 10.2.0.3
• Configuration of ASM
• Migrated databases from file system to ASM
• Create data flow rules, analyze data, extract database design.
• Converted single instance database to two instance RAC database
• Configured RMAN backup and alerts for monitoring.

Hardware: Solaris 5.10

Languages: Oracle SQL/PL-SQL

Database: Oracle 10g database

Special Software: SQL *Plus, Exp/imp, RMAN, Logmnr, SQLLDR.

Confidential

Module Lead

Responsibilities:

• Prepared plan for Upgradation along with time lines
• Performed upgradation in POC environment
• Installation of Oracle 9.2.0.8 and upgraded the database

Hardware: Solaris 5.9, HP-UX, Unix

Languages: Oracle SQL/PL-SQL

Database: Oracle 8i/9iDatabase

Special Software: Oracle Universal Installer

Confidential

Module Lead

Responsibilities:

• Configuring public, private and virtual ip addresses for RAC configuraion
• Configuring shared storage for Voting disk and OCR
• Installing and configuring CRS on all cluster nodes
• Installing Oracle 10g software for RAC with ASM
• Generating the necessary convert and transport scripts required for cross platform migration from Sun Solaris to HP-UX
• Using RMAN CONVERT DATABASE, migrated the database into ASM enabled 2 node RAC
• Configured RMAN backup and alerts for monitoring.

Hardware: Solaris 5.10, HP-UX

Languages: Oracle SQL/PL-SQL

Database: Oracle 10g database

Special Software: Oracle Universal Installer, Oracle Clusterware

Confidential

Module Lead

Responsibilities:

• Estimating the hardware requirements
• Configuring public, private and virtual ip addresses for the servers
• Configuring shared storage for Voting disk and OCR on raw volumes
• Installing and configuring CRS on all cluster nodes
• Upgrading the software from 10.2.0.1.0 to 10.2.0.3.0
• Configuring the dataguard.
• Managing the gaps in archivelogs to bring the standby in sync with primary database.
• Conducting DR Drills / Restoration Drills

Hardware: HP-UX 11.23 ia64

Languages: SQL, PL/SQL

Database: Oracle 10g database

Special Software: Oracle Universal Installer/Clusterware

Confidential

Team Member

Responsibilities:

• Developing the implementation plan for Dry Runs and FDRs.
• Database design.
• Integration of databases with other interfaces using NET8 configuration.
• Developing Oracle databases backup and recovery policies.
• Developed capacity planning by observing the trend of DB growth.
• Implementing partitioning for better load balancing of data and to ease data purging in archival activities.
• Application and SQL performance tuning
• Implementing Security features as specified by the Client’s Security policy.

Hardware: Sun OS 5.8 / 5.9

Languages: Oracle SQL, PL/SQL, Unix Shell scripting

Database: Oracle 8i/9i database.

Special Software: SQL *Plus SQLLDR, exp/imp, RMAN