SUMMARY

• Over 10 years of Oracle DBA/APPSDBA experience with (7) years in the US as an Oracle Applications DBA, Lead DBA, Sr Oracle DBA in release 12, 11i, with Oracle RDBMS 11g, 10g, 9i, and 8i.
• Rich consulting experience with recognized companies: Confidential, Confidential Systems, Confidential .
• 10+ years of Oracle Database Admin, over 8+ years of E - Business Suite 11i experience.
• 3+ Years of Oracle E business R12 Experience with I modules.
• Proven experience in managing large databases with sizes over 10 TB.
• Performance expert in Oracle RAC, Grid Control, utilities include TKPROF, EXPLAIN PLAN,ORADEBUG, ADDM, AWR, ASSM, ASM, DBMS ALERT, DBMS SUPPORT, RDA, HANG ANALYZE, TRUSS, PSTACK, SAR, SADC, VMSTAT.
• Extensive knowledge and proven experience in all phases of E-Business Suite 11i implementation and software development life cycle.
• Managed projects using project management and implementation methodologies.
• Proven experience in developing change management procedures, help desk systems and SLAs to ensure the highest level of client satisfaction is achieved.
• Experienced in developing mission-critical E-Business Suite environments with 10g, 10g DataGuard, standby database and multi-tier.
• Experienced in NetApp, Hitachi, EMC, Veritas, Comvault (NAS & SAN) storage technologies and backup solutions.
• Expertise in Sharepoint SOA, Oracle Fusion SOA/ODI/BPEL installations and configurations.
• Installed Oracle Databases 9i,10g,11g on Oracle Enterprise Linux with Oracle VMWare virtualization software
• Experienced on Oracle Identity Manager 11g deployment, configuration, and custom connector development
• Worked on in-progress Oracle Identity Manager application integration workstream
• Oracle Identity Manager and Oracle Virtual Directory implementations.
• Managing audit log management.
• Willingness to work non-prime shift hours, including weekends and holidays to accommodate project deadlines.
• Self-directed, self-motivated with strong problem solving and customer service skills.
• Proven experience in forecasting the project and task scope, and communicating forecast and progress to associate members and interested parties.
• Oracle Applications 11i and R12 implementation and upgrade Knowledge in an Oracle R12, Demantra.
• Experience in Demantra integrates with Oracle E-Business Suite (EBS)
• Starting, stopping and clearing the cache of Weblogic servers.
• Deployed various WAR, EAR, JAR applications in Domain and clustered environments.
• Server log and Domain log monitoring, application deployment and performance tuning of Weblogic.
• Setting the JVM parameters like maximum and minimum heap size in Weblogic startup scripts.
• Involved in setting JVM parameters for optimum performance
• Upgraded jvm 1.6 to 1.7

TECHNICAL SKILLS

RDBMS: 8i 9i, 10g, 11g.12c

Operating System: AIX 5.3,6.1,7.1, Linux, OEL, Oracle VM, VMware

Languages: SQL, PL/SQL, Shell programming

Backup Solutions: RMAN, Veritas Netbackup, Comvault, NetApp Snapshots, Flexclone, EMC BCV

Applications Tools: Kintana, AppsDynamics

Change Control: PVCS GUI Version and, Kintana, Remedy

Performance Tools: TKPROF, STATSPACK, RDA and APIs

Development Tools: CUSTOM.pll, Developer 6i,10g

Monitoring Tools: Quest Spotlight, BMC Patrol, TOAD DBA, 10G OEM GRID, OAM

Replication Tools: Oracle Materialized Views & Quest Shareplex Replication

Disaster recovery Tools: Quest Sharplex and Oracle Standby database, Data Guard

Application Server & Middleware: OAS 4.0, Oracle HTTP Server, 9iAS 1.0.2.2.2, 9iAS 9.0.2, 10gAS, Tomcat, IIS, WebLogic, TIBCO, OAM,OIM,OID,Fusion SOA suite, Oracle Data Integrator.

Budgeting & Planning: ASCM,VCP, Demantra

SOX: Logical Apps

Single SignOn: Oracle 10g OID, 10gAS Single Sign-on with SSL

PROFESSIONAL EXPERIENCE:

Sr. Oracle Applications DBA

Confidential

Responsibilities:

• Worked on upgrade 11.5.10.2 to R12.2.4 with database 11.2.0.3
• Rebuilt Database indexes and table re-org.
• Created Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Applying patches using ADOP
• Support on Demantra, VCP and configuration.
• Workflow mailer configuration and support for wf related issues.
• Worked on boundary systems(created Test,Dev,Uat environments)
• Performs software installation and configuration, including upgrades and applying patches
• Resolving Datagaurd DR site sync issues
• Support for Oracle VCP Module(s) - Demantra and ASCP
• Experience in scheduling and performance of regular database maintenance such as cloning, rebuilding indexes, tables and data file additions. trouble shooting skills and experience in Oracle Applications R12 and 11i for EBS and VCP
• Addressing various teams with daily issues on concurrent tier programs, forms, jserv and apache of Oracle Applications 11i (11.5.10.2)
• Applied patches including both one-off patches using OPatch as well as patch sets.
• Refresh/Cloning of database and applications for development and testing purpose.
• Performed various database (10.2.0.3) and Oracle Applications 11i (11.5.10.2) Cloning and Patching
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Troubleshooted the log running concurrent requests
• Monitored and tuned JVMs, JVM heap size, garbage collections, Java stack and Native thread results in
• Performed various database (10.2.0.4) and Oracle Applications 11i (11.5.10.2) Cloning and Patching
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Performed POC for 11i(11.5.10.2) to R12(12.2.4) Upgrade and cloning
• Experienced in Oracle Demantra 7.3 .Installation, Configuration and Integration with Oracle EBS. experience in Oracle Demantra suite, Oracle ASCP and Oracle BI experience in maintenance of large size databases ( 500 GB to 10 TB)
• Experience with R12.1.3 and R12.2
• Upgrade oracle apps database from 11.5.10.2 to R12.2.4
• Expertise in cloning different instances of 11i and R12.2.4
• Good understanding of database migration and schema migration activities
• Experience in Demantra and Oracle VCP implementation and support
• Export and import various level of Demantra, WDC schemas.
• Configured AppDynamics tool for R12 (OACORE,FORMS,OAFM deployed on managed servers) including EUM.

Sr Oracle Applications DBA

Confidential

Responsibilities:

• Administering 10g (10.2.0.2), 11g (11.1.0.7) databases with over 2TB in size.
• Migration of Eusiness11i from VCS/VCFS/SUN to 12.0.2/10gRAC/ASM/Linux.
• RAC(Real Application Cluster) Implementation with Data Guard.
• Configuring shared storage(SAN), Setting up Private and public interconnect.
• Installing 10g Cluster ware, ASM, Oracle 10g Database, Configuring Data Guard.
• Implemented Oracle Streams and Materialized Views.
• Configuring and Monitoring RMAN and Hot backups and performing recoveries.
• 10g RAC production support, E-Business production support.
• Logical Apps GRC implementation, Demantra integration with ASCP environment.
• Extensively used AWR, ADDM, STATSPACK, TRUSS, ORADEBUG, RDA, SQL Profiling, Outlines, Quest SQL Lab Expert for the SQL & Instance tuning.
• Implemented the database archiving through partitioning. Defragmented the data warehouse environment using custom scripts and Quest space manager.
• Applied CPU patches, RAC 10g CRS rollup patches.
• Installed and configured R12 end-to-end with SOX compliance audit controls through Oracle Governance, Risk and Compliance (GRC) formerly known as Logical Apps.
• Installed the application controls through Access Governor, Transaction Governor, Configuration Governor, Preventive Governor Supports all R12 and GRC Infrastructure Controls through Role Manager and Universal Content Management.
• Installed and R12 configured modules Oracle Istore, I receivables, Bill to Pay, I payment with verisign SSL.
• Exprerience on profile administration, identity linking, reconciliation.
• Worked on OAM integration with EBS 11i.
• Privileged Access Management, Authentication and Authorization, Security and Provisioning Identity Data
• Responsible for documenting, designing and administering the IAM infrastructure.
• Support to security and develop appropriate audit controls and procedures to ensure the integrity of applications
• Worked extensively with R12 workflow and workflow mailer and workflow builder and other workflow API’s.
• Applying Patches (One-off, Minipack, Familypack, maintenance packs, CPU) to Oracle Applications using ADPATCH during monthly maintenance window.
• Automated the cloning and refresh of Ebusiness Applications with NetApp Flexiclone and oracle rapid clone and automated scripts.
• Installed and Configured OID with RAC database and integrated with Oracle Ebusiness R12 to implement single-sign-on feature with Microsoft LDAP.
• Installed OBIEE for Business Intillegence implementation and integrated this with portal and single sign on. Development, System Test, Staging and pre-production.
• Starting, stopping and clearing the cache of Web logic servers.
• Hands on experience with performance tuning.
• Setting the JVM parameters like maximum and minimum heap size in Weblogic startup scripts.
• Involved in setting JVM parameters for optimum performance
• Created new file system, monitoring free space, disk usage, locating files, checking and clearing log files, administration and monitoring of disk based file system
• Strong experience in configuring and administering Connection Pools for JDBC connections, JMS server with IBM MQ series in WebLogic and JMS connection factories
• Configured and administered JDBC, JMS, and Node Manager to administer the Managed Servers in WebLogic Application Server
• Monitoring tablespace usages.
• Monitored and tuned JVMs, JVM heap size, garbage collections, Java stack and Native thread results in Development, System Test, Staging and pre-production.
• Customizing autoconfig templates according to the environment requirements.
• Upgrading JDK versions from 1.4.2 to 1.5 and 1.6
• Monitoring Database alert log for errors, tablespace usage, cpu consumption, long running jobs and blocking locks.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Installed, Configured and Administered Oracle Application Server 10.1.3.4 with SOA Suite
• Installed, Configured and deployed SOA BPEL, ESB on single node and cluster node.
• Involved in conducting sessions for fellow DBAs in administering Oracle databases 10g technology

