Oracle Applications Technical Lead
Resume:
Haritha Lanka
Oracle Applications DBA
Technical Lead
Contact
Address
Issaquah,WA 98029
Phone
*******.*****@*******.***
linkedin.com/in/haritha-l-
93848468
Technical Skills
Oracle 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: RECOVERY
MANAGER (RMAN),
EXP/IMP, DATA PUMP AND
OEM
Languages: SQL, PL/SQL,
UNIX SHELL SCRIPTING.
Tools: PUTTY, VNC
VIEWER, TOAD, SQL
DEVELOPER.
Tuning Utilities: TKPROF,
EXPLAIN PLAN,
STATSPACK, AWR, ADDM,
SQLTRPT
Experienced 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 Summary
Technical Lead Jul 2019 - Present
Oracle Applications DBA
Berry Global, IN, USA
Providing 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.
Competencies
Oracle Database and E-
Business Suite
Administration.
Database Installation,
Configuration, Patching and
Upgrades
Backup and Recovery
Strategies.
Database Security and
Compliance
Proficient in scripting
languages such as SQL,
PL/SQL, and Shell scripting
Performance Tuning and
Optimization
Troubleshooting and Problem
Resolution.
Documentation and
Knowledge management
Certifications
Oracle Cloud Infrastructure
2023 Architect Associate
[1Z0-1072-23]
Oracle Cloud Infrastructure
2023 Foundations Associate
[1Z0-1085-23]
Oracle Cloud Infrastructure
2021 Cloud Operations
Associate [1Z0-1067-21]
Education
Master of Business
Administration (MBA)
2006-08
Collaborating 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 2019
Oracle Applications DBA
Oracle Corporation, CA, USA
Worked on projects for
o De Lage Landen, PA, USA Oct 2017-Apr2019
o Specialized Bikes Components, CA, USA Mar 2017- Mar 2018 o City of Atlanta, GA, USA Aug 2016- Feb 2017
o AMC Entertainment, Inc., KS, USA Oct 2015-Aug 2016 o Metrolinx,Ontario, Canada Oct 2014 - Sep 2015
o Office Depot, FL, USA Dec 2012 - Nov 2014
o The J.M. Smucker Co,OH, USA Feb 2010 - Nov 2012
Installed, 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.
.
Contact this candidate