SUMMARY

• Highly proficient IT professional with 15 years of hands on experience in Middleware Admin /Oracle DBA/ PeopleSoft Admin/E-Business Suite Oracle Apps DBA and 20 years of Unix/Linux experience with Shell/Perl/Python scripting.
• Oracle 11g Certified Professional OCP with both Master degree in Computer Science and Master degree in Mathematics.
• Solid experience as PeopleSoft Admin, Exadata/Exalogic/Exlytics DBA, Fusion Middleware Admin, WebLogic Admin, Oracle Apps DBA, RAC DBA, Performance Tuning Specialist, OEM Cloud Implementation Specialist, SOA Architect.
• AS Senior Oracle Fusion Middleware Admin/SOA Architect,
• Installed, configured, and maintained Oracle Fusion Middleware with SOA Suite 11g, OID, OVD, OAM, OIM, OBIEE, WebCenter with WebLogic.
• Integrated ERP applications like PeopleSoft, E-Business Suite and Portals with various LDAP products.
• Architect and Install SOA Suite 11.1.1.7 with Oracle OSB on Solaris 11.
• Configure Node Manager to start admin server and managed servers for WebLogic domains.
• Install and configure multiple SOA/OSB WebLogic domains, clusters and OHS for high availability.
• Configured WebLogic cluster for high availability and load balancing.
• Build WebLogic templates with Domain Template Builder.
• Create WLST/Jython script to monitor SOA adapters, data sources and end points and convert to OEM 12c metric extensions.
• Configure WLST scripts to connect WebLogic domains with user configure file and user key file.
• Customize wlst.sh script to integrate with OEM 12c Cloud Control.
• Configure SOA targets for OEM 12c with SOA Management Pack Enterprise Edition.
• Setup and configured Oracle Internet Directory OID .
• Install, upgrade and configure Oracle Fusion Middleware 11g from 10g.
• Install and configure SOA Suite 11.1.1.7,11.1.1.3.
• Upgraded Oracle Identity Manager from 10g to 11g.
• Install Oracle Service Bus 11.1.1.7
• Create gold images for SOA WebLogic domains and use it for provisioning.
• Installed, configured and troubleshoot Oracle Internet Directory, Oracle Virtual Directory, and Oracle Access Manager with WebGate.
• Involved in the configuration of SSO with Oracle Access Manager.
• Patch/Upgrade Oracle Identity Manager from 11.1.1.2 to 11.1.1.3.
• Disable SSL v2.0 for IIS and Tomcat.

AS Senior PeopleSoft Administrator, Security Admin, Portal Admin, Upgrading Specialist,

• Supported and Upgraded multiple HCM, Campus Solution, PeopleSoft Financials FSCM, EPM, ELM etc.
• Setup and deployed PeopleSoft Single Sign On between PeopleSoft Portal, HCM, Financial, EPM and etc.
• Architect, configure and setup External Single Sign-On with Active Directory, Tivoli Access Manager, Oracle Access Manager and Kerberos.
• Performed PeopleSoft Application upgrade HCM 8.8 to 9.0, HCM8.9 to 9.1,HCM9.0 to 9.2 and PeopleTools upgrades 8.46 to 8.49, 8.49 to 8.52, 8.53 with Change Assistant.
• Experienced in developing upgrade project plans including identifying tasks, resources required estimation of time and effort.
• Extensive tuning experience on batch jobs and online processes for PeopleSoft applications.
• Successfully performance tuned PepleSoft HR/CS/FSCM batch jobs and online components from days to hours, from hours to minutes, from minutes to seconds and from seconds to split of seconds.
• Configured PeopleSoft Integration Broker for messaging failover.
• Setup and configured PeopleSoft web servers, app servers, batch servers and databases for load testing.
• Involved in load testing by creating application users, modify application data, refreshing database for Load Runner and troubleshoot.
• Installed PeopleSoft Internet Architecture PIA instances for various PeopleSoft/Oracle Database Instances, which includes Web Server, Application Server, Process Scheduler, and configuration of report distribution.
• Install and setup WebLogic, Oracle application server and Websphere.
• Extensive experience in PeopleSoft Troubleshooting of spinning/hanging, user kicked out, page no opening, menu noshowing etc etc.
• Expertise in applying Maintenance Packs, Tax Updates, Patches and bundles.
• Installed BEA Tuxedo, People Tools, Weblogic, COBOL, Change Assistant, Crystal Reports, People Books.
• Setting up Verity search indexes including File System Content Indexes for searching published content.
• Installed and configured Web Logic Server 8.1, 9.2, 10.3.6 and applied patches.
• Manage and apply SSL certificates to WebLogic web server domains.
• Monitored the Server and Client queue status at several tuxedo domains.
• Installed People Books and configured the Web Server to access PeopleBooks. Configured the context sensitive help.
• Setting up Environment Management Framework EMF and setting up Change Assistant for updates.
• Implemented reverse proxy with Apache, WebLogic, IIS and so on for exposing the application on the internet.
• Configured, sized web logic PIA for load balancing and performance tuning.
• Tuned WebLogic with heap size, session pool, pagelet parallel loading, logging level etc to improve user experience.
• Migrated PeopleSoft Projects from Development Database into QA Testing Database and then into Production on daily basis.

