Looking for great challenges as APPS DBA on R12.2 Applications Administrator and
databases in a growth-oriented Company utilizing my abilities developed through my education with an opportunity for career growth on my merit and to promote the growth of the organization.
Handling more than 200+ production and non-production databases and Oracle EBS.
Having 5+ years of experience as an Oracle E-Business Suite and core Oracle Database Administrator.
Awarded with Rookie Award and Client Delight award at Infosys.
Leading Team for weekend activity like Reboot of Database and Application Services.
Expert in performance tuning and part of Performance engineering team for Oracle Practice at Infosys.
Part of month end closure War-room DBA monitoring and tuning Critical Performance issue during month end close for GL schema.
Worked on troubleshooting issue with third party application like Appworx which connect to Oracle database.
Worked on Oracle EBS 12.2 migration and clone.
Expertise in troubleshooting ADOP cycle 12.2 process with hands on experience.
Good exposure on R12 and R12.2.
Analysis AWR Report
Experience in RMAN backups.
Worked on Admin and managed servers for Weblogic.
Excellent Documentation skills along with communication skills
Oracle EBS R12 single and multi-node RAC Troubleshooting support
Experience in Oracle utilities EXPORT & IMPORT.
Monitoring the oracle application & concurrent manager administration and tuning.
Oracle application code migrations using FNDLOAD and WFLOAD.
Cloning the databases and performing database refreshes.
Oracle EBS application database refresh and rapid cloning the entire applicaiton along with database.
User managed backups and Backups and Recovery activities using Recovery Manager.
Upgrade 12.1 to 12.2 E business Suite
Expertise in AD utilities like adpatch, adadmin, adctrl, adop etc.
Schedule the database and application health checks scripts through cron jobs.
Proven ability to work independently as well as in a team.
Ability to interact with developers, coordinate and manage the tasks assigned, backend by strong technical knowledge.
Given 24/7 support to project and resolving the user issue as per severity and SLA PROFESSIONAL EXPERINECE:
Working as Technology Analyst (Oracle APPS DBA) with Infosys on Cummins Project, Pune Jan 2016 to till Date.
Completed Infosys Generic and Stream Training, Mysore Jul 2015 to Dec 2015 TECHNICAL SKILLS
Operating System Linux, Unix, Oracle Solaris, Exa-data and Exa-logic system Databases & Tools 12c,Toad Oracle, NVA_Citrix Xen App BMC Remedy, Service Now Monitoring Tool
Other Utilities Putty, ClearCase tool, WinSCP,VNC server, Appworx, PROJECTS:
Company : Infosys
Client : Cummins
Environment : Oracle 11g, oracle apps 11i, R12.2, Sun Solaris Role : Senior Oracle Apps dba
Duration : Jan 2016 to till date
Role and Responsibilities:
Maintained and troubleshoot several issues occurred to client in 12.1.3 & 12.2
Worked in Performance engineering to tune down Oracle database and presenting same to client as part of additional enhancement.
Applying Patches on DB & Applications using OPatch & adpatch, ADOP.
Performed Cloning/Refresh of test instances from production (application & database).
Patching Activities like CPU, PSU - DB and Application patches.
Involved in analysis and application of JWS (Java Web Start) feature related Patches to EBS environments and enablement of JWS feature.
Logging SR and coordination with oracle support for bugs and patches.
Troubleshooting Performance issue on Concurrent requests
Worked on Demantra Rebuilt activities over weekend.
Worked on enhancement activity for deployment of CNI which helps Users to get their work done by themselves without needing DBA involvement.
Break the DR sync between production and DR. Then open the DR database and configure the application. Perform sanity which include forms, reports and concurrent manager functionality then rebuild the DR from production.
Enabling Java Web Start (JWS) and APPLLDM feature on in EBS instances.
BMC Remedy tool for ticket monitoring.
Monitoring Alert log file and resolve ORA error if any.
Monitoring the Concurrent Manager & troubleshooting problems, viewing the log/out files for resolved the issues of concurrent requests.
Troubleshooting the Application System which includes login problems, and regenerating application components and file system (forms, reports, menus and jar files) relinking executables and database problems.
Day to day system activities ranging from DB & Application performance monitoring, OS health status
Space management and maintenance at DB and OS levels.
Monitoring all backups and troubleshooting on the failure backups.
Built New Test, Development, SIT, UAT & Production Instances
Monitoring tablespaces running short of free space, resizing or add datafiles
Purging Concurrent requests, requests log and out files, purging unnecessary patch log and worker log files
Performed front end sysadmin activities like user management, profile management, configure managers, conc Requests, request groups etc
Performing patch analysis and application of patches for resolving performance and bug issues.
Worked on dB link issues.
Worked on MWA Server and related issues.
Database error monitoring
Well versed in all AD utilities
Monitoring Database and troubleshooting performance issue through 12c & 13c OEM.
Worked on Code & AOL migration as per Cummins Process.
Troubleshooting apache, oacore, oc4j, form related issues Certification Details :-
Oracle Certificate Details: - https://www.youracclaim.com/users/kunal-lekhi LinkedIn Profile: - https://www.linkedin.com/in/kunal-lekhi-2a042859 Personal Details
Languages Known : English, Hindi, and Punjabi
Nationality : Indian
Marital Status : Un-married.
Passport : Valid
I hereby confirm that above information is correct to my knowledge. Thanks and Regards,
Kunal K Lekhi