Oracle Applications DBA

Confidential

Responsibilities:

• Configured RMAN Backups and Clones using scripts.
• RMAN used in recovery, hot and cold backup of Oracle10G, 11G database.
• 11g RAC with ASM installation, configuration, administration and troubleshooting issues
• Cloned and Patched Oracle Applications 11.5.10.2.
• Production Assessment Tests and maintained to the global standards
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Planned and Administration of backup and recovery strategies.
• Created and Managed Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Rebuilt Database indexes and table re-org.
• Customized autoconfig templates according to the environment requirements.
• Created Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP
• Tuned the slow running concurrent requests
• Registered the new Forms, Reports, pl/sql scripts as concurrent programs as part of technical.
• Created and Managed Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Upgraded database from 9.2.0.8 to 10g
• Rebuilt database indexes the disaster recovery environment for ebusiness using 10g data guard.
• Wrote the procedures and custom scripts to eliminate the manual steps involved in cloning of oracle applications.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database).
• Statistics gathering, Transaction Tuning, Back-End Tuning andTech-Stack tuning.
• Implemented Oracle Grid 10g and Registering all Oracle Applications and Databases services in grid.
• Taking necessary steps to keep the instance in compliance with the SOX and implement recommendations of auditors.
• Implemented single sign on(SSO) for Oracle Applications 11.5.10.2.

Confidential .

Oracle System Admin & Apps Dba

Responsibilities:

• Implemented/Automated the DAILY CLONE INSTANCE (DCI) to meet the SOX requirements.
• Successfully supported the SOX project to make sure that all the security deficiencies were covered and fixed.
• Implemented the proactive monitoring system to monitor the database using 10G GRID monitoring tool.
• Implemented the Oracle collaboration suite to meet the ongoing IT file management requirements and document control requirements of SOX.
• Configured the disaster recovery instance in a remote site location with dataguard.
• Installed & Implemented Applimation Integra code base for version/change control.
• Implemented the shared APPL TOP to reduce the patching downtime.
• Applied several mini-packs, family packs, interoperable patches, stand alone bug fixes for ERP applications.
• Installed Applimation Informia Archive & Data Subset products to implement archiving for the Ebusiness11i and to create subset copies of the production database to minimize the storage requirements for test/dev/project environments.
• Automated the backups using veritas checkpoints for development environments and RMAN and BCV’s for the production environment.
• Implemented the NetApp Volcopy and Snapshots to automate the data transfers.
• Worked with SQL Server 2000 and SQL Server 2005 Servers with LAWSON HRMS systems.
• Applied several mini-packs, family packs and stand alone patches in non interactive mode to reduce the patching downtime.
• 24*7 on call production support in VCS/VCFS hardware clusters environment supporting global rollout of Ebusiness Applications with over 1000 concurrent users.
• Defined the custom concurrent managers, implemented the specialization rules and custom workshifts for concurrent managers workload management
• Extensively used TKPROF, DBMS SYSTEM, ORADEBUG, TRUSS, RDA, STATSPACK, EXPLAIN PLAN for SQL & Instance tuning.
• Supported the data conversions across projects billing and projects costing and receivables and other financials modules.
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• SQL tuning using SQL Trace and TKPROF, explain plan and SQL Analyze.
• Tuning init.ora parameters for optimal performance and scalability. Running statspack to figure out where the bottleneck is and where most of the CPU time is going.
• Knowledge of Oracle Identity Manager, Access Manager, OVD, OID, Oracle Identity Federation, Java, J2EE, SOA, Oracle Fusion Middleware, Single Sign-on
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Performance tuning and Monitoring using Grid Control database & managing instances using OEM.
• ORACLE TAR Management: Raised and monitored TAR s with Oracle Corporation for issue resolutions.
• Weekends on call support & database backups using RMAN on tape and Disk.
• Custom code migrations to Test and PROD environments

Confidential

Junior Oracle DBA/ Developer

Responsibilities:

• Installed and configured ORACLE 9i on LINUX and Solaris.
• Worked in development & support for Oracle based systems and Unix based Server environments
• Database upgrades from 8i-9i and 9i-10g upgrades.
• Monitored database for fragmentation and correcting them.
• Planned and implementation of Backup and recovery procedures and maintenance of Database.
• Installed, maintained and administered Oracle Databases for Developers & testers.
• Performed backups and recoveries using hot & cold backups and maintained remote databases.
• Developed shell script to automate the processes.
• Monitored growth of tables and undertaking necessary re-organization of database as and when required.
• Monitored scheduled jobs of the daily activities for the performance of all the databases.
• Prepared documents of the process and knowledge transferring about the project to the new team members.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Database export/import using exp and imp utilities.
• Data loads using SQL loader utilities.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.