SUMMARY

• Experience in setting up an Oracle 9i RAC environment in a cluster file system using VERITAS storage foundation as well as setting up Oracle 10g/11g/12c RAC on Oracle ASM.
• Experience in data modeling using ERWIN and server - side application development using SQL, PL-SQL.
• Experience in migrating databases from file systems to ASM.
• Experience in upgrading/migrating the 9i RAC to 11g/10g/12c RAC.
• Expertise includes Oracle Applications (e-Business Suite 11i/12), Architecture/Design of custom applications and Databases on Unix/Linux//NT platforms in ensuring Quality, Integrity and Availability of the Company’s data within Oracle Server.
• Experience with many Installations, Configurations, Up-gradations, Platform Migration, Administration and Patching of Oracle Applications (R12) and Oracle databases.
• Experience in Installations, configurations, Administration and patching of 10gAS, 9iAS and Oracle Web Application Servers.
• Performing routine Oracle Applications maintenance and configuration: Autoconfig, clone, patching, and technology stack upgrade, and gathering statistics for CBO.
• Delivering performance-tuning services for customers with tkprof, SQL trace 10046, custom scripts and wait interface.
• Knowledge on Oracle SSO / OID configuration with E-business suite.
• Troubleshooting and resolving critical production issues in complex application environment: SQL*net connectivity issues, locking, latching, database hang issues, OS/network issues, concurrent manager issues.
• Good knowledge of RAC (9i /10g/11g) and applications 11i/R12 on Single Instance and RAC environment.
• Developing standard DBA procedures and practices.
• Worked with version control systems like PVCS and CVS.
• Proficiency includes Engineering and Architecture of Oracle, Resource management, and Security management, Tuning, Clustering, Backup and Recovery. Expert level Knowledge of Relational and object oriented Databases. Good Exposure to Oracle Database Architecture and Optimal Flexible Architecture (OFA).
• Knowledge in administration, management of Operating Systems like Sun Solaris 9/10, AIX 5.2/5.3, HP-Unix, and Windows NT 4.0
• Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards.

TECHNICAL SKILLS

Oracle products: Solid knowledge of Oracle technology and products including Oracle database 9i/10g/11g, Oracle Applications R11i /R12, Installation, upgrade and configuration, Oracle SQL*plus, PL/SQL, Oracle Server v7.3.x, v8.x, v8i, v9i, 10g, 11g, RAC, ASM, Stats Pack, SQL Loader, RMAN, Standby Database, Data Guard, Replication, Oracle Internet Directory, Oracle Advanced Security, Oracle Application Server 10gAS, Developer 2000 Suite, OEM (Oracle Enterprise Manager), OAM, Label security, VPD.

OS & Hardware: Solaris 8/9/10, AIX 5.2/5.3, HP-UX 11/11i, Linux (Red hat 4/5/6), Oracle Linux, Novell NetwareWindows 95/98/NT/XP/2000/2003, Sun T5220/M5000, IBM P4/P5

Other Products: Shell Programming, UNIX, OEM, Java, C, PVCS, TOAD, .Net, and VB

PROFESSIONAL EXPERIENCE

Confidential

Lead DBA -- Oracle DBA

Responsibilities:

• Tuning SQL Statements, Dataload processes and application(s) design.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Helped customers with server sizing and capacity planning.
• Migrate/upgrade the Oracle 9i RAC infrastructure to Oracle 10g/11g RAC on Oracle ASM.
• Worked on the fresh installation/setup of 10g/11g/12c RAC in ASM and set the guidelines for another DBA.
• Worked on the MAA (Maximum Availability Architecture) by combining the Oracle RAC with Standby (Data Guard) to get the maximum availability to avoid single point of failure.
• Some experience on SQL*Server; example: Created databases on SQL-Server using enterprise manager.
• SQL-Serer, database cloning using enterprise manager
• Worked on developing procedures using T-SQL
• Worked on setting up backups on SQL-Server
• Used the SAN (EMC) level backup solution using EMC clone/BCV for data warehouse environments.
• Worked with Developers in architecting the Partitioning mechanism for data warehouse databases.
• Worked on migration of some non-e-business suite databases from Sun/AIX to Linux environments.
• Worked as a team lead to streamline the CPU patch analysis and patch management across environments with the help of developers/functional support
• Monitored and effectively tuned the Apps 11i database instances by utilizing own scripts, OEM for Oracle and the StatsPack/AWR utilities.
• Implemented Secured Socket Layer (SSL) in the 11i E-business applications suite to enable data encryption between the client and the middle-tier layer.
• Provide day to day database support like executing database related tickets from Remedy.
• Worked on Oracle Enterprise manager to analyze and monitor the database performance and for DBA activities.
• Provided DBA support in many implementations including customer and item loads.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered the 11i instance production database as a result of data corruption by successfully applying the archive redo log files
• Installed third party components in Kaiser Environment like Clear Quest, Requisite Pro etc.
• Upgraded some production databases from 8i to 10g R2.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Worked with business to create the data model, process flow model etc using Data Modeling tool ERWIN
• Worked with Developers, Analysts to streamline the processes of Kaiser releases from database perspective
• Worked on RCA (Root Cause Analysis) and give the guidance on performance tuning both from application side as well as from database side.
• Worked with customer/business to understand the business needs and presented the solution diagram/Process flow/Data flow etc using data modeling tool ERWIN.
• Researched and applied the DST patches on Oracle RDBMS.
• Configured Oracle 11i E-business applications suite with AutoConfig
• Cloned environments to create patch test, development and QA environments
• Other activities like applying RDBMS patches, security patches (CPUs), proactive monitoring of databases.
• Helped customers with server sizing and capacity planning.

Confidential

Sr. Principle Consultant (Oracle APPS DBA /Oracle DBA)

Responsibilities:

• Implemented multiple servers in the middle-tier layer of the Oracle 11i E-business applications suite. The middle-tier layer was then load-balanced by leveraging Cisco’s Content Services Switch (CSS) technology. This was done to provide both the scalability and high availability where multiple servers were used to provide redundancy/availability to avoid a single point of failure and load-balancing was used to scale up the middle-tier layer for large number of concurrent user connections.
• Worked in a team environment to implement SSO/OID with E-business suite.
• Configured Oracle Portal and integrated it with E-business suite.
• Worked on Oracle Enterprise manager to analyze and monitor the database performance and for DBA activities.
• Tune SQL Statements, Data load processes and application design.
• Monitored and effectively tuned the 11i database instances by utilizing own scripts, Precise In-depth for Oracle and the Stats Pack/AWR utilities.
• Implemented Secured Socket Layer (SSL) in the 11i E-business applications suite to enable data encryption between the client and the middle-tier layer. This was first implemented and tested in the lab and then promoted to production.
• Configured the Apache server of the Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of fewer JVMs
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Design and tested high availability architecture for Oracle 11i application with RAC on OCFS.
• Upgraded the 11i Oracle RDBMS instance to 64-bit on Solaris 2.8. This was done so that the System Global Area (SGA) could be scaled up beyond the 3.2 GB boundary limit imposed by the 32-bit RDBMS. This was also implemented as a pre-requisite task to implementing Quick I/O, ODM (Oracle Disk Manager) or RAW devices to allow these technologies to take advantage of the larger Oracle cache while providing efficient I/O. This was first implemented and tested in the lab and then promoted to production
• Configured Oracle 11i E-business applications suite with AutoConfig
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered the 11i instance production database as a result of data corruption by successfully applying the archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed the promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Implemented database auditing, data security and Remediate high-risk violations in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
• Helped customers with server sizing and capacity planning.
• Involved in implementing sound backup/recovery strategy using RMAN.

Confidential

Principle Consultant Oracle DBA

Responsibilities:

• Upgraded multiple Oracles 9i to Oracle 11g R1.
• Besides in-place upgrade we also did platform migration for some small database from HP to Linux and Windows to Solaris.
• Supported production databases after the migration and upgrades before handling operations to in-house DBAs.
• Developed and streamlined Backup, restore processes.
• Development cloning scripts.
• Tune SQL Statements, Data load processes and application design.
• Monitored and effectively tuned the 11i database instances by utilizing own scripts, Precise In-depth for Oracle and the Stats Pack/AWR utilities.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered the 11i instance production database as a result of data corruption by successfully applying the archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed the promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Implemented database auditing, data security and Remediate high-risk violations in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
• Helped customers with server sizing and capacity planning.

Confidential

Principle Consultant (Oracle APPS DBA /Oracle DBA)

Responsibilities:

• Implemented multiple servers in the middle-tier layer of the Oracle 11i E-business applications suite. The middle-tier layer was then load-balanced by leveraging Cisco’s Content Services Switch (CSS) technology. This was done to provide both the scalability and high availability where multiple servers were used to provide redundancy/availability to avoid a single point of failure and load-balancing was used to scale up the middle-tier layer for large number of concurrent user connections.
• Worked in a team environment to implement SSO/OID with E-business suite.
• Configured Oracle Portal and integrated it with E-business suite.
• Worked on Oracle Enterprise manager to analyze and monitor the database performance and for DBA activities.
• Tune SQL Statements, Dataload processes and application design.
• Monitored and effectively tuned the 11i database instances by utilizing own scripts, Precise Indepth for Oracle and the StatsPack/AWR utilities.
• Implemented Secured Socket Layer (SSL) in the 11i E-business applications suite to enable data encryption between the client and the middle-tier layer. This was first implemented and tested in the lab and then promoted to production.
• Configured the Apache server of the Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of fewer JVMs
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Design and tested high availability architecture for Oracle 11i application with RAC on OCFS.
• Upgraded the 11i Oracle RDBMS instance to 64-bit on Solaris 2.8. This was done so that the System Global Area (SGA) could be scaled up beyond the 3.2 GB boundary limit imposed by the 32-bit RDBMS. This was also implemented as a pre-requisite task to implementing Quick I/O, ODM (Oracle Disk Manager) or RAW devices to allow these technologies to take advantage of the larger Oracle cache while providing efficient I/O. This was first implemented and tested in the lab and then promoted to production
• Configured Oracle 11i E-business applications suite with AutoConfig
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered the 11i instance production database as a result of data corruption by successfully applying the archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed the promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Implemented database auditing, data security and Remediate high-risk voilation in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Helped customers with server sizing and capacity planning.
• Involved in implementing sound backup/recovery strategy using RMAN.

Confidential

Senior Information Specialist (Sr. Oracle DBA)

Responsibilities:

• Involved in Oracle Applications R11i installation/upgrade and system configuration.
• Worked with development team for proactive tuning at application design stage and tuning data loading processes.
• Monitore application/database performance with OEM, Statspack and Precise Indepth.
• Monitored and effectively tuned the 11i database instances by utilizing own scripts, Precise Indepth for Oracle and the StatsPack utilities.
• Tune application/SQL statements using tkprof and explain plan, oracle profiler and using wait interfaces.
• Write standard DBA procedures and practices.
• Evaluated different Oracle and Internet technologies and solutions.
• Design and tested high availability architecture for Oracle 11i application with RAC on OCFS.
• Diagnosed and troubleshoot different aspects of Oracle Application system.
• Configured the Apache server of the Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of fewer JVMs
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Configured Oracle 11i E-business applications suite with AutoConfig
• Cloned environments to create patch test, development and QA environments
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered the 11i instance production database as a result of data corruption by successfully applying the archive redo log files
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Involved in implementing sound backup/recovery strategy using RMAN.