Home

Sirisha D - Oracle APPS DBA

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

Profile Summary Weblogic Administration, Oracle Fusion Applications and Oracle Application DBA with 12+ years of extensive IT experience on large scale Oracle E-Business Suite R12/11i. Responsibilities included installation, patches, concurrent manager administration, cloning, Oracle Applications Sys Admin functions, backup/recovery, troubleshooting. Experience in supporting multiple Production, Test, Development, Migration instances and Fusion Middleware products WebLogic, SOA. Worked on BEA WebLogic 8.x, 9.x, 10.x, 11 Server, Apache http Server,as administrator for Server Installations, Configuration, Application components deployment, including troubleshooting and maintenance. Experience in configuring and managing secured environments using SSL and digital certificates. Have working knowledge in finding Memory Leaks and adjusting JVM Heap Size and Garbage Collector parameters during performance monitoring and performance tuning of WebLogic server. Good working knowledge in configuring multiple WebLogic domains including machines, managed servers, node managers and cluster environments. Optimized database performance using AWR, ADDM, and OEM Grid Monitoring, improving the response time of critical business applications. Managed Table spaces, Data files, Alert logs for database maintenance and provided 24x7 on-call support for Oracle ERP applications and production databases. Working closely with Oracle Development and Support on bug fixes by raising Service Requests, conducting Oracle Web Conferencing, and Incident/Change management activities. Experience on ADutilities like adpatch, adadmin, adconfig, adclone, adctrl, admrgpch. Hands on experience in applying CPU/PSU, WIN SEC patches Knowledge on data guard Provided 24x7 on call support in production environment on rotation basis Technical Skills Oracle Applications : Oracle Apps R12.1.3, R12.2.4 Oracle Fusion : Oracle SOA Suite 11g (BPEL, BPM, HWF, Rules Engine, BAM ), OSB Application Server : WebLogic 11g Databases : Oracle 10G and 11G Operating Systems : Sun Solaris UNIX, Red hat Linux. Tools & Techniques : Enterprise Manager 10g, 11g, NSI, HPPM and Ticketing Tools like Service now ACADEMIC BACKGROUND Bachelor s and Master s in computer applications from IGNOU Hyderabad Certifications AWS Certified Solutions Architect Associate AWS Certified Cloud Practitioner Oracle Cloud Database 2023 Migration and Integration Professional Google Cloud Certified Cloud Digital Leader AZ-104 Microsoft Azure Administrator Training is in progress. Professional experience Summary Client Designation Duration HCL Sr. Oracle Application DBA Feb 2023 - Till Date Cognizant Technology Solutions (CTS) Sr. Associate June 2021 Feb 2023 4Pillars Infotech Pvt. Ltd Oracle Apps DBA Aug 2020 May 2021 Primus Global Technologies (Oracle Client) Oracle Application DBA Aug 2017 July 2020 General Electric (GE) Oracle Applications DBA May 2012 Aug 2017 Client/Project Assignment WORK EXPERIENCE HCL CLIENT: Mattel | Feb 2023 to Till date Role: Oracle Apps DBA Applied patches using ADOP on Oracle Applications Production and Non-Production instances Cloning Non-Prod Instances from production using RMAN Performed Data Guard switchover/failover as per the requirements. Created monitoring scripts to send alerts in case standby is out of sync. Configuring and managing two nodes UNIX RAC environment for high availability, highly busy databases Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues. Worked on RAC/ASM interconnect issue. Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces. Upgraded and patched Oracle binaries in the development environment and production environment. Upgraded Oracle from 12.2.0.1 to 19.0.0.0. Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects. Utilized SQL Loader ETL to perform bulk data loads into database tables from external data files. Performed SQL tuning by using Explain Plan and AWR/ADDM. Extensive experience in Oracle database administration, including upgrades, migrations, and performance tuning. Proven ability to successfully replicate and migrate Oracle databases to the Cloud. Expertise in providing database and application connectivity for testing environments. Proven experience in executing successful upgrades of Oracle databases to version 19c or higher, including direct upgrades from 12c to 19c. Quarterly performing password change activity on Production instances. Before arriving of peak season performing Index rebuild on tablespaces and reorg activity. Attending GTM on schedules as per Rimini case updates and fixing the issues with Rimini engineer. Issues fixing to production RMAN failure. Supported Oracle Applications R12.1.3 and R12.2.4 on production and non-production Environments. SSO related user login issues ie., sync issues will resolve Client/Project Assignment WORK EXPERIENCE Cognizant Technology Solutions (CTS) CLIENT: Mattel | June 2021 Feb 2023 Role: Oracle Apps DBA Responsibilities: Applied patches using ADOP on Oracle Applications Production and Non-Production instances Cloning Non-Prod Instances from production using RMAN Performed Data Guard switchover/failover as per the requirements. Created monitoring scripts to send alerts in case standby is out of sync. Configuring and managing two nodes UNIX RAC environment for high availability, highly busy databases Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues. Worked on RAC/ASM interconnect issue. Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces. Upgraded and patched Oracle binaries in the development environment and production environment. Upgraded Oracle from 12.2.0.1 to 19.0.0.0. Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects. Utilized SQL Loader ETL to perform bulk data loads into database tables from external data files. Performed SQL tuning by using Explain Plan and AWR/ADDM. Extensive experience in Oracle database administration, including upgrades, migrations, and performance tuning. Proven ability to successfully replicate and migrate Oracle databases to the Cloud. Expertise in providing database and application connectivity for testing environments. Proven experience in executing successful upgrades of Oracle databases to version 19c or higher, including direct upgrades from 12c to 19c. Quarterly performing password change activity on Production instances. Before arriving of peak season performing Index rebuild on tablespaces and reorg activity. Attending GTM on schedules as per Rimini case updates and fixing the issues with Rimini engineer. Issues fixing to production RMAN failure. Supported Oracle Applications R12.1.3 and R12.2.4 on production and non-production Environments. SSO related user login issues ie., sync issues will resolve User responsibility and login issues taken care. Client/Project Assignment WORK EXPERIENCE 4 Pillars Infotech Pvt. Ltd CLIENT: Data intensity | Aug 2020 May 2021 Role: Oracle Apps DBA Responsibilities: Applied patches using ADOP on Oracle Applications Production and Non-Production instances. Cloning Non-Prod Instances from production using rapid clone & RMAN. Performed System Administration activities including User and Responsibilities creation, Concurrent Managers, Profile options, Defining printers, User management and Workflow administration. Supported Oracle Applications R12.1.3 and R12.2.4 on production and non-production Environments. Managed and maintained the oracle applications using adutilities like adpatch, adadmin, adconfig, adclone, adctrl, admrgpch. Experience on deploying mule soft applications through Jenkins. Primus global technologies Pvt ltd, CLIENT: Oracle India Ltd | Aug 2017 July 2020 Role: Oracle Apps DBA with Weblogic Administrator Responsibilities: Installed, Configured and administered Oracle WebLogic BEA Server 11g in Development, Test and Production Environments. Monitoring OEM alerts and fixing the alerts, raising the Bug as and when required. Experience in applying Weblogic patches (BSU) as when required, installing certificates, working on bugs, SR s and RFC s. Deployed applications (WAR, JAR and EAR) using WLST and WebLogic Console. Maintained Load balancing, high availability and Fail over for the servers Involved in tuning the server. Involved in performance tuning of JVM and used Garbage collection Algorithms for better performance. Monitor and managing the WebLogic server instances using WLST Involved in trouble shooting and fixing day-to-day problems of the applications in production, production-Fix and testing environments. Provided 24x7 on-call support for production / non-production environments. Supporting Oracle Applications 12.2.4 on Production and non-Production Environments Performed purging activities like ESS Purge, SOA Purge as per customer requirement Applied patches using ADOP, Opatch and BSU utilities on Oracle Applications Production and Non-Production instances. Applying EBS patches in ADOP cycle and troubleshoot issues if any. EBS Cloning and Troubleshooting. Supported the RAC and non-RAC database for Prod and non prod. Running gather statistic s on particular schemas from SQL*PLUS. Maintaining and Administering Application users. Environment: Oracle E-Business Suite R12.2.4, R12.1.3 Oracle database 11gR2, 11g (WebLogic, OBIEE, GRC, SOA), Enterprise manager cloud control 12c, Oracle Enterprise Linux, Oracle Sun Solaris 10 GENPACT India Pvt Ltd, CLIENT: GENERAL ELECTRIC OIL & GAS | May 2012 Aug 2017 GE a full stream oil and gas company inventing smarter ways to bring energy to the world. Oracle Applications DBA Pascal and Oscar Business Solutions Applied patches using ADOP on Oracle Applications Production and Non-Production instances. Cloning Non-Prod Instances from production using rapid clone & RMAN. Performed System Administration activities including User and Responsibilities creation, Concurrent Managers, Profile options, Defining printers, User management and Workflow administration. Supported Oracle Applications R12.1.3 and R12.2.4 on production and non-production Environments. Managed and maintained the oracle applications using adutilities like adpatch, adadmin, adconfig, adclone, adctrl, admrgpch. Worked with Oracle for Different Service Requests to resolve the critical issues. Used HPPM tool for code migrations and resolved the user tickets through Service Now ticketing system. Worked on new site implementations, releases and managed support teams to ensure a smooth Go-Live. Implemented maintenance activities and improved the performance and reduced Disk Space costs. Monitoring EBS, Middle tier and Databases through Oracle 12C OEM. Supported the Fusion middleware components (WebLogic 11g, OBIEE, SOA) and Oracle Discoverer 10g with Oracle 11.5.10.2 instance. Environment: Oracle E-Business Suite R12.2.4, R12.1.3Oracle database (RAC and non-RAC) 11gR2, 11g (WebLogic, SOA), Enterprise manager cloud control 12c, Oracle Enterprise Linux, Oracle Sun Solaris 10 Keywords: information technology golang Arizona