AS Lead Oracle DBA,

• Installed, deployed and supported Oracle Grid/RAC 11g Release 2 on Linux 5 and AIX 6.1 with ASM at different clients.
• Configured, tuned and supported Exadata database and storage machines.
• Planed, Configured, Set up and Supported high availability and high scalability Oracle 10g RAC on Red Hat Linux and IBM AIX 5.3 with ASM.
• Upgraded 11gR2 grid infrastructure as out of place patch. Applied patches on Oracle 11g/10g Clusterware and RAC databases.
• Extensive experience with rolling patches on 11g/10g grid/RAC. Applied numerous PSU, CPU, Patch set and one off patches to RAC, ASM and databases.
• Configured and troubleshoot ASM Cluster File System ACFS for 11gR2 Grid/RAC cluster.
• Configured, tested and supported Oracle Data Guard RAC standby for RAC primary and standalone standby for RAC primary. Experience with set up Logical Standby.
• Installed, configured and supported Oracle 10g and PeopleSoft on IBM Mainframe ZLinux.
• Installed and configured Oracle E-Business Suite R12/11i.
• Lead in Data center relocation which migrates databases on standalone AIX/Solaris/Windows servers on file system to RAC on ASM on Linux.
• Expert in performance tuning of all types of Applications including PeopleSoft, E-business Suite, SAP, Siebel, Ariba, IDMS, FileNet with AWR, ADDM, ASH, SQL Plan Management, SQL Tuning advisor, SQL Access advisor, Memory advisor, Segment Advisor, SQL Trace and TKProf, StatsPack, TraceMagic.
• Installed, configured and upgraded Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, and monitoring.
• Configure Auditing on Oracle database to suite needs of security and managements.
• Lead in database architecture design and implementation with best practice.
• Designed reliable, space and time efficient RMAN backup strategy. Plan and implemented RMAN backup under Data Guard situation. Coded various RMAN report scripts to report backup stats like time taken, compression ratio, backup set sizing, backup level, job status etc.
• Implemented GoldenGate bidirectional Replication with conflict resolutions. Configured Extract, Replicat processes. Configured live standby database and implemented zero down time upgrading with GoldenGate.
• Worked in Data Warehouse environments and successful tuned nightly loads to data warehouse databases.
• Created Hash sub-partitions within the existing Range partitions to use Partition pruning on SQL. Implemented indexes strategies using bitmap and local indexes and enabled star transformation to improve performance of the Data Warehouse.
• Implemented data compression to reduce storage and improve performance for certain queries.
• Support SQL Server databases and performance tuning with database engine tuning advisor.
• Implement Oracle TDE column encryption for advanced security.
• Experience with custom code migration, applications setup and supporting developers.
• Experience in Capacity Planning, Space Management and Storage Allocation.
• Experience with PL/SQL, Shell script, Perl, Python,JAVA, JSP, Java Script, C , C, COBOL, SQR, People Code, App Engine, Data Mover Script.

Programing/Developer experience:

• Developed BPEL programs for integration different applications with SOA.
• Developed and debugged file processing programs with Java J2EE.
• Experienced in developing online shopping cart with JSP and Java Beans.
• Developed dynamic web pages with JavaScript and HTML.
• Coded various functions, procedures, packages, triggers with PL/SQL.
• Developed Perl scripts for Monitoring, Backup and Refreshes.
• Debugged and fixed COBOL program for PeopleSoft applications.
• Modified App Engine programs and SQRs for stats collection to improve performance.
• Developing Unix/Linux Shell/Perl/Python Scripts for over 20 years.

EXPERIENCE

Confidential

Senior Lead PeopleSoft Admin/Oracle DBA/Performance Specialist/Exadata DBA

Responsibilities:

• Configure write-back for Exadata storage machines to enhance performance.
• Configure SDP on Infiniband on Exadata and Exalytic machines.
• Added additional network, vip and listeners to delivered Exadata grid and configure database settings to listening on Infiniband via SDP.
• Install and configure IBM Tivoli Storage Manager 7.1 client and TDP Oracle agent on Exadata database machines.
• Setup and Configure Portal Solutions 9.1 to integrate HCM, Financials, EPM with Universal navigation work center.
• Configure Single Signon with Integration broker between HCM, Financials and EPM.
• Setup and Configure External Single Sign-On for PeopleSoft and Active Directory with Kerberos.
• Configure and test Directory, Authentication map, User profile map for Directory Interface.
• Support PeopleSoft HR, Financial and Interaction Hub/Portal Solutions 9.1, HCM 9.2 and FSCM9.2 with People Tools 5.3.
• Shrink PeopleSoft Financial database from 2TB to 1TB with Oracle Advanced compression.
• Out of place upgrade of Oracle Grid Infrastructure 11.2.0.3 to 11.2.0.4 and application latest PSU with ASM/ACFS.
• Converted single databases to RAC databases manually and with RConfig.
• Configure and resolved issues with SCAN, SCAN Listeners and VIP local Listeners for Grid
• Install and implement Oracle OEM 12c 12.1.0.4 with OBIEE 11.1.1.7 BI Publisher .
• Install OEM Agent by pushing to hosts and install locally with Agent Pull and Agent Deploy scripts.
• Configure OEM monitoring with Administration groups, dynamic groups, customized templates and metrics extensions.
• Performance tuning PeopleSoft Applications with Oracle Database with global settings like Linux HugePages, SGA/PGA sizing, initial parameters like cursor sharing.
• Created customized SQL Profiles with hints manually.
• Achieved super performance with table and index partitions for Large PeopleSoft and OBIEE tables.
• SQL Tuning with code rewrite, index creation, sql profiles, sql plan management etc.
• Architect, Configure and test Data Guard Fast Failover for high availability.
• Clone PeopleSoft environments including build new Web server, App Server, Process Scheduler, Database, Integration Gateway, sqrs and cobols.
• Configuring refresh scripts of PeopleSoft environments with RMAN and retaining PeopleSoft security, Oracle security, Report Repository, Integration Broker Configurations.

Environment: Oracle 12.1.0.2/11.2.0.4/11.2.0.3, PeopleSoft HCM9.2, FSCM9.2 Portal Solution 9.1, PeopleTools 8.53.11, 8.52, OEM 12.1.0.4, OBIEE 11.1.1.7. Oracle Linux 5.7,5.10, 6.3,6.5.

Database size: 500GB-2TB.

Confidential Senior Lead PeopleSoft Admin/Oracle DBA/Performance Specialist/Exadata DBA.

Responsibilities:

• Upgrade PeopleSoft HR and Campus Solution from 8.9 to HCM 9.2 and CS 9.0.
• Support, trouble shoot and performance tuning on PeopleSoft Financial and Supply Chain Management FSCM8.8.
• Installed and trouble shoot Oracle Grid Infrastructure 11.2.0.3 with ASM/ACFS.
• Configure and resolved issues with SCAN, SCAN Listeners and VIP local Listeners for Grid
• Install and implement Oracle OEM 12c 12.1.0.3 with OBIEE 11.1.1.6 BI Publisher .
• Performance tuning PeopleSoft Applications with Oracle Database with global settings like Linux HugePage, default block size, SGA/PGA sizing, initial parameters like cursor sharing and so on.
• Performance tuning customized views by rewriting SQL code.
• SQL Tuning with code rewrite, index creation, sql profiles, sql plan management etc.
• Architect, Configure and test Data Guard Fast Failover for high availability.
• Clone PeopleSoft environments including build new Web server, App Server, Process Scheduler, Database, Integration Gateway, sqrs and cobols.
• Configuring refresh scripts of PeopleSoft environments with RMAN and retaining PeopleSoft security, Oracle security, Report Repository, Integration Broker Configurations.

Environment: PeopleSoft HCM9.2, CS9.0, FSCM8.8 Portal Solution 9.1, PeopleTools 8.53.11, 8.49, SOA Suite 11.1.1.7, 11.1.1.4, OEM 12.1.0.3, OBIEE 11.1.1.6. Linux 5.9.

Database size: 50GB-10TB.

Confidential SOA Architect/Middleware Admin/OEM Cloud Admin.

Responsibilities:

• Configure SOA targets for OEM 12c with SOA Management Pack Enterprise Edition.
• Architect and Install SOA Suite 11.1.1.7 with Oracle OSB on Solaris 11.
• Configure Node Manager to start admin server and managed servers for WebLogic domains.
• Install and configure multiple SOA/OSB WebLogic domains, clusters and OHS for high availability.
• Create WLST/Jython script to monitor SOA adapters and end points and convert to OEM 12c metric extensions.
• Configure WLST scripts to connect WebLogic domains with user configure file and user key file.
• Customize wlst.sh script to integrate with OEM 12c Cloud Control.
• Install and configure Oracle BAM server.
• Clone WebLogic domains with pack and unpack utility.
• Create and configure WebLogic Domains, managed server and clusters for SOA and OSB.
• Install Application Dependence and Performance ADP engine on OMS servers.
• Install Application Dependency and Performance ADP agent on target WebLogic servers.
• Install JVM Diagnostic JVMD engine on OMS servers.
• Install and configure JVM Diagnostic JVMD agents on target WebLogic servers.
• Diagnosis WebLogic issues with Middleware Diagnostic Advisor in OEM 12c.
• Create and customize monitoring template for Oracle SOA infrastructure, SOA composite, BPEL Process Manager and so on.
• Install and integrate OBIEE/BI Publisher with OEM 12c.
• Create and configure BI Publisher reports to report SOA, OSB and so on.

Environment: SOA Suite 11.1.1.7, 11.1.1.4, OID/OVD 11.1.1.7, OAM 11.1.1.7, OEM 12.1.0.3, OBIEE 11.1.1.6.

Database size: 50GB-10TB.

Confidential Oracle Apps DBA, PeopleSoft DBA.

Responsibilities:

• Clone database and apps stack for Oracle Financial and E-business Suite.
• Install, set up and trouble shoot CC B frame work with third party softwares.
• Performance tuning with hints and partitions for complicated sqls on Oracle CC B applications.
• Migrate hash partitioned table with partitioned index and secure file lobs to different tablespaces.
• Clone database homes with OEM 12c provisioning.
• Applied PSU 11.2.0.3.8 for Oracle databases with OEM provisioning.

Environment: PeopleSoft HCM9.1, Oracle Financial, E-Business Suite 11.5.10.2. Oracle CC B 2.3, Solaris 11i with VCS.

Database size: 50GB-10TB.

Over 2000 databases.

Confidential Senior Lead Oracle DBA/PeopleSoft Administrator

Responsibilities:

• Planed high availability, high scalability Oracle Real Application Clusters RAC/Grid 11.2.0.3 Linux 5.8 with SCAN and ASM.
• Implement and manage SQL Plan Management for database stability and performance tuning.
• Upgraded various databases from 11.1.0.7 to 11.2.0.3.
• Install and upgrade OEM 12c cloud control 12.1.0.1-12.1.0.3 .
• Install OBIEE 11.1.1.6.0 and integrated it with Oracle OEM 12c.
• Setup multiple OMS behind load balancer for OEM High Availability.
• Configure OEM 12c monitoring with customized templates and email alerts.
• Create administration groups and sub groups, incident rule sets and blackouts in OEM.
• Setup OEM Metrics Extensions to utilizing existing shell scripts and sql scripts to alert PeopleSoft application server and Web server status.
• Import SSL cert to OEM agent and configure WebLogic domains as a middleware target to OEM 12c Cloud Control.
• Reconfigure OEM agent with agent pull, agent deploy after OMS migration and server clone.
• Backup and restore OEM configurations during Linux OS upgrading.
• Create BI Publisher reports from OEM for managements review.
• Install and setup Oracle database 12c.
• Created Container database and Pluggable databases.
• Configure and setup Oracle Database Replay to test performance for Oracle 11.2 upgrading and patching.
• Analyzing database replay result and compare to capture period for performance.
• Implement Linux Huge Pages to increase SGA performance and reduce swapping.
• Setup, test, document and trouble shoot Flashback database, flashback tables, and flashback queries.
• Setup and configure Oracle database auditing for security and reporting.
• Performance tuning with indexes, hints, reorganize segments, sql profiles and sql plan.
• Applied Oracle PSU patches to Oracle and PeopleSoft Infrastructure.
• Installed and configured Oracle Enterprise Manage Cloud Control 12c.
• Implemented GoldenGate Replication: Configured Extract, Replicate processes for GoldenGate.
• Set up and resolved various issues with RMAN backup scripts with TSM.
• Successfully restored databases in critical situations even without control file auto backup.
• Lead to implement policies and standards to improve efficiency of daily Oracle tasks.
• Assist developers to review and improve SQL, SQR, People codes.
• Configure and debug automation scripts for log cleaning, monitoring and backups.
• Upgrading PeopleSoft from HCM8.9 to HCM9.1.
• Applied PeopleSoft People Tools patch 8.52.13.
• Applied Tuxedo rolling patch 107.
• Installed WebLogic 10.3.6 and applied January 2013 PSU.
• Coded scripts for WebLogic monitoring with WLST and Python.
• Capacity planning for PeopleSoft HCM 9.1 upgrading and data center relocation.
• Create and configure Tuxedo application servers and process schedulers.
• Troubleshoot and resolve posting issues of process schedulers.
• Configure and setup Integration Broker for PeopleSoft environments.
• Create and implement SSL certificates for WebLogic web domains.
• Configure enterprise Single Sign On SSO with LDAP for PeopleSoft HCM9.1.

Environment: PeopleSoft HCM8.9, 9.1, PeopleTools 8.49/8.52 , Oracle 11.2/11.1, Linux 5.8, Weblogic 10.3.4/10.3.6, Tuxedo 10.

Database size: 50GB-500GB.

Confidential Senior Lead Oracle DBA/ Oracle Fusion Middleware Administrator/PeopleSoft Administrator/Architect/SQL Server DBA

Responsibilities:

• Setup and configured high availability, high scalability Oracle Real Application Clusters RAC/Grid 11.2.0.2 on IBM AIX 6.1 with SCAN and ASM.
• Planed, configured and upgraded Oracle RAC and ASM from 11.1.0.7 to 11.2.0.2 on AIX 6.1.
• Converted Stand alone databases on file system to RAC database on ASM.
• Resolve issues of automatic mount of ASM disk groups at server startup on grid.
• Trouble shooting and resolved 11g RAC VIP startup issues.
• Upgraded various databases from 10.1, 10.2 and 11.1 to 11.2.0.2.
• Applied Oracle PSU patches to Oracle RAC and databases.
• Installed and configured Oracle Enterprise Manage Cloud Control 12c.
• Rebuild Oracle Data Guard for various databases.
• Resolved various issues with RMAN backup scripts with Networker.
• Lead to implement policies and standards to improve efficiency of daily Oracle tasks.
• Lead in Oracle database architecture design and implementation.
• Restore and recover databases from full and incremental backups.
• Created and modified various Unix/Linux shell scripts for monitoring and backups.
• Lead database physical and logical design and analysis based on business requirements.
• Assist developers to review and improve SQL, SQR, People code, BPEL codes.
• Extensive experienced with tuning of SIEBEL long running sqls and batch jobs.
• Drastically improved OBIEE data warehouse batch job by table partitioning.
• Implement Oracle TDE column encryption for advanced security.
• Built, configured and supported various components of Fusion Middleware.
• Install, upgrade and configure Oracle Fusion Middleware 11g.
• Install and configure SOA Suite 11.1.1.3.
• Upgrade Oracle Internet Directory from 10.1.4 to 11.1.3.
• Installed Oracle Service Bus 11g.
• Installed, configured and troubleshoot Oracle Internet Directory, Oracle Virtual Directory and Oracle Access Manager.
• Manage and configure OID, OIM with Oracle Application Server.
• Configure Single Sign On with Oracle Access Manager.
• Install and configure WebGate 11.1.1.3 to support Oracle Access Manager.
• Patch/Upgrade Oracle Identity Manager from 11.1.1.2 to 11.1.1.3.
• Configure and debug automation scripts for log cleaning, monitoring and backups.
• Configure and debug SQL Server backup scripts.
• Setup and configure WebLogic cluster for high availability.
• Build WebLogic templates with Domain Template Builder.
• Migrated SQL Server databases from one server to another.
• Migrated and transfer data from SQL Server databases to Oracle databases.
• Provide 24/7 on-call support for Oracle Fusion Middleware and databases.
• Capacity planning for PeopleSoft Financials 8.9-9.1 upgrading.
• Create Tuxedo application servers and process schedulers.
• Troubleshoot and resolve posting issues of process schedulers.
• Developed and debugged file processing programs with Java J2EE.
• Experienced in developing online shopping cart with JSP and Java Beans.
• Developed dynamic webpages with JavaScript and HTML.

Environment: SIEBEL CRM 8.1, OIM 10.1.0.4/11.1.1.3, OID/OVD 11.1.1.3, OAM 11.1.1.3, SOA Suite 11.1.1.3, PeopleSoft Financials 9.1/8.8, PeopleTools 8.22/8.48/8.51 , PeopleSoft HCM 8.9/9.1 , Oracle Grid/RAC 11gR2/11gR1, Oracle 11.2/11.1/10g, SQL Server 2005/2008, AIX 6.1/5.3, Solaris 8/9/10, Windows 2000/2003, Weblogic9.2/10.3.5, Tuxedo 8.1.

Database size: 50GB-2TB.

Confidential Senior Lead Oracle DBA/ PeopleSoft Administrator/Architect/SQL Server DBA

Responsibilities:

• As Oracle DBA/SQL Server DBA,
• Setup and configured high availability, high scalability Oracle Real Application Clusters RAC on IBM AIX 5.3 with raw device and ASM.
• Configured and upgraded 11gR2 Oracle Grid infrastructure on Linux 5.
• Converted Stand alone database on file system to RAC database on ASM.
• Added and deleted RAC nodes using Oracle OEM Provisioning Pack.
• Lead DBA in Data Center Relocation which migrated standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM.
• Applied patches on Oracle 10g Clusterware and RAC databases.
• Configured, tested and supported Oracle data guard RAC standby for RAC primary.
• Configured and troubleshoot ASM Cluster File System ACFS for Grid/RAC cluster.
• Installed and implemented Oracle database with PeopleSoft application on IBM Mainframe ZLinux 5.
• Install and Configured Oracle E-Business Suite R12.
• Engage in Data center ODC2 relocation for PeopleSoft, PASS, FileNet, Egate applications.
• Support upgrade of Ariba application 7.5 to 8.3 with Veritas cluster file system.
• Support upgrade of SeeBeyond system on Oracle databases.
• Installed and configured Oracle SOA suite.
• Setup, configured and supported Oracle Fusion Middleware.
• Experience in BPEL and ESB technologies.
• Principal DBA supporting OCTO applications including but not limited to PeopleSoft PASS, IDMS, DC1Card, JCAPPS, FileNet, HSMP at DC government.
• Database management through maintenance of data dictionaries, data models, performance tuning.
• Extensive tuning experience in tuning AE app engine , nVision, SQR, COBOL jobs.
• Extensive tuning for financial applications including PeopleSoft, E-Business Suite, SAP and Ariba.
• Provide administrative and technical support for PeopleSoft HRMS HCM , Student Administration, Payroll, eModules, Data Conversion and Performance Management.
• Designed a reliable, space/time efficient RMAN backup strategy. Plan and implemented RMAN backup under Data Guard situation to replace the old user managed backup. Coded various RMAN report scripts to report backup stats like time taken, compression issue, backup set sizing, backup level, job status etc.
• Lead in database architecture design and implementation.
• Supported Ariba Procurement, Seebeyond Integration, Mercury Quality Center and PVCS databases in a high available environment.
• Support HSMP applications of DC government with Oracle and Microsoft SQL Server databases.
• Setup and configured OEM grid control and use it as a tool of administration, monitoring and performance tuning.
• Install PeopleSoft and E-Business Suite plugins for OEM.
• Setup, configure, developed database automatic monitoring of alert log, database status, space status, connectivity, SGA etc.
• Trouble shoot database performance problems by adjusting initial parameter, PGA, SGA and various buffer pool, building/redefine indexes, rearrange stat collection strategies,
• Identify top resource consuming SQL and tuning them with various tools like Grid Control, AWR, TKProf, Autotrace, ExplainPlan.
• Installed, configured, supported and troubleshoot databases on Veritas Cluster on top of Solaris 10.
• Implemented GoldenGate Replication: Configured Extract, DataPump, Trails, Replicat processes for GoldenGate 10.4.
• Configured Bi-Directional GoldenGate replication and implemented conflict resolution.
• Implemented zero down time upgrading with GoldenGate replication.
• Performance tuning GoldenGate processes with BatchSql mode, multiple threads and storage.
• Worked with SharePlex for data replications.
• Wrote, debugged and troubleshoot complex PL/SQL stored procedures and packages.
• Administrate Enterprise User Security for advanced security options using Enterprise Security Management.
• Setup and configured Oracle Internet Directory OID .
• Support SQL Server databases.
• As PeopleSoft Admin,
• Upgraded and Supported PeopleSoft Financials, HCM, EPM, ELM, Portal, CRM.
• Upgraded People Tools 8.4x to 8.5x and PeopleSoft HCM Upgrade 8.x to 9.x .
• Configure Portal Solutions 9.1 to integrate HCM, Financials, EPM etc.
• Configure and setup Phire and Stats for migrations.
• Installation of Oracle and PeopleSoft software, patches, trouble-shooting problems, Performance Tuning, Software Configuration, Capacity Planning, Architecture and Migrations.
• Configure, troubleshoot and performance tuning of PeopleSoft E-Recruit, Time and Labor modules.
• Successfully tuned Time and Labor Admin job from 6 hours to under 2 hours.
• Support Load Runner for performance testing.
• Manage and apply SSL certificate to PeopleSoft web servers.
• Implementing and supporting PeopleSoft HRMS, Payroll, Time and labor, eModules, data conversion and performance management modules.
• Extensively Configured Application Server, Web Server Batch Process Scheduler Server.
• Configured Tuxedo services appropriately for the windows environment. Installed and configured Web Logic Server 9,10,11..
• Installed and configured Oracle Application Server 10.1.3.1. Monitored the Server and Client queue status at several tuxedo domains
• Setup and configured Integration broker. Trouble shooting PeopleSoft messaging issues.
• Configure Single Sign On SSO between PeopleSoft systems.
• Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service.
• Installed People Books and configured the Web Server to access People Books. Configured the context sensitive help.
• Experienced with Remedy to process requests from Developers and various stake holders.

Environment: People Tools 8.46/8.49/8.50 , PeopleSoft HCM 8.8/9.0 , Oracle 11g/10g/9i/8i, AIX 5.3/5.2, Solaris 8/9/10, Windows 2000/2003, BEA Weblogic9.2, Tuxedo 8.1.

Database size: 20G-1TB.

Confidential

Senior Oracle Application DBA

Responsibilities:

• Set up and support high availability and high scalability Oracle 10g RAC Real Application Clusters on Red Hat Linux 4 on ASM.
• Upgraded/Patched Oracle 10g Clusterware and RAC databases.
• Migrated databases from non RAC and file system to 10g RAC on ASM.
• Set up and supported RAC Data Guard Standby Database for Disaster Recovery scenario.
• Lead in Performance Tuning of all applications including PeopleSoft using AWR, TKProf, Oracle Tuning Advisor, Oracle Access Advisor, Oracle Access Advisor, ADDM, Adjust default Oracle parameters.
• Installed and set up Oracle E-Business Suite 11i and applied patches.
• Performing Concurrent Manager setup and trouble shooting.
• Administrating applications with the AD utilities like Adautocfg, adadmin, adpatch, adctrl.
• Cloning 11i environments with Rapid Clone, Autoconfig and adclone utilities.
• Experience in system architecture of 11i applications implementation of various Financials modules like GL, AP, AR, FA.
• Maintenance of concurrent processing request and concurrent managers.
• Installed and supported Oracle Application Server 10g.
• Configured and setup Oracle Fusion middleware.
• Designed and developed 6 short/long running and real-time/batch interfaces using synchronous and asynchronous SOA design patterns for larger payloads using BPEL/ESB
• Extensive experience with tuning Oracle Database, resolving enqueue, locking issues.
• Performing Database and SQL Tuning by using various Tools like STATSPACK, AWR and TKPROF. Providing guidance to developers for writing optimal code for better performance of various functionality's of Settlement.
• Installed and configured Oracle Enterprise Manager OEM Grid Control as a tool of administration, performance tuning, monitoring and alerts.
• Configured Shareplex as a tool of replication.
• Installed, configured, supported and troubleshoot databases on Veritas Cluster on top of Solaris 10..
• Setting up backup and recovery procedure with RMAN. Coded various Perl/Shell scripts to automate backup and recovery, failed backup/clone jobs aleters, morning detail backup reports.
• Configured and supported 10g Oracle Stream.
• Upgraded Oracle databases from 9i/8i to 10g release 2.
• Clone/Refresh of Production database to Testing and Development environments.
• Estimate Storage requirement, Design the Physical Database Layout and create the databases for Production, Testing and Development.
• Created Hash sub-partitions within the existing Range partitions to use Partition pruning on SQL in VLDB environments. Implemented indexes strategies using bitmap and local indexes and enabled star transformation to improve performance of the Data Warehouse.
• Implemented data compression to reduce storage and improve performance for certain queries.
• Training developers about avoiding offensive PL/SQL
• Develop/customize UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.
• Installed, configured, and maintained Oracle Fusion Middleware with SOA, OBPM Suite and WebLogic Server. Installed Jdeveloper on the client Machine. Deployed Java EAR files.
• Add users to OID and to their appropriate group.
• Wrote, debugged and troubleshoot complex PL/SQL procedures and packages.
• Administrate Enterprise User Security for advanced security options using Enterprise Security Management.
• Setup and configured Oracle Internet Directory OID .

Environment: Oracle 11i/10g/9i/8i, IBM AIX 5.2, Linux 4.0,Windows 2000/2003.

Database Size: 50G-1TB.

Confidential

Senior Oracle Database Administrator/ PeopleSoft Admin/Architect

Responsibilities:

• Provided all aspects of Oracle support installs, upgrades, performance tuning, monitoring, patches and troubleshooting .
• Lead in upgrading database to Oracle 10g from 9i/8i.
• Configured and setup Data Guard Standby database for disaster recovery.
• Setting up backup and restore procedure with RMAN and coded various Perl scripts to automate the backup and restore procedures.
• Working with Management to estimate Server capacity and storage requirement.
• Configure Oracle database auditing.
• Working on the automation of various batch jobs and database performance related reports.
• Performance Tuning and Space Management by developing shell scripts and using various Tools such as TKPROF, Explain Plan etc
• Clone/Refresh of Production database to Testing and Development environments.
• Develop/customize UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.
• Supporting PeopleSoft HRMS, Student Records and Enrollments, Academic Advisement, Student Financials, Financials Aid, Self Service .
• Extensively installation of People Tools, Tuxedo, COBOL, Websphere.
• Identified the team roles and responsibilities for the technical upgrade process
• Portal design and implementation including setting up Single Signon, LDAP directory sync, SSL encryption on load balancer.
• Migrated Projects from Development Database into QA Testing Database and then into Production.

Environment: PeopleTools 8.22 /8.44 , PeopleSoft HRMS and Campus Solutions 8.4, Financial 8.4, Portal 8.4, EPM, Oracle 10g/9i/8i, Windows NT/ 2000, AIX 5.2, BEA Weblogic8.1, Tuxedo 8.1

Database Size: 20GB to 1TB

Confidential Oracle DBA/ System Administrator/Developer.

Responsibilities:

• Database design and administration, designing of Backup Recovery strategies.
• Restructured production databases considering effective performance tuning of databases and applications, effective resource utilization and improved performance.
• Tested and implemented disaster recovery system for 24 7 operations.
• Responsible for administration, monitoring management of databases on development, staging, and production environments.
• Install Solaris operating system, created and managed Unix users and groups, configured sudo permissions.