Objective: me want to carve a niche of my own in teh dynamic and growing field of information technology.

SUMMARY

• Experience in installation, configuration, administration of Oracle 9i, 10g, 11g, 10g RAC, 11g RAC database in Unix/Linux and Windows environments.
• Expertise working on oracle 10g &11gR2 RAC environment.
• Installed oracle database server on HP - UX, Solaris, IBM AIX, Red Hat Linux environment.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Experience in Real Application Cluster environment (RAC) wif ASM and OCFS2 file systems.
• Upgrade Grid Control from 11g to 12c -- Configuration ops plugins, setup monitoring, configure Oracle VM 3.2 -- Tuning and Installation of 6 physical server OVM 3.2 environment. 2 for DEV, 2 for TST and 2 for PRD, server pools, vlan, powerpath.
• Migrate 11g to 12c Database, Upgrade 11gr2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.
• Upgrade Weblogic to 12c -- Configure WLS Cluster, deploy Code, Maintain performance and best practices, monitor in Grid 12c.
• Continuous research in leveraging new features of oracle and bringing them under day to day DBA activities
• Expertise in scheduling teh jobs using Grid control.
• Expertise in Oracle Gloden gate Installation, DB Creation, Replication and Implementation on Single & RAC Databases
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.
• 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.
• Installation, maintenance and tuning of RAC applications.
• Experience in implementing, configuring and managing Data Guard wif Physical Standby Databases for High availability configuration.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
• Zero Downtime Migration to Oracle Exadata wif Oracle GlodenGate.
• Experience in installation, configuration and administration of Oracle Databases.
• Implementation of High Availability solutions wif Oracle 10g RAC, Physical Standby Databases (Data Guard.
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Delivering Oracle Database performance-tuning services for customers wif EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE,11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experience in applying security patches to teh databases
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Experienced in Oracle Support processes for technical requests through Oracle and other Support
• Procedures
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Installed 11.5.10, including Financials, Purchasing and Public Sector Financials. Upgraded 11.5.9 to 11.5.10.
• Provide Oracle Apps DBA support for 11i.
• Demonstrated ability to work well wif a wide variety of people at various levels, faster co-operation and
• Collaboration among individuals in teh work unit, halp team resolve conflicts constructively and ability and
• Willingness to communicate when halp is needed.

TECHNICAL SKILLS

Operating Systems: 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.

Databases: Oracle 12c/11g/ 10g/9i/8i, Oracle ExaData, Oracle Gloden Gate

Programming Languages: SQL, PL/SQL, UNIX Shell ScriptingTools: EM, SQL*Loader, TOAD, Fog light, Spotlight

ETL Tools: SQL Loader, Erwin:

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
• Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
• Implemented ASM on RAC. Managing disks and disk groups wif ASM.
• Performed migration activities from 10g to 11g R2 for large databases.
• Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
• Keeping teh databases up to date wif 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
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shooted database issues wif OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Installing, configuring and maintaining Enterprise Manager Cloud Controlto monitor and manage Exadata and regular databases.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT).
• Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata .
• Performed database recovery using GRP (Guarantee Restore Point) .
• 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 teh time of SQL tuning in applications.
• Upgrade Grid Control from 11g to 12c -- Configuration ops plugins, setup monitoring, configure Oracle VM 3.2 -- Tuning and Installation of 6 physical server OVM 3.2 environment. 2 for DEV, 2 for TST and 2 for PRD, server pools, vlan, powerpath.
• Migrate 11g to 12c Database, Upgrade 11,2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.
• Upgrade Weblogic to 12c -- Configure WLS Cluster, deploy Code, Maintain performance and best practices, monitor in Grid 12c.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases wif teh catalog.
• Additionally, part of rotation oncall DBA to support databases 24X7
• Installation, upgrade, security patching, and maintenance of Oracle TimesTen databases.
• Implementation and/or development of Timesten database management tools (backup/recovery, monitoring, reporting, database/server installation, etc.). Ongoing maintenance of same.
• Assist wif teh specifications and requirements for determining hardware requirements to support Timesten databases. Assist wif changes to teh hardware or O/S on database servers.
• Assist engineering teams wif performance and tuning (database parameters, indexes, and SQL code).
• Troubleshoot server and database problems to maximize database availability.

Hardware: Linux, HP-UX, Centos, Solaris

Software: PlSql, MySQL

Environment: Oracle 9i/10gR2/11gR2/12c, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Lead Oracle DBA Production Support,

Confidential,

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
• Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
• Implemented ASM on RAC. Managing disks and disk groups wif ASM.
• Performed migration activities from 10g to 11g R2 for large databases.
• Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
• Keeping teh databases up to date wif 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
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shooted database issues wif OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point) .
• 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 teh time of SQL tuning in applications.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases wif teh catalog.
• Installing, configuring and maintaining Enterprise Manager Cloud Controlto monitor and manage Exadata and regular databases.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT).
• Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.

Additionally, part of rotation oncall DBA to support databases 24X7

Hardware : Linux, HP-UX, Centos, Solaris

Software : PlSql, MySQL

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Lead Oracle database administrator,

Confidential,

Responsibilities:

• Obtain and Maintain DBMS Software & Patches
• Oracle Database Up gradation 10g to 11g (10.2.0) to (11.1.0)
• Decommissioned of Databases.
• Oracle Client Installation on Solaris10, Linux & HP-UX.
• Manage ASM on RAC environments.
• Extending teh database storage capacity by creating new table spaces. Adding data files as per requirement.
• Troubleshoot Error-07445 & Error-4031
• Modify Static & Dynamic Parameters on RAC environments.
• Refresh database using exp/imp and Data pump.
• Remove audit logs older TEMPthan 30 days.
• Interacting wif Oracle Support for technical assistance requests.
• Configuring RAC for load balancing wif other integrated applications.
• Create and relocate services in RAC.
• Managing Physical structure of Oracle database like Data files, Redo log file and Control files.
• Three Node cluster failover test.
• Creation of standby database as per requirement and maintenance.

Hardware: Linux, HP-UX, Centos, Windows

Software: PlSql, MySQL

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Senior Oracle DBA

Confidential

Responsibilities:

• Upgradation, migration of databases.
• Installation, creation of database and RAC.
• Recovering teh database in teh event of a hardware or software failure.
• Testing, and implementation of disaster recovery methodology
• Ensure production database is in sync wif standby database.
• Creation of standby database as per requirement.
• Regular monitoring of database and troubleshooting teh errors.
• Determining and implementing teh backup/recovery plan for each instance according to project’s needs.
• Performing Oracle cold backups to ensure consistency of teh data.
• Performing Oracle hot backups while teh database is operational.
• Adding/resizing data files to teh table spaces.
• Performing Oracle import/export as a method of recovering data or individual objects
• Optimizing Sql statement using explain plan.
• Taking cpu utilization reports daily
• MySql to Oracle migration
• Cloud machine setup.
• Oracle silent installation on cloud machine.

Hardware: Linux, HP-UX, Centos, Windows

Software: PlSql, MySql

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Senior Oracle DBA

Confidential

Responsibilities:

• Provide production support for critical payments system of bank.
• Provide support for various ongoing projects.
• Designing teh infrastructure for new projects and make implementation plan.
• Determining and implementing teh backup/recovery plan for each instance according to project’s needs.
• Maintenance of different databases on AIX server.
• Taking backup and restoration of databases wif import and export utilities. Or individual objects.
• Optimizing Sql statement using explain plan.
• Performing regular maintenance of production db’s.
• Working wif materialized view and managing teh snapshot refresh.
• Implementation of 10g RAC.
• Tuning Sql statement using Tkprof, explain plan utilities
• Managing logical, hot and cold backups manually/RMAN
• Manual/RMAN database cloning to same/different servers.
• Provide on call support.
• 15. Installed 11.5.10, including Financials, Purchasing and Public Sector Financials. Upgraded 11.5.9 to 11.5.10.
• Hardware
• AIX, HP-UNIX, Solaris
• Software
• Pl/Sql, UNIX shell scripts.

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Oracle database administrator,

Confidential,

Responsibilities:

• Senior Oracle DBA
• Upgradation, migration of databases.
• Installation, creation of database and RAC.
• Recovering teh database in teh event of a hardware or software failure.
• Testing, and implementation of disaster recovery methodology
• Ensure production database is in sync wif standby database.
• Creation of standby database as per requirement.
• Regular monitoring of database and troubleshooting teh errors.
• Determining and implementing teh backup/recovery plan for each instance according to project’s needs.
• Performing Oracle cold backups to ensure consistency of teh data.
• Performing Oracle hot backups while teh database is operational.
• Adding/resizing datafiles to teh tablespaces.
• Performing Oracle import/export as a method of recovering data or individual objects
• Optimizing Sql statement using explain plan.
• Oracle Gloden Gate Implementation on Single & RAC Databases.
• Oracle Gloden Gate Implementation & L3 support.
• Oracle Gloden gate Replication for many servers.
• Implement Oracle Gloden gate monitoring for many Databases.
• Oracle Gloden Gate new builds Installation,DB creation on Oracle 9i & 10g.
• Oracle Gloden gate Day to day Oracle DBA activity.
• Taking cpu utilization reports daily
• Provide Oracle Apps DBA support for 11i.

Hardware: HP-UX, Solaris

Software: Pl/Sql

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Team member,

Confidential,

Responsibilities:

• Analysis of approach
• Database design.
• Installation of Oracle9i/10 on windows, Solaris.
• Creation of databases in production environment database
• Adding/resizing datafiles to teh tablespaces
• Created Oracle users
• Handling export and imports of database objects
• Taking cpu utilization reports daily
• Configure Sql net, net8 and Oracle net services
• Monitoring hot/cold backups and verify their success and return teh backup in case of failure.
• Check database alert log and trace file manually to detect problems
• Oracle Gloden Gate Implementation on Single & RAC Databases.
• Oracle Gloden Gate Implementation & L3 support.
• Oracle Gloden gate Replication for many servers.
• Implement Oracle Gloden gate monitoring for many Databases.
• Oracle Gloden Gate new builds Installation,DB creation on Oracle 9i & 10g.
• Oracle Gloden gate Day to day Oracle DBA activity.
• Monitoring teh billing servers
• Coding (pl Sql)
• Testing

Hardware: HP-UX, Solaris, AIX

Software: Pl/Sql, UNIX shell scriptsEnvironment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Gloden Gate, RMAN, Data pump, OEM Grid Control

Software engineer,

Confidential,

Responsibilities:

• Database administrator
• Team member
• Analysis of approach
• Database design.
• Installation of Oracle9i/10 on windows, Solaris.
• Creation of databases in production environment database
• Adding/resizing datafiles to teh tablespaces
• Created Oracle users
• Handling export and imports of database objects
• Taking cpu utilization reports daily
• Configure Sql net, net8 and Oracle net services
• Monitoring hot/cold backups and verify their success and return teh backup in case of failure.
• Check database alert log and trace file manually to detect problems
• Oracle Gloden Gate Implementation on Single & RAC Databases.
• Oracle Gloden Gate Implementation & L3 support.
• Oracle Gloden gate Replication for many servers.
• Implement Oracle Gloden gate monitoring for many Databases.
• Oracle Gloden Gate new builds Installation,DB creation on Oracle 9i & 10g.
• Oracle Gloden gate Day to day Oracle DBA activity.
• Monitoring teh billing servers
• Coding (pl Sql)
• Testing