SUMMARY

• Confidential is a talented professional with 20+ years of IT experience in analysis, design, development and support of software applications.
• 20+ years’ experience in Oracle databases and tools with the last 17 years performing as an Oracle DBA for Oracle 11G, 10G, 10G RAC 9i RAC, 10G RAC, Data Guard and Oracle R12/11i Applications.

• Installation of Oracle while working for big fortune 500 corporations
• Creation of the databases and instances
• Patching and upgrades
• Oracle RAC
• Data guard
• Database and table/index sizing for the application tables/indexes.
• Backup recovery RMAN
• Remote Production DBA support
• All other aspects of Oracle DBA job
• Basic knowledge of SQL - Server, worked as backup DBA for SQL Server databases.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• Supported in lead Oracle EBS DBA for in house hosting of Confidential EBS applications. Maintained databases for Oracle 11i EBS, and R12 Oracle Incentive compensation systems.
• Database/EBusiness cloning, deployments upgrades, backups. Commvault backups and Delphix virtual database cloning.
• Currently supporting EBS in Confidential for OMIM (Order and Inventory Management).
• Completed 10g 10.2.0.4 to 11g 11.2.0.4 database upgrade, required for Phase 1 of R12 upgrade 12.1.3.
• Worked on 11g RAC Grid infrastructure upgrade to 11.2.0.4.
• Supported Confidential production environment of EBS applications 7x24 on-call rotation.
• Setup of data guard standby database, tablespace maintenance, RMAN backups, monitoring of databases.
• Deployed code in development, test environments, and on successful testing deployed tested code into Production environment.
• Represented code changes in Change board meeting.
• Worked with developers and business users to understand the needs and requirements, and carry out approved tasks in approved deployment window.
• Applied EBS application patches and database cumulative CPU to the database environment. Maintained Oracle RAC database running on 4 nodes (4 instances).
• Performed quarterly password changes of main schemas in EBS database, per security

Confidential

Oracle DBA Consultant

Responsibilities:

• Created and configured Linux clusters using Confidential software to create platform for Oracle 9i, 10G RAC, and 11G RAC.
• Raised bugs and issues encountered during tests, and interfaced with developers to provide them trace, and debug information to get them fixed. Ran Oracle certification OCE tests suites for certification matrix of OS, Matrix Server, and Oracle.
• Worked on setup, QA and tested Confidential ’s failover solution pack (Wizard) for Oracle Non-RAC databases. Fault injection testing to demonstrate and test fault tolerant capability of matrix server with Oracle. Helped customers in field, which used matrix server for Oracle deployment.

Environment: and tools: Linux RedHat RHEL5, SLES9, SLES10 SP2, Oracle10G, Data Guard, 11G latest RAC and non-RAC database servers.

Confidential

Oracle DBA

Responsibilities:

• Installed 9i, 10g Oracle software on Sun servers, followed by installing latest patch-set. Installed and maintain 9i RAC on UNIX platforms.
• Applied security alert patches to Oracle 8i, 9i databases. Helped on issues related to day- today issues of Oracle production, test, and development databases.

Environment: and tools: UNIX, Sun Solaris, Oracle 8i, 9i, Oracle Export/Import, Embarcadero DB Artisan, TOAD

Confidential

Oracle DBA Consultant

Responsibilities:

• Confidential has high highly available, scalable linux and windows clustering solution.
• Installed and tested Oracle 9i RAC and Oracle 10G RAC solution using Confidential matrix server and Confidential ODM solution pack.
• Created and configured linux clusters using Confidential software to create platform for
• Oracle 9i, 10G RAC. Raised bugs and issues encountered during tests, and interfaced with developers to provide them trace, and debug information to get them fixed.
• Ran Oracle certification OCE tests suites for certification matrix of OS, Matrix Server, and Oracle.
• Worked on setup, QA and tested Confidential ’s failover solution pack (Wizard) for Oracle Non-RAC databases.
• Fault injection testing to demonstrate and test fault tolerant capability of matrix server with Oracle. Helped and customers in field, which used matrix server for Oracle deployment.

Environment: and tools: Linux RedHat RHEL3, RHEL4, SuSE SLES8, SLES9, Oracle 9i and 10G latest RAC and non-RAC database servers. Oracle Test suite OCE.

Confidential

Oracle DBA Consultant

Responsibilities:

• Installed 9i Oracle software on Sun servers, followed by installing latest Oracle 9i patchset.
• Applied security alert patches to Oracle 8i and 9i databases.
• Upgraded existing databases of Confidential Corp from 8i to 9i. Helped on issues related to day today issues of Oracle production, test, and development databases. Environment and tools: Unix, Sun Solaris, Oracle 8i, 9i, Oracle Export/Import, Embarcadero DB Artisan

Confidential

Online Oracle DBA / Applications DBA

Responsibilities:

• Installed, upgraded and maintained Oracle 8i and 9i databases.
• Responsible for installing security and routine patches, monitoring, tuning, backup and restore, database upgrades (8i to 9i), database cloning and resolving any Oracle issues for multiple clients. In addition installed, upgraded and maintained 11i EBSO Oracle Applications Suite and Databases for hosted customers.
• Support them based on 7x24 shift schedule.
• Worked on customer issues via tars created by them via Oracle Metalink Support.
• Used ITS extensively for supporting the customer tars and work management.
• Worked on tasks like Database upgrades, 11i E-Business Application Upgrades, Patching, OEM Monitoring, RMAN backup/restore.
• Worked extensively on Oracle database cloning, 11i applications cloning.

Confidential

Oracle DBA / Oracle Consultant

Responsibilities:

• Installed Oracle 8i Database on Windows 2000 Advance Server.
• Created physical database objects and structures in an Oracle repository for Data warehouse used by Market Research Group of SEGA.
• Analyzed the requirements, created logical data model for the Data Warehouse.
• Provided file specifications to source system programmers to create data files to be loaded in the data warehouse.
• Created load programs to load data in the Oracle repository for data warehouse.
• Created batch scripts to automate the loading and massaging of data, and scheduled them using