Home

Naresh P - Oracle DBA

[email protected]

Location: Remote, Remote, USA

Relocation: NO

Visa: GC

NARESH PERISETTY Sr. Oracle Applications DBA [email protected] 5715953159 Professional Summary: Twenty plus years of IT experience, As Oracle Applications DBA involved in life cycle Implementations. Providing support to 120 plus production, development, test instances comprising of complex and challenging environments from versions R12.2.10, R12.2.6, 19C, 12C, R12.2.5, R12.2.4, R12.1.3, 11.5.X,9i,10g,11g. Experience includes server migrations, cloning, patching, database upgrade, sync and split from source to target, code movements, shell scripting, backup & Recovery, hot/cold backups, cronjobs and proactive health check of the database. With resource limitation of 2 provided 24 X 7 support to the reporting environment. Support activity includes creation of reporting instances, daily releases, and on duty tasks. Knowledge in Database administration activities like physical database design, database creation and maintenance, user schema, space management, performance tuning activities, besides developing applications using RDBMS, PL/SQL. Achieved certificate of excellence for outstanding contribution from GE Energy services. Received RCL award for Excellence in Infosys for superior performance. Have experience with a variety of cloud deployment models Azure/AWS and experience with migrating on-premise to cloud, specifically OCI. Certifications Oracle Corporation OCA 9i Certified. Upgrading to 12C OCP. Federal 6C clearance from the Department Of Education in process. Technical Skills ERP Environment Oracle Applications R12.2.10, R12.2.X, R12.1.3, 11.5.10.2,11.5.9,11.5.8,11.5.7, 11.0.3,10.7, R12.2 Systems Administration, 11i Systems Administration, workflow Notifications setup and Administration, Report Builder: 10.1.2.3.0, Forms 10.1.2.3.0, Oracle Fusion Middleware (FMW) 11.1.1.9.0, Oracle WebLogic Server (WLS) 10.3.6.0.12. Tools Oracle Cloud Infrastructure, Recovery Manager [ RMAN ], STAT, Real Application Cluster [RAC], Oracle Enterprise Manager, Discoverer, Markview, Noetix, Data Guard,10gGrid, WCI, Apex, Remedy, Change management, SOA, Winscp, Toad, Net APPS technology, OPAS.Azure,AWS, Jira, Micro Services. Database Oracle 19C, 12C, 11g,10g, 9.2.0.8, 9.2.0.7, 9.2.0.6, 9.2.0.5, 9.2.0.4, 8.1.7.4, SQL Server Programming UNIX Shell Scripting, SQL, PL/SQL, C, VB6.0, ASP Operating Systems Linux 7, Linux 6, Sun Solaris 5.9,2.8,2.6,2.2, Redhat Linux 2.1/3.0 AS, HP UX, Windows NT, 2000 Hardware Fuji Primepower 650 12GB 4 2.1GHz Solaris 5.9, IBM x330 1.3 GB 2 1400 GHz Win 2000 Server, Fuji Primepower 250 8GB 2 1.9GHz Solaris 5.9 Application Servers Apache, 10g IAS, 9iAS, Java web server Professional Experience OptumServe [Department of Education (Federal)] Washington,DC March 2017- Till Date Environment: Oracle Applications R12.2.10, R12.2.5, R12.2.X, 11.5.10.2, Oracle 19C, 18C, 12C, 11g SQL Server 2019, 2014 AIX, LINUX, UNIX Responsibilities: Upgraded EBS from 11.5.10.2 to R12.2.6 for Department of Education (Federal) environments including PROD & Non Prod. Upgrading EBS applications from 12.2.5 to 12.2.10 Upgraded EBS database from 12C to 19C. Upgraded all custom databases from 12C to 19C. Involved in full cycle Data Center Migration for all DB s & APPS. Weekly clones of all non-prod instances in R12.2.5 for Hudson Advisors environments. Implemented auto clone scripts for both DB and Applications for all financials and non-financials instances. Applying quarterly PSU patches for both DB and Applications for all financials and non-financials instances. Troubleshooting major issues like FND_LOBS and other critical issues in daily support. Maintaining all changes through Change requests and Service Requests to get proper approvals following the workflow. Involved in planning, designing and executing an on premise to Oracle Cloud Infrastructure migrations. Participated in performing administration of OCI virtualization systems using native Oracle Cloud Infrastructure services, performing analysis, tuning, and troubleshooting. As a lead involved in activities that include creating and decommissioning systems as part of administration activities. Assist with migration of environments as necessary across datacenters and assist with Cloud based initiatives. Involved in training users on applications and OS fundamentals for virtual infrastructure within OCI. Involved in gathering all year-end audit reports and all documents related to Audits and actively participating in all audit discussions to make sure it closes smoothly. Automated startup and stop scripts for core and financials databases and applications. Actively involved in managing offshore resources with proper task updated and actively shadowing the daily tasks with standup and weekly meetings. Making sure all documents are properly updated for all tasks in one-note after all maintenance is done along with daily troubleshooting tasks. Verifying with offshore resources in daily monitoring including all backup s, alerts, critical failures and guiding them to take proper action plan when failures occurred. Managing offshore resources to make sure maintenance and daily tasks complete successfully with a well automated maintenance plan. Created FSL s for new server requirements for DCM & upgrade projects. Upgraded SQL server instances to latest versions. Supported all activities related to upgraded R12.2.6 APPS & upgraded 12C DB. Involved in migrating databases from AIX to Linux using Transportable tablespaces XTTS. Upgrading all databases from 11g to 12C along with FMSS using multitenant architecture. Bringing up all the instances to latest CPU patch levels by applying quarterly released patches from oracle including grid patches. Cloning of non-prod instances using PROD instances involving netapp technology. Applying patches regularly using the new ADOP utility. Migrating builds as per scheduled maintenance to various instances. Troubleshooting issues related to FMSS, CPSS, G5 applications. Tuning applications and databases for better performance on existing and upgraded instances. Up to date CPU patch analysis of DB & Applications and applying those patches on time for federal auditing. Integrating 3rd party tools like sunflower, OAM, PIV card access to FMSS and CPSS systems. ComTec Information System Solutions (Relypsa),CA Jan 2016 Mar 2017 Environment: Oracle Applications R12.2.6, R12.2.4, 11.5.10.2 Oracle 11g, 12c , AIX, LINUX, UNIX, other Cloud deployments with AWS/Azure. Responsibilities: Implemented R12.2.4 in Relypsa environments including PROD & Non Prod. Monthly clone of non-prod R12.2.4 instances using PROD instance. Applying patches regularly using the new ADOP utility. Implementing customizations in new R12.2.4 as per new standards. Taking daily & weekly DB & APPS backup using RMAN. Involved in Monthly cloud maintenance activity with the 3rd party vendors (Data Dimension & NTT Data). Troubleshooting daily issues of OPP and actively working on migrations by coordinating with technical and functional teams. Providing storage and CPU recommendations to the cloud team as per existing 12 environments. Guiding offshore teams with proper handshake and pending tasks as per the requirements. Planning to have Integration Architecture which involves understanding how to integrate data into a specific IT architecture, specifically OCI Databases and Big Data and understand fundamentals and applications of concepts in relation to data migration and standup of infrastructure in OCI. CoreLogic Solutions ,Dallas,TX Nov 2012 - Jan 2016 Environment: Oracle Applications R12.2.4, R12.1.3, 11.5.10.2 Oracle 11g, 12c, Solaris, Linux, Windows Responsibilities: Actively participated in oracle financials upgrade project from 11.5.10.2 to R12.1.3 from initial Stage to go live which includes gathering requirements, design, development and Customizations. Involved in applying any critical CPU patches for latest updates from oracle and setting up auto clone procedures for existing environments to avoid manual maintenance. Maintenance and stabilization of Production, Development and Test Instances of Corelogic family which includes all tools integrated to oracle applications and databases. Setting up backup and restore strategy for the latest oracle database versions using Recovery Manager [ RMAN ] Successfully implemented Data Center Migration [DCM] project. Implemented STAT tool and developed scripts for all instances to integrate with the tool. Wels Fargo Adapter successfully implemented in R12 instances with all configurations. Setup of AQ-Streams done in all R12 instances including pre and post setup steps. Involved in FACL migration project with post migration support. Installed R12.2.4 oracle financials still under UAT phase. Created CHAMP database for HR usage which includes TDE implementation. Accomplishing business criticality requirement for oracle financials high availability by implementing Real Applications Cluster [RAC]. Implementing best storage practice Automated Storage Management [ASM] for the business to improve performance. Throughout the pre and post upgrade process actively worked on instant issues raised by users which includes deep analysis of firewall and network related issues. Extensive support for month end activities including the resolution of printer issues. Involved in all support activities for upgraded R12.1.3 instances including PROD, TEST and DEV instances with user satisfaction. Actively involved in migrations during post and pre upgrade process. Involved in resolving all issues related to Discoverer administration. Quick and accurate in resolving daily high volume support activities by coordinating with technical and functional teams with proper documentation for audit through service online and OPAS tickets. Actively involved in raising storage and firewall requests as and when required per the requirement. Involved in Quarterly disaster recovery [DR] activity. Regular maintenance activities including month end, year-end tasks in scheduled down times. Available for any unscheduled bounce and other maintenance tasks. Infosys Technologies,Dallas,TX Aug 2010 Nov 2012 Environment : Oracle Applications R12.2.4, R12.1.3, 11.5.10.2 Oracle 9i, 10g, 11g, Solaris, Linux, Windows Responsibilities: All support activities for upgraded R12.1.3 instances including TEST and DEV instances. Actively involved in migrations during post and pre upgrade process. Maintenance of Production, Development and Test Instances of Neiman Marcus Family. Involved in Analysis and upgrading apps from 11.5.10.2 to R12. Daily support activities like resolving high volume genie tickets and printer issues. Completing all scheduled migrations on daily basis by coordinating with HRMS and Finance teams with proper documentation for audit. Maintaining Accelio printer setup by coordinating with DC operations team. Regular maintenance activities on weekends with scheduled down times. Available in 24/7 Environment for any unscheduled bounce and other maintenance tasks. Involved in annual testing of DR setup at IBM site. Regularly Cloning Neiman Marcus Dev and Test instances from production instance. Additional Exp rience SRS consulting Inc,CA since May 2009 Aug 2010. Liverpool Victoria,London,UK since Sep 2008 May 2009. Genpact,India since May 2006 Jul 2008. KPIT Cummins Infosystems Ltd,India since Jul 2005 May 2006. Celtic Technologies,India since Nov 2004 Jul 2005. Sahara Computers pty ltd,Botswana,Africa since Apr 2002 Nov 2002. Education B.E - Computer Science (1997 2001 from Gulbarga University) Keywords: cprogramm user experience database information technology golang hewlett packard procedural language California Texas