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 • Data Guard Implementation on ASM File System• Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC• Managing Users, working with SOX Team for validations• Comprehensiveness E-Business Suite and Business Application Management

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 11.5.10.2 to R12.2.4. • 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 Application Tier, and Parallel Concurrent Processing (PCP).• 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 & 10g to 11g per support policies.• 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 External Supplier.• 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 installation, ISG (Integrated SOA Gateway) installation and configuration with EBS R12.2.5. Performed Vertex installation.• Ensured availability and uptime of DEV/UAT/PROD database. Supported the onsite/offshore DBA support model. Closely interfaced with client and Oracle Support to resolve issues as necessary.• Strong experience with various types of EBS Application cloning with Rapid Clone, includingSingle-to-Multi-Node, Multi-to-Single-Node, and Multi-to-Multi-Node. • 11g Fusion Middleware Installation expertise, including WebLogic server and component maintenance, configuration, backup, and patching.

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 Linux.• 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 Modules, and upgraded toR12.1.3.• 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, STAGE and LT).• 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 installation, and installed OBIEEwith WebLogic server 10.1.3 and RCU on 11.2.0.3 Database.• 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 for Non-Production Environments.• 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 applying patches using Smartupdate utility BSU. Conducted R12.2 Upgrade on DEV Environment.• Provided On-call Support for production and Non-production issues, including afterworking hours and weekend Support for production maintenance activities.

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 11.1.0.7 to 11.2.0.3. Led code migration using stat change management solutions. • 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 activities. Performed continuity of businessexercise at client site• 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 options to troubleshoot issues relatedto EBS Applications.• Handled user tickets through various ticketing systems such as Team Track and VirtualTech. Administered 3rd-party integrations including 170 systems (Markview), Kintana (Migration tool) and more.• Exported objects from Standard EUL to Application EUL using Export/Import Utilities.Installed WebLogic Server and New Users and Table spaces created Using RCU Utilityfor Oracle Fusion Middle Ware Discoverer Installation. Installed Discover Administrator and Desktop on Windows 32-bit OS.

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 11.5.10.2 to 12.0.4 on TEST Instance. • 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. Ensured production application and database patching coordination between PROD, TEST, and DEV Instances.• 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 performance. Created database objects for custom applications.• 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 application tasks, including cloning, patching, node movement, autoconfiguration, etc.• 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 Support. Performed Concurrent Managers administration and troubleshot CM issues.• 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 and EXPLAIN PLAN. Re-organized and rebuilt tables and indexes.• 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 shell scripts for cron jobs.• Supported 21 databases, including all financial models for retail equipment and services company. Installed Oracle 10g and 11g Database Software on Linux and Windows float forms. Created and maintained operational scripts. Secured socket layer implementation for Oracle E-Business Suite.• Developed new FSG reports based on user requirements. Installed latest Application Desktop Integrator Tool. Setup and managed user accounts, defining grants and assigning roles.

Master Of Science - Ms, Electronics

Bachelor Of Science - Bs, Computer Science