| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Oracle Applications DBATechnical LeadContactAddressStreet Address Westridge Way NE,Issaquah,WA 98029PhonePHONE NUMBER AVAILABLEE-mailEMAIL AVAILABLELinkedInLINKEDIN LINK AVAILABLE93848468Technical SkillsOracle E-Business Suite:R12.2.X, R12.1.3, R12.1.2,11i.Oracle Databases:19c,18c,12c,11g,10g,9i.Operating Systems: UNIX,LINUX, SOLARIS 9,10, HP-UX, IBM-AIX, WINDOWS.Database tools: RECOVERYMANAGER (RMAN),EXP/IMP, DATA PUMP ANDOEMLanguages: SQL, PL/SQL,UNIX SHELL SCRIPTING.Tools: PUTTY, VNCVIEWER, TOAD, SQLDEVELOPER.Tuning Utilities: TKPROF,EXPLAIN PLAN,STATSPACK, AWR, ADDM,SQLTRPTExperienced and highly skilled Oracle E-business Suite Administrator with 14+ years of experience in managing, optimizing Oracle Applications and Databases.Proficient in Oracle E-Business Suite (EBS) and Oracle Database Administration, Installation, Configuration ensuring high availability, performance, security, and scalability in Oracle E-business suite environments managing concurrent programs, printers, workflows, and application servers. Professional SummaryTechnical Lead Jul 2019 - PresentOracle Applications DBABerry Global, IN, USAProviding Support and Maintenance of Oracle Applications 11i and R12 Production and Non-prod instances.Implementation and maintaining Data Guard on all the production databases.Implementation and Monitor Daily Database Health checks by alerts from Oracle Database and applications.Worked on DB Migration from Windows to Linux using transportable tablespace and upgraded Database from 11.2.0.4 to 18c standard edition.Experience in migration of Database and Applications from On- Premises to Oracle Cloud Infrastructure.Experience in Database Re-org to reclaim unused storage.Experience in configuring and maintaining the printers.Experience in deploying certificates in application servers.Contributed in SOX Audit process for Database and Applications.Skilled in applying OS security patches in Linux Servers.Proficient in setting up PGP/GPG Encryptions for file transfers.Skilled in configuring password less connection between servers.Periodically updating production application passwords on a quarterly basis.Implementation of Alert Mechanism thorough crontab using shell and SQL scripting and addressing alerts.Scheduling automated Weekly, Daily, hourly (L0, L1, archive) RMAN backups for production databases.Conducting weekly scheduled/ad hoc Cloning of Oracle Applications from PROD to NON-PROD environments.Weekly Code migrations to production requested by development team.CompetenciesOracle Database and E-Business SuiteAdministration.Database Installation,Configuration, Patching andUpgradesBackup and RecoveryStrategies.Database Security andComplianceProficient in scriptinglanguages such as SQL,PL/SQL, and Shell scriptingPerformance Tuning andOptimizationTroubleshooting and ProblemResolution.Documentation andKnowledge managementCertificationsOracle Cloud Infrastructure2023 Architect Associate[1Z0-1072-23]Oracle Cloud Infrastructure2023 Foundations Associate[1Z0-1085-23]Oracle Cloud Infrastructure2021 Cloud OperationsAssociate [1Z0-1067-21]EducationMaster of BusinessAdministration (MBA)2006-08Collaborating with user requests, including code moves, forms compilation, and management of tables and indexes.Addressing tickets raised by technical/functional teams and end users.Resolving issues related to concurrent managers and workflow mailer within the system.Working with Rimini/Oracle Support to address production issues, providing necessary files and system logs, and applying patches as advised.Configured EBS with Java Web Start (JWS).Monitoring database and application performance using OEM 13c.Performed test iterations for Oracle Applications Upgrade from version 11.5.10.2 to R12.2.4.Senior Consultant Feb 2010 Apr 2019Oracle Applications DBAOracle Corporation, CA, USAWorked on projects foro De Lage Landen, PA, USA Oct 2017-Apr2019o Specialized Bikes Components, CA, USA Mar 2017- Mar 2018 o City of Atlanta, GA, USA Aug 2016- Feb 2017o AMC Entertainment, Inc., KS, USA Oct 2015-Aug 2016 o Metrolinx,Ontario, Canada Oct 2014 - Sep 2015o Office Depot, FL, USA Dec 2012 - Nov 2014o The J.M. Smucker Co,OH, USA Feb 2010 - Nov 2012Installed, Upgraded and administered Oracle Applications (11i to R12.1.x/R12.2.x, R12 to R12.2) and Oracle Database (9i to 10g/11g, 11g to 12c) on different platforms as per client specifications.Worked on Cross platform Migrations of Oracle Application and databases to new servers along with DB upgrade and Application upgrades.Experience in applying Oracle Database and EBS patches, including CPU and PSU patches, to maintain systems at the latest security patch levels.Patching Oracle Applications R12/R12.2 (such as WLS patches, Fusion Middleware patches, DST, CPU, Online help, Patch Wizard recommend patches, Localization patches etc.)Managed Oracle Applications using AD utilities (ad admin/ad patch/ad splice/admrgpch/ad ctrl/ad relink/adop patching cycle).Added multiple additional nodes for Oracle E-Business Suite Release R12/R12.2.Addressed performance-related issues during upgrades by analyzing statistics, SQLTRPT, Locks, CPU usage, AWR, ADDM, SQLT, Explain plan, TKPROF etc.Worked on Oracle Applications clones for 11i/R12 and R12.2.9 instances.Configured shared appl-top, PCP (Parallel Concurrent Processing), Load balancing, and DMZ settings.Collaborated with the CEMLI team by loading data using data pump during selective upgrades and fulfilling other requests such as creating new users, establishing DB links, enabling/disabling constraints and triggers, etc.Export/Import of tables, tablespaces and Database using Expdp/Impdp Oracle utilities.Conducted regular monitoring, troubleshooting, and proactive maintenance to identify and resolve issues, minimizing downtime and maximizing system performance.Cloning from Production instance to Dev/Test instances using RMAN utility.Engaged with Oracle Support on Priority Issues with Priority 1 Service Requests and conducted issue research using Oracle Meta link.Configure Workflow Mailer and Perform SYSADMIN tasks such as user account creation, responsibility modification, profile settings, request scheduling, tracing, etc.Developed numerous Shell scripts (UNIX) for managing/monitoring Oracle databases and set up Crontab for required scripts.Perform and Monitor Oracle Database Daily Health checkups by Shell scripts, ensuring database availability, listener status, space utilization, Data Guard status, Concurrent Manager status, Workflow Mailer status, backups, long-running Concurrent requests, etc.Contributed to a team providing support for Oracle Databases and Applications in a high availability (24*7) environment.Raised service request for the long running jobs and worked closely with Oracle support to resolve Performance issues.. |
