Soa Administrator Resume Profile
Experience Summary:
Confidential Tatineni having Bachelor's degree with 8 years of experience in Information technology industry on Oracle Weblogic, Oracle Database, Fusion Middleware, Oracle E-Business Suite, OTM and Demantra Administration. Professional strengths includes team leadership, management, strong oral and written communication skills, proven ability to design and implement IT support infrastructures and ability to achieve corporate objectives in challenging work environments.
Expertise Includes:
- 5 years of Extensive Adminstration experience on Oracle WebLogic versions 10g, 11g and 12c.
- 3 years of Adminstration experience on Fusion Middleware FMW modules SOA, BAM, OSB, Webcenter and SES.
- 7 years of experience on Database Admininstration 9i, 10g 11g .
- 4 years of Adminstration experience on Oracle Applications Releases 11.5.10/11.5.9.
- 3 Years of Adminstration experience on Oracle Transportation Management OTM 4.5, 5.x and 6.x versions.
- 4 years of Adminstration experience Oracle Demantra versions 7.1.x,7.2.x, 7.3.x and 12.x
- Working Experience on Oracle Identity Management OAM, OIM, OID, OVD .
- Expertise in installing, Configuring and administering the Oracle Fusion Middleware 11g products.
- Extensive working experience in setting up multiple domains, including Administration Servers, Managed Servers, Machines, Node managers in different cluster environments of WebLogic.
- Expertise in cloning, clustering, patching, Upgrading and performance tuning of Oracle FMW components.
- Analyzing Weblogic Thread dump and Performance Tuning.
- Upgrade of SOA, AIA, Web Center and SES products from 11.1.1.x to 11.1.1.7/8 along JVM and Weblogic.
- Performing SOA Clones
- Installing, Integrating and Configuring Oracle Identity Management IDM Products OAM, OIM, OID and OVD.
- Developed SOA Instance purging script based upon the retention period using shell and sql scripting.
- Expertise on DB Administration/Backup-Recovery/Performance Tuning and Monitoring/ Data Migration/ Upgrades.
- Extensively worked on Oracle Performance Tuning like locking, deadlock, hang, latch, statspack, AWR, hang analyze, systemstate dumps awk etc.
- Oracle Database Cloning and Patching with minimal downtime window Specialized to handle severity 1.
- Extensive experience in Oracle Database Backup and Recovery using Manual method, RMAN Recovery Manager .
- Experience on High Availability solution like Dataguard physical and logical standby and Patching.
- Played a lead role in Migration of 25 customer instances from WRDC to Austin Data Center.
- Providing Leadership, Assignments and monitoring progress of the Team.
- Manage SOX and PCI Compliance as it pertains to Databases
- Manage operational support services for oracle Applications in the enterprise including a 24x7 on-call support rotation and off-hours maintenance support. Having excellent understanding of SLA's and Managed Services.
- Possesses exceptional personal strengths including excellent customer supporting skills, good logical experience in demonstrating problems, excellent troubleshooting skills and a great team player.
Technical Skills:
Databases | Oracle Database 9i, 10g 11g |
Middleware | WebLogic 9i, 10g, 11g 12c , Oracle Application Server 10g . |
ERP/Applications | Oracle Applications 11.5.10, 11.5.9, Fusion Middleware product SOA, BAM, AIA, Webcenter SES , Oracle IDM, Oracle Transportation Management and Oracle Demantra |
Tools and Utilities | Oracle Enterprise Manager -10g/11g/12c, SVRMGRL, RMAN, SQL Loader, TKPROF, Export, Import, AWK, RMAN,AWR,ADDM, SqlDeveloper, OSWatcher |
Operating Systems | Sun Solaris SPARC Enterprise HP-UX PA RISC 9000 Linux X86-64 IBM AIX and Windows N/2000 |
Current Project Summary:
Confidential | |
Applications/Middleware | Weblogic, Oracle Fusion Middleware, Oracle E-Business Suite Apps DBA , Oracle Demantra , Sales Force SFDC , OAS, EM 12c and Oracle 11g Database |
Environment | AIX , Linux X86 64 and Windows 2000 |
Responsibilities:
- Installing and Administering SOA 11.1.1.7 Cluster setup.
- Performed Upgrades of SOA from 11.1.1.6 to 11.1.1.7 along with Weblogic and Jrockit
- Tuning and managing Weblogic application servers for better performance.
- Automated SOA Instance purging based upon the retention period using shell scripting.
- Cloning SOA instances
- Configuring Data Sources, Coherence Servers, JMS Messaging.
- Deploying ear, war and jar files in weblogic
- Configuring BAM Setup
- Configuring Fail over/Auto Migration for SOA instances in cluster setup
- Integration 10g SSO/ OID with EBS instances
- Sales Force integration with SSO
- Installing and Administering ADF 11.1.1.6
- Deploying composites using wlst, EM console, Ant
- Troubleshooting SOA ADF issues by reviewing the logs.
- Performing EBS Clones Refreshes.
- Creating users accounts, Assigning responsibilities and roles based upon the user/business requirement in EBSO.
- Creating/Migrating Value Set, Quick Code, Concurrent Programs using FNDLOAD in EBSO
- Performing patch analysis, applying patches and checking the patch impact.
- Applying Bug fixes, one of patches, CPU, PSU patches on EBS, SOA, ADF, Weblogic and Database.
- Performed database upgrade from 11.2.0.2 to 11.2.0.4
- Oracle alert log and trace files monitoring ,tkprof trace file generation and analysis, resolving table locking and dead lock issues
- Analysis of AWR/ADDM reports and finds the bottlenecks and provides the better solutions Resolving performance issues caused by problematic queries and tune them for better performance.
- Performed Demantra upgrade from 7.3.1.x to 12.2.x
- Troubleshooting Demantra Worksheet performance issues.
- Configuring Analytical Engine setup on Linux and performance issues.
- Migrating the database objects code from one instance to other instance database through Kintana and PVCS tools.
Previous Projects Summary:
Confidential | |
Designation | WebLogic SOA Administrator |
Applications/Middleware | WebLogic, Oracle Fusion Middleware SOA, ADF and Webcenter , Oracle Database |
Environment | AIX , Linux X86 64 and Windows 2000 |
- Installing and Administering Web center and SOA 11.1.1.7 Cluster setup.
- Installing and Administering ADF 11.1.1.6
- Tuning and managing WebLogic application servers for better performance.
- Configuring Data Sources, Coherence Servers, JMS Messaging.
- Deploying ear, war and jar files in WebLogic.
- Configured BAM Setup.
- Configuring Fail over/Auto Migration for SOA instances in cluster setup
- Installing and Administering ADF 11.1.1.6
- Deploying composites using wlst, EM console, Ant
- Troubleshooting SOA ADF issues by reviewing the logs.
- Performing patch analysis, applying patches and checking the patch impact.
- Applying Bug fixes, one of patches, CPU, PSU patches on SOA, ADF, Weblogic and Database.
Confidential | |
Designation | Principal Technical Analyst Team Lead |
Team | Oracle Managed Cloud Services OMCS |
Applications/Middleware | WebLogic, Oracle Fusion Middleware SOA, BAM,AIA, OSB, Web Center, SES , Oracle E-Business Suite Apps DBA , Oracle Demantra, Oracle Transportation Management OTM and Oracle Markdown Optimization MDO , Oracle Database 9i,10g,11g |
Environment | Sun-Solaris 2.8, 2.9, 2.10 Red Hat Enterprise Linux Server release 5.3 HP-UX B.11.23 IBM AIX 4.3, 5.1 and Windows NT/2000/98/95 |
Oracle Managed Could IT Services team is responsible for maintaining hardware, software, and security for their IT Infrastructure for all FMW, APPS DBA, OTM, Demantra and Retail MDO Customers. Currently we are supporting around 150 customers of various applications and having a team size of 12. Worked as a Team Lead in Problem Management team, my responsibilities includes troubleshooting all the problems encountered in Applications, along with tech stack support across all the customers.
Oracle WebLogic and SOA Administration
Confidential
Responsibilities:
- Installing and Configuring FMW products SOA/BAM/IPM/AIA , Demantra, OT and MDO.
- Installing, Configuring and Integrating IDM products OIM,OAM,OVD,OID OIF
- Responsible for configuring, managing and providing support to multiple web based applications deployed on more than 50 Web and Application servers related to SOA, Demantra, OTM and MDO Applications.
- Installed, configured, maintaining Oracle weblogic Server 10.x/11g in various environments OS Solaris /Linux .
- Deploying application WAR/EAR/Exploded Deployment on Clustered Weblogic Servers using Ant troubleshooting issues related it.
- Automated SOA Instance purging based upon the retention period using shell scripting.
- Performed Upgrades of SOA, AIA, Webcenter, and SES OSB from 11.1.1.x to 11.1.1.6/7.
- Fine tuning the FMW products.
- Performed SOA Clones, also documented the procedure for future reference to other teams.
- Deploying applications/composites through EM console and OSB console, also troubleshooting various issues related to Application on daily basis.
- Performance Tuning of various WebLogic Application Server, SOA and related resources Memory parameters, JDBC Connection Pools .
- Good Understanding of SOA service engines like Mediators, Adaptors, BPEL and Human Work Flow.
- Monitoring the SOA platform using Oracle Enterprise Manager OEM Fusion Middleware Control.
- Upgrade of WebLogic servers in development, testing and production environment and applying patches using bsu.
- Monitor the JVM performance by WebLogic Heap Size, garbage collection and JDBC Pools.
- Exposure to diagnose and resolve performance Heap management, memory leaks, excessive garbage collection, threading issues and other java coding problems using Jrockit Mission control and some JDK/Jrockit default tool jrcmd.
- Administering Weblogic security through admin console. Manage access and roles to console.
- Troubleshooting WebLogic Application Server connection pool issues with Oracle DB as backend.
- Developed Weblogic startup, shutdown and status for Weblogic Servers using perl scripting.
- Diagnose and resolve performance bottlenecks, memory leaks, excessive garbage collection, threading issues and other java coding problems.
- Taking necessary actions by monitoring Standard logs, application logs, and domain logs.
- Creating/Executing action plans for RFC's as per the customers' environments.
Oracle Database Administration
Confidential
Responsibilities:
- Installing, configuring, Upgrades and Supporting Oracle Databases Versions 9i, 10g 11g on Red Hat Linux, Sun Solaris and NT/2000.
- RAC Real Application Clusters installation and Administration.
- Configuring High Availability solution like Dataguard physical and logical standby and Patching.
- Applying CPU Critical Patch Update , PSU Patch Set Update and One-off Patches.
- Troubleshooting Database High CPU utilization issue and High Memory issue on single and RAC Database.
- Oracle Database Backup and Recovery using Manual method, RMAN Recovery Manager .
- Performing Refreshes, upgrades applying patches.
- Database performance tuning.
- Query Tuning.
- Troubleshooting queries after the database upgrade or migrate. Migrated servers from Sun Solaris to Linux.
- Played a lead role in migrating of Servers from Cambridge to Austin Data Center ADC .
- Performed upgrades of Oracle 9i, 10g and 11g databases at both Point and Version levels.
- Cloning the instances for making the respective instance for testing as well as for Backup.
- Planning and Implementing Backup and Recovery Strategy for databases using Hot and Cold Backups, Logical Backups using Exports and imports.
- Expertise in Exports Imports utilities normal/Datapump/Pipe .
- Played leading role while Wal-mart Wal-mart Softlines, Wal-mart Samsclub, Wal-mart Chaina, Wal-mart Mexico databases are moving to their IN-House Customer Model, helped them in setting up their 4 Prod and 4 Test instances without any issues also Implemented RMAN Backup and recovery setup.
- Monitoring of High CPU loads, Tablespace Usage, Critical Table Growths, Invalids and Alerts logs of database on daily basis.
- Resolving Database Connectivity issues.
Oracle Demantra
Confidential
Responsibilities
- Worked as a lead DBA role for all Oracle Ondemand Demantra Customers as first point of contact for any issues related to Demantra administration.
- Experience in Oracle Demantra 7.1.x, 7.2.x and 7.3.x versions.
- Responsible for Installing and configuring of Oracle Demantra of various versions.
- Experience in Administer and monitoring tasks like worksheet maintenance, User maintenance.
- Expertise in creating and deploying Demantra war files from windows machines.
- Experience on scheduling and monitoring demantra workflows.
- Extensive experience in Demantra web server shutdown and startup process.
- Engaged in scheduling and monitoring Demantra statistical engine.
- Engaged to resolve Demantra worksheet related performance issues.
- Experience in administer/configuring collaborative workbench screens from admin login.
- Extensive experience in Demantra schema export from production environment and import into non-production environment.
- Responsible for installing Demantra software in user machines to access business modeler.
- Performed many Demantra upgrades in both Platform and Application Platform modes.
- Integrating Demantra with EBSO/ASCP and JDE.
- Configured Demantra Multi Analytical Engine DCOM setup for sharing up the loads.
- Setting up the Engine Run through Workflow where Application server Weblogic/10g AS installed on Linux using a shell script.
- Successfully resolved the Analytical Engine Run issue with 11g client for Demantra version prior to 7.3.x and also created and published the document in MOS My Oracle Support .
- Configured Analytical Engine Setup on Linux.
- Performance tuning against Demantra core tables SALES DATA and MDP MATRIX.
- Expertise in reordering and rebuild of SALES DATA and MDP MATRIX tables for better performance.
- Performing Demantra schema refresh/clone from production instance to Non-production Instances.
Oracle E-Business Suite APPS DBA :
Responsibilities:
- Oracle Applications 11i and R12 system administration activities like Apps Installation, administration, configuration, cloning, upgrading, patching.
- Trouble shooting Application at various middle tier layers Concurrent Manager, forms/Reports/Apache server
- Expert in Configuring Administration of Oracle Applications ERP systems.
- Extensive experience in supporting and managing multiple Production, Staging, Development and test instances and Oracle Applications environments of varied complexity.
- Converting to SHARED APPL TOP Applications.
- Experience on AD utilities.
- Administration and maintenance of Concurrent managers. Registration of Forms, Reports, Concurrent Programs.
- Implemented DMZ setup on production environments.
- Cloning Oracle Applications experienced with different cloning skills like manual, adclone and Rapid clone.
- Relinking the Oracle Apps Executables manually.
- Performing patch analysis, applying patches and checking the patch impact.
- Troubleshooting worker issues while patching.
- SSL configuration.
Oracle Transportation Management
Confidential
Responsibilities:
- Experience on OTM 4.5, 5.x and 6.x versions.
- Installing, configuring, Patching and Supporting Oracle Transportation Management OTM on Single tier and Multi tier architecture.
- Upgraded OTM applications from 4.5 to 5.5 and 6.0 to 6.2 and from 5.5 to 6.2.x.
- Played a major role in Implementation Migration projects of OTM Version 5.x to 6.2.x along with Database upgrade and platform migration.
- Refreshing/Cloning of OTM Applications of diff architectures.
- Clustering at Application Servers and Scalability setup.
- Configuring Scalability and RAC node setup for OTM Application.
- Troubleshooting the Weblogic, Tomcat and Apache issue related to OTM Application.