Sreenivasula Gosangi Email & Phone Number

Albany, New York Area

• Specialized in Oracle Databases (Versions 18/19c,12c,11g,10g, 9i), Oracle Apps Database Administration (R12.2, R12.1.3,11.5.10.2) and Fusion Middleware (10g AS)
• Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors of UNIX (Oracle Enterprise Linux, Red Hat, Sun Solaris)
• Expertise in Maintenance, Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications e-Business Suite
• Production Experience in administering Oracle Apps R12.2, and upgraded EBS Applications from R12.1.3,11.5.10.2 to R12.2
• Implemented SSO for R12.2 along with OID/OAM using SAML Mechanism
• Working on Upgrade of R12.2 from R12.1.3

Irvine, CA

• Deployed wide-ranging Oracle technologies (e.g. Active Data Guard, ASM, OEM/Grid,RMAN) in mission critical, highly available production environments.
• Installed R12.2.2 on 2-node RAC with 4-node Applications and DMZ Nodes, InstalledAgile, OBIEE and Demantra, cloning Demantra environment from PRD to Non-PRD environments. Spearheaded Oracle E-Business Upgrade from.
• Built new instance using AD Utilities and Migrated Single R12 instance to RAC Instance. Perform cloning using Rapid Clone, export/import and RMAN. Implemented Oracle Application Tablespace Management, SSL, Shared.
• Led application upgrade from R12.1.3 to R12.2.5. Conduct patching (CPU, debugging,patch sets and family packs using AD utilities and OPatch). Upgraded CRS from 11gR2to 12c. Oversaw Database Upgrades from 9i to 10g &.
• Performed complete tech stack upgrade (Developer 6i patch set 19, Jinit/JRE 7, JDK 6).Built DEV/UAT/TEST Instances from PROD Environments. Worked on cut-over technologies such as DMZ setup with advanced topology for.
• Acquired cloud experience, performing ICS (Integrated Cloud Services) Agent Installation and Upgrade. Conducted SSO implementation for EBS R12.2.5 using 11g OID/OAM, and completed SOA installation (BAM, B2B, ESS), UPK.

Palo Alto, CA

• Led Oracle Database portion of 24/7 Support EBS Applications project to provide EBS11i support and roadmap for R12.2.4 upgrade. Administered and supported EBS onOracle 11GR2 5-node RAC and 8-node application tier on.
• Deployed Oracle technologies (e.g. Active Data Guard, ASM, OEM/Grid, RMAN) inmission critical, highly available production environments. Installed R12.1.1 on 2-nodeRAC with order management, IProcurement and iSupplier.
• Supported production database environment via space projection and reclamation, aswell as SQL performance tuning of existing applications. Cloned various 11i instancesfrom RAC to RAC and RAC to non-RAC (TEST, UAT, DEV.
• Gained experience implementing and deploying Oracle Enterprise Management (OEM)grid control, as well as SSL and GRC. Performed database upgrades and migration fromLower version to High Version. Conducted R12 VISION.
• Worked with OEM Grid Control 11g and OEM Cloud Control 12C, integrating withAMP/ACP for EBS Applications. Upgraded EBS 11i Database from 10g to 11gR2 andconverted from Non-RAC to RAC Environment. Deployed RMAN backup.
• Oversaw deployment of.war, Ear and.jar files on WebLogic console. UtilizedStop/Start Administration server and managed server during outage window. Provided maintenance of WebLogic server, including cloning and.

Chennai, India

• Oracle DBA for numerous high-level projects, including Ernst & Young Sandbox to Sandbox Migration, CBTT Upgrade of EBS Applications, and Expo Freight Limited/EBS R12 Financial Implementation.
• Installed R12.1.1 EBS on RHEL Server release 5.9 (Tikanga) on Multi-node with 2-node 11.1.0.7 RAC with ASM. Prepared existing R12.1.3 environment for R12.2.3 upgrade for UAT in addition to database upgrade from.
• Performed Oracle Fusion Administration, including WebLogic server and OBIEE administration. Resolved apps performance issues including Oracle R12 speed andlong-running concurrent programs.
• Upgraded Oracle Application Database 9i (9.2.0.3) 32bit to 11gr2 (11.2.0.2) 32 bit andmigrated from RHEL 2-32 bit box to RHE 5-32 bit box. Collaborated with client businessteams during new releases and other vital.
• Installed R12.1.1 EBS on RHEL Server release 5.5 (Tikanga) on single-node. UpgradedR12.1.1 Applications to R12.1.3. Handled disaster recovery and fielded and resolvedtroubleshooting calls.
• Managed User Creation and assigned user responsibilities based on Application Teamrequests. Conducted code migration using stat change management solutions for LiveProduction Instance. Enabled and disabled profile.

Chennai, India

• Supported production databases for OLAM Information Services, including All Financial Modules such as GL, AR, AK, and Iexpenses. Upgraded Oracle DB from 10.2.0.3 to 10.2.0.4 on OEL and upgraded EBS Applications from.
• Backed-up databases and Oracle Applications through RMAN. Integrated SSO with EBS 11.5.10.2. Installed Oracle 10G Forms & Reports server and provided support and maintenance. Applied database and application patches.
• Efficiently provided 24x7 troubleshooting support and resolution while managing E*Tracker Issue tickets and Oracle Service Requests. Served as Escalation Point for Level 2 Operations and Application Technical Support..
• Migrated all custom programs and reports to production which involved enforcing naming standards, maintaining the CUSTOM_TOP, and setting up concurrent requests. Created custom concurrent requests to enhance database.
• Supported and implemented changes in technology (e.g.: database upgrades/application upgrades). Upgraded ERP Application Jinitiator to Sun Java JRE 1.6 Family.

Chennai, India

• Supported 4 production databases for Mastercard, including all financial modules such as AP, AR, OIC, FA, OIC.GL and more. Maintained Multi-node installation of Oracle ERP 11.5.10.2. Performed administrative.
• Provided 24x7 troubleshooting and problem resolution support for clustered application environment. Managed Remedy tickets and Oracle TARs. Served as Escalation point for Level 2 Operations and Application Technical.
• Supported and implemented changes in technology (e.g.: database upgrades/application upgrades). Created standards, procedures and process documentation. Supporting technical and development teams in code migration.
• Maintained production application and database patching coordination between PROD, TEST, and DEV Instances. Created and maintained operational scripts.
• Supported 8 production databases for State Street Corporation client, including AP, AR, FA, GL, BOM, Inventory, Order Management, XML Publisher and other financial models. Optimized and tuned SQL queries using TKPROF.
• Successfully upgraded Application Technology Products to latest base level by applying the ATG_PF.H Rollup 4. Upgraded database from 9.2.0.5 to 9.2.0.8, 9.2.0.6 to 10.2.0.3 and Jinitiator 1.1.8.16 to 1.1.8.25. Wrote.

Master Of Science - Ms, Electronics

Bachelor Of Science - Bs, Computer Science