Engineering Training
Resume:
Pratik H. Dabholkar
E/***, Ashok Nagar ‘B’,
Bldg No.1, Vazira Naka,
Borivali(West),
Mumbai-400092
Mobile : 961-***-****
Email ID : *****************@*****.***
B.E. (Information Technology)
Atharva College OF Engineering
Career Objective:
To keep up with the carrying edge of technologies and to do hard work. Looking for a challenging opportunity to explore and excel challenging task. To secure a challenging position in a reputable organization to expand my learning’s, knowledge, and skills as an experienced Oracle Apps DBA.
Technical Skill Set:
Languages: - C,C++,HTML, SQL, Oracle DBA, Android.
Programming Environments:- Turbo C, NetBeans, Eclipse, Android Studio, SQL developer, TOAD.
Operating Systems:- Windows, Linux, Solaris, AIX 7.1.
Database:- Oracle 10G,11G,12C
Application:-R12.1,R12.2,OID 11g,WEBGATE 11g, Discoverer 11g, DMZ-EBS, Weblogic Server 11G.
Experience:
Have 2 Years and 6 months of hands on experience as an Oracle Apps DBA at Clover Infotech Pvt Ltd. (Andheri, Mumbai).
Client Details:-
Axis Bank Ltd. (Elphinston)
1)Monitoring of Concurrent requests.
2)Monitoring of Database and mount points.
3)Monitoring of multi node application.
IDFC First Bank Ltd. (Airoli)
1)Monitoring of Production and DR RAC Database and Multi-Node Application.
2)Application of Master GDF(MGDF) patches.
3)Application level patches(R12.1)
4)Cloning for UAT instance using RMAN backup.
Huhtamaki(The Paper Product Ltd.) (Thane)
1)Daily Production and DR Database and Application monitoring.
2)Application of MGDF patches.
3)Cloning for UAT instance using RMAN backup.
4)DR database creation.
5)Application level user creation & assignment of responsibilities.
6)Password change through front end & by using FNDCPASS utility.
7)Monitoring of Concurrent request & Concurrent managers.
8)Cloning of APEX application.
9)Movement of forms & reports from UAT to Production instance.
10)Enabling of trace for a user & running network test.
11)Application patching using ADOP utility(R12.2).
12)As a System Administrator, created users and responsibilities, adding responsibilities, resetting user password if locked, monitor concurrent requests, concurrent managers, troubleshoot long running requests, enable debug logs using Profile Options to troubleshoot issues.
13)Monitoring of Application services using Weblogic(11G).
Eclerx Services (Airoli)
1)Daily monitoring of Databse, Mountpoint and Application services.
2)Weekly purging of logfile.
3)Application patching using adpatch utility.
4)Cloning for UAT instance using Cold Backup.
Kotak Mahindra Bank Ltd. (Goregaon)
1)Daily Monitoring - SSO Login, EBS Login, Synchronization between AD and OID, Workflow mailer(Inbound and Outbound), Blocking Sessions, Concurrent Managers and Long Running Requests, Mount Points for EBS Server, Database Server, OID Server, Discoverer and DMZ.
2)Troubleshooting Login Issues (Single Sign on Login Issues), Synchronization issues between AD and OID.
3)Troubleshooting of various request issues (blocking sessions, blocking object, long running request), java form issues.
4)Patching Activities like ADPatch for Rapid Clone Patches, CPU Patches, RUP Patches, GDF Patches.
5)Workflow Configuration and Maintenance.
6)Troubleshooting long running sessions and queries by using AWR.
7)Maintain, delete and handle user information in ODSM.
8)Shutdown and Restart of Discoverer services.
9)Purging Activities once in 3 months because of increasing database size.
10)Code Migration through FNDLOAD.
11)Table, Views, Index, Sequence, procedures and package creation with the support of functional and technical team as per requirement.
12)Monitoring of sessions through v$session and v$session_longops views.
Deepak Nitrite Ltd. (DNL) (Vadodara)
1)Monitoring of Production and DR database and Applications.
2)Patching using ADOP utility (R12.2).
3)Familiar with adsplice, adopreports,adopmon utilities.
4)Cloning for UAT instance using RMAN backup.
5)Creation of ERP user and assignment of responsibilities and roles.
6)Movement of reports(rdf) and forms(fmb) from UAT to production instance.
7)Monitoring of inactive sessions using v$session, v$session_longops and v$resource_limit views.
8)Handling of printer services configured in ERP using Common UNIX Printing System (CUPS).
9)Monitoring of Workflow services and status for particular user notification using workflow type and user key.
10)Monitoring of ASM storage space and ASM database.
Training and Certification:
Completed C and C++ Training Conducted by Spoken Tutorial Project, IIT Bombay.
Completed training in Android development.
Completed Certification in Oracle SQL Fundamentals-1 (11g)
Completed Certification & Training in Oracle Certified Associate (OCA) 11g.
Academic Projects:
Title: Ranking and Mapping Of Hotels and Restaurants.
Duration: July’15-April’16
Role: Collection of database (Details of hotels and restaurants.)
Description: Based on our framework, we propose novel algorithms that efficiently predict the effectiveness of a keyword query. Our extensive experiments show that the algorithms predict the difficulty of a query with relatively low errors and negligible time overheads. Google Maps used for Mapping hotels and restaurants.
Team Size: 4
Educational Qualification:
Year
Degree
University/ Board
Percentage/Grade
2016
B.E. INFORMATION TECHNOLOGY
Mumbai University
57.58% (Agg Sem 1 to Sem 8)
2011
H.S.C
Maharashtra Board
56.67%
2009
S.S.C
Maharashtra Board
81.38%
Extra Curriculum Activities:
Attended seminar/campus conference organized by Asus India.
Participated in National Conference on Technological Advancement & Automatization in Engineering (NCTAA) conducted by Atharva College of Engineering.
Published papers in International Journal (IJARCCE).
Personal Details:
Date of birth:- 17th January 1994
Languages known:- English, Hindi, Marathi, Konkani
Marital Status:- Unmarried
Hobbies:- Listening to music, Playing cricket and chess, travelling, cooking.
I hereby declare that the information furnished above is true to the best of my knowledge
Place: Mumbai
Date: 24th January 2020 (Pratik H.Dabholkar)
Contact this candidate