SUMMARY

• 13 years as Senior Oracle Database Administration Ver 7.x/8.0/8i/9i/10g on a variety of UNIX (Solaris, HP - UX, AIX), Linux, Windows NT 4.0/2000/2003 with 10 Years as Senior Oracle Applications DBA in ERP such as Financials, Manufacturing, HRMS (HR, Payroll), CRM and Self Service framework me-Components (iSupplier, iPayment, iRecruitment, iStore etc), Comp-Workbench etc using Apps (10.7, 11.0.3, 11i - 11.5.3, 11.5.4, 11.5.5, 11.5.7, 11.5.8, 11.5.9, 11.5.10, R12 ).
• Oracle Server Installations / Upgrades, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Patching, Security Administration, Data Architecting, normalization/de-normalization, Oracle Applications System Administration, Oracle Web Application Server, Data Warehousing, Oracle Advanced Replication, Oracle Parallel Server/9i RAC, 10g RAC, Space Manager, SQL Server, Oracle Standby Server, Dataguard, Multithread Servers, Distributed Databases for Oracle 7.x/8i/9i/10g Databases, table partitioning, cluster partitioning also under SAN infrastructure.
• Document and publish teh Discoverer/ADI/Oracle Database installation, configuration and procedures manual.
• Implemented successfully 10g Discoverer upgrading from 4i.
• Implemented OBIEE 11g and Oracle APEX 4.0.1.
• Good technology understanding of Oracle RAC and hands-on experience of installation RAC cluster under Linux, 10g RAC installation, database creation, and migration databases from single instance to RAC instances
• Strong Experience in installations, conversion, process improvement, application upgrade, patching management with Oracle Applications (10.7 NCA / 11.0.3 / 11i). Specialization in Oracle Application (ERP, CRM, SSL etc) and multiple Databases, Data Warehouse, ETL Technology, Reporting tools, Data Modeling and Data Architecture and Scrambling of Apps Environment after cloning. Also worked on Clarify, Cognos, Brio, Kintana, Vertex, Veritas, Lagato, Omnibackup, Netbackup and EMC.

PROFESSIONAL EXPERIENCE

Confidential

Snr Oracle Applications DBA

Responsibilities:

• Installation and configuration of R12 with 2 node RAC on linux.
• Upgraded Rel 11.5.10.2 to Rel 12.1.1
• Installation and configuration of Oracle Application Rel 11.5.10.2 with 10g - 3node RAC on AIX on veritas clusterware.
• Implemented Hardware Load Balancing of web tier and implemented Parrallel concurrent processing on admin tier.
• Upgraded E-business database and CRS from 10g to 11gR2 and added concurrent node for better performance .
• Installed Oracle APEX 4.0.1 and integrated it with SSO.
• Cloning development instance from Production for development purpose.
• Creation of RMAN system backup scripts and made a regular backup strategy for hot backup scripts.
• Performed database administration functions including object sizing, Table space maintenance and overall disk space management
• Implemented OBIEE 11g with Oracle database 11g .
• Configuration and Administration of OBIEE 11g .

Confidential

Snr Oracle Applications DBA

Responsibilities:

• Implemented Oracle Application Rel 11.5.10.2 with 10g RAC on Sunsolaris 5.10 on Veritas storage Foundation for Oracle RAC .
• Implemented Hardware Load Balancing of web tier and implemented Parrallel concurrent processing on admin tier.
• Performed database administration functions including object sizing, Table space maintenance and overall disk space management.
• Installation and configuration of, workflow and discoverer 4i.
• Upgradation of discoverer to 10g from 4i.
• Implemented SSL for Oracle Application and for Discoverer 10g .
• Implement Hardware load balancing for web and forms server .
• Cloning of RAC to non-RAC instance.
• Setup of DR site for failover of Database and Application. using Data guard.

Confidential

Senior Oracle Applications DBA

Responsibilities:

• Implemented 11.5.10.2 HRMS and Financials and maintaining Oracle Applications Rel 11.5.9 Production and Development instances. Responsible for Cloning development instance from Production for development purpose,.
• Installation of Oracle 9i/10g, installation and setup for 9iRAC and 10gRAC, Database migrating Oracle 9i to 10g.
• Installed and patched for 11.5.9/10 instances, including foreign languages and Discoverer 4.1.48.06.
• Installed, configured, trouble-shoots Oracle/SQL database and Oracle 10g Application server (including Portal, Single-Sign-on, Discoverer and third party application system) in all servers. Upgrades/Patching database and system based on Development/Operations request
• Installation and managing Oracle Network products.
• Tuning Oracle server along with Operating System to obtain optimal performance.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Security User Management, Privileges, Roles, Auditing, Profiling, Autantication.
• Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
• Tuning performance monitoring and tuning, Optimization, Parameters, Tuning Issues, Bitmap indexes, Hash Joins.
• Provided support for Oracle 10g RAC Cluster database both production and dev. Adding New Node and removing node for maintenance
• Managing Veritas Clusters for HA, I2 Implementation.
• Involvement in Disaster recovery
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
• Cloning databases.
• Setting up new environments (Development, Production etc)
• Taking Hot and Cold Backups, Exports etc.
• Performed database administration functions including object sizing, Table space maintenance and overall disk space management.
• Installation and configuration of vertex, workflow and discoverer 4i. Upgradation of discoverer to 10g from 4i.
• Implemented SSL for Oracle Application and for Discoverer 10g .
• Implement Hardware load balancing for web and forms server .

Confidential

Senior Oracle Applications DBA

Responsibilities:

• Worked in British Telecom project (Offshore DBA Pool) as Senior APPS DBA.
• We are Responsible for teh offshore support for British Telecom.
• me look after teh maintenance and support of Applications or trouble shoot any database related issue.
• We are maintaining Oracle Applications Rel 11.0.x/11i Production and Development instances.
• We are responsible for Cloning development instance from Production for development purpose, Installation and configuration of Oracle 8i RDBMS and Oracle application Release 11i on HP UNIX.
• Replatforming of oracle instances from Sun Solaris to HP-UNIX. Performed database administration functions including object sizing, Table space maintenance and overall disk space management, Application of client, forms and database server patches.
• Currently working in O2 Production Support project (Offshore DBA Pool) as Senior APPS DBA. We are Responsible for teh offshore support for O2 Production server. Apart from BT and O2 support we are also supporting

Confidential

SENIOR ORACLE APPLICATIONS DBA

Responsibilities:

• Upgraded Release 11.5.7 to 11.5.9
• Responsible for maintaining Oracle Applications Rel 11.5.7 Production and Development instances.
• Cloning development instance from Production for development purpose.
• Installation and configuration of Oracle 8i RDBMS and Oracle application Release 11i on HP UNIX.
• Upgraded oracle Application from Rel 11.0.2 to Rel 11.5.7 on HP-UNIX.
• Performed database administration functions including object sizing, Table space maintenance and overall disk space management.
• Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts. Database Recovery Application of client, forms and database server patches.

Confidential

ORACLE APPLICATIONS DBA

Responsibilities:

• Installed and configured Oracle8i/8 RDBMS, Oracle Application Release 11i, Apache Web server and Webdb on Sun Solaris Sparc (2.6).
• Installed and configured Oracle 8 RDBMS and Oracle Application Release 11i on Sun Solaris Sparc (2.8). Performed database administration functions including object sizing, tablespace maintenance and Overall disk space management.
• Creation of system backup scripts and made a regular Backup strategy for Cold backup, hot backup scripts.
• Database Recovery Application of client, forms and database server patches.
• Tuning of customized application including reports and back-end customization by using different application tuning technique.

Confidential

ORACLE APPLICAYIONS DBA

Responsibilities:

• Performed upgrade from Oracle RDBMS version 8 to Oracle 8i.
• Performed Migration from Oracle RDBMS version 7 to Oracle 8.
• Installed and configured Oracle8i/8 RDBMS, Oracle Application Release 11i, Apache Webserver and Webdb on Sun Solaris Sparc (2.6).
• Installed and configured Oracle 8 RDBMS and Oracle on Sun Solaris Sparc (2.8). On-call support to all production servers.
• Developed and implemented teh instance strategy for teh development, QA and Production databases. Performed database administration functions including object sizing, tablespace maintenance and overall disk space management.
• Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.
• Database Recovery Application of client, forms and database server patches.
• Tuning of customized application including reports and back-end customization by using different application tuning techniques.
• Performed application system administration functions including user application setup, assigning
• Responsibilities, GUI Menu customization. Creation of concurrent programs.

Confidential

Database Administration

Responsibilities:

• Upgraded oracle application from Rel 11.0.2 to 11.0.3 on HP UNIX.
• On-call support to all production servers.
• Developed and implemented teh instance strategy for teh development, QA and Production databases. Performed database administration functions including object sizing, tablespace maintenance and overall disk space management.
• Installation of oracle 7.3 on HP-UNIX.
• Database Administration and tuning.
• Tuning of application and memory.
• Creating backup and recovery strategies.

Confidential

Database Administration

Responsibilities:

• Installation of 11.0.3 on HP UNIX. On-call support to all production servers.
• Developed and implemented teh instance strategy for teh development, QA and Production databases. Performed database administration functions including object sizing, table space maintenance and overall disk space management.

Confidential

Database Administration

Responsibilities:

• Shifted production database from ingress to Oracle 8 using sql loader.
• Design and creation of database.
• Responsible for taking logical backups and tuning of database, application.
• Responsible for Oracle networking.

Confidential

Database Administration and Financial Accounting

Tools: Oracle, Developer 2000

Responsibilities:

• Responsible for maintenance & up gradations.
• Creating Backup and recovery
• Tuning of application
• Sales Management comprising of Customer Orders, Indent tracking, Invoicing and Sales Analysis
• Inventory management comprising of Purchase tracking, Stock Monitoring for analysis of inventory, Trial Balance, Expenses incurred towards official activities and Amounts received and given towards invoices and purchases respectively.
• This system takes care of teh activities such as
• Information relating to teh employee, Information of customer, Monthly payroll, Processing arrears, Salary advance, Keep track of leaves & tours etc, General ledgers.