Sign in

Oracle Dba

October 26, 2018

Contact this candidate


Swapnil Pathare +91-976*******

Lead Oracle Apps & Fusion DBA

Expert in Oracle Database, E-Business Suite and Fusion Middleware Applications administration CAREER ABSTRACT

• 7+ years of DBA experience in Implementation, Upgrade & Support projects.

• Hands on experience in technical problem solving, automation, process improvement and documentation skills.

• Experienced in leading a team of 10+ members in 24x7 Database Support Operations for multiple US, UK and Gulf


• Have range of experience working in various roles as Individual contributor, Team Member. Have managed several

medium and small projects simultaneously. Confident to mentor, train and guide team to achieve objectives.

• Experienced in closely working with various support group teams, admins, business end users to constantly improve the performance and availability of applications & databases. EMPLOYMENT HISTORY

• Since Jan’18 with HCL Technology Pune as Lead Technical Consultant.

• Jun’15 – Jan’18 with Fujitsu Consulting India Pvt. Ltd, Pune, India as Senior Technical Consultant.

• Dec’10 – May’15 with Mannai Corporation (Techsignia Solutions,India) Qatar as Consultant. ACADEMICS

• Bachelor of Computer Applications Tilak Maharashtra University, Pune with First Class May 2011.

• Diploma in Information Technology, from Board of Technical Education, Mumbai with First Class in July 2007. TRAININGS

• Attended Oracle DBA training from SQL Star, Pune.

• Attended ITIL training at FCI India.

• Attended Oracle Fusion Middleware training at FCI India. TECHNICAL SKILLS






Operating System


Tools & Utilities

Ticketing Tools


- Oracle E-Business Suite Applications 11i, R12.13 and R12.2

- Oracle 8i, 9i, 10g, 11gR1 and R2, 12c (RAC, ASM, DG, RMAN, Vault)

- OEM 12c Grid

- Oracle 9iAS, 10gAS, Oracle Portal, Weblogic 11g, OAM, OID, 10gAS SOA Suite, Apache HTTP server

- Shell scripting, SQL, PL/SQL

- All Unix/Linux flavors & Windows Platforms

- VMWare 4.0, Oracle VM

- Putty, TOAD, PL SQL, Developer

- HP Service Now, BMC Remedy

- Hyperion, Open Text,Sabrix,Revpro


Some of the Key projects/clients, I had the opportunity to work in:

• Fujitsu [JPS US, Vitamix, TBA, Merrill Corp, CAFOS, Foods, Advics, Fellowes, Xeta Technologies, Zebra Technologies, Terex, ADPC, etc]

- Worked as Apps & Fusion DBA in dedicated projects like Been sports, JCCTV, JPS, Aegon religare, Qafac etc.

- Worked as DBA Team lead & Onsite coordinator for JPS & Aegon religare

- Worked as lead a team of 10+ DBAs for offshore RDBA shared service support operations.

- Worked in creating new proposals & bids.


Swapnil Pathare +91-976*******

Lead Oracle Apps & Fusion DBA

• Mannai & Techsignia [BMI Bank Bahrain, Been sports,Darwish CCQ, QAFAQ,JCCTV,ADLQ Qatar & Reef


- Worked in India & Middle East locations in various implementation & upgrade projects.

- Worked as Oracle Apps shift DBA lead in 24x7 database support operations.

- Worked as a remote Oracle APPS DBA for multiple customers.

- Worked as Oracle DBA for multiple custom ERP projects. KEY PERFORMANCE AREAS

Technical Skills

Oracle Apps DBA

• Worked in Oracle eBusiness Suite (R12.1 & R12.2) implementation and upgrade projects.

• Worked on support projects for 11i, R12.1 and 12.2 version various oracle applications that include

PROD/DEV/CRP/TEST/PATCH setups. Experienced working with eBusiness suite applications on all UNIX flavors.

• Cloning multinode to multinode, multinode to single and single to multinode eBusiness suite applications.

• Automated end to end R12 EBS clones for optimal DBA utilization.

• Patch analysis and application using both opatch, adpatch and adop utilities. PSU, CPU and RPC patch analysis &


• Worked on performing Java version upgrades and performing Java heap settings.

• System Administration - creation of users, responsibilities, requests, data group, request set, menus, roles, managing concurrent managers, setting up profile options, managing the project access to users.

• Worked on configuration of workflow and workflow related issues.

• Working exposure of shared appl top, load balanced nodes, PCP configuration, etc.

• Worked on eBusiness suite applications troubleshooting and performance issues.

• Integrated eBusiness suite applications for SSL.

• Rich experience working in EBS applications environments for HRMS, ASCP, Finance, etc.

• Installation & upgrade of databases 8i, 9i, 10g, 11gR1, 11gR2 & 12c.

• Worked on ASM/OCFS2 setup, 10g & 11g RAC installation on Linux.

• Worked on RAC to RAC binary clones. Also worked on CPU/PSU patching.

• Database tuning including tuning sort operations, application tuning, SGA, PGA, tables, table partitions,

indexes, UNDO, redo logs, using AWR, ADDM, statspack, etc.

• Configured DB Vault with eBusiness suite applications. Have expose to OUD-EUS setup for database secure logins.

• Planning and implementation of database backup policy using RMAN.

• Creating and implementing DR Strategy. Created physical standby using Oracle Dataguard.

• Implemented and configured 12c OEM grid control.

• Logical backups with help of import and export utility

• Installation & Support of Oracle Fusion middleware applications like OID, OAM, WebLogic etc.

OID • Setup and troubleshoot user sync & login issues from Directory Services like

• Worked on OpenText configuration activities for EBS environments. OS Administration

• Linux installation. Setting up Kernel and other memory parameters.

• Knowledge of Shell scripting. Created shell scripts to automate process.

• Monitoring and analyzing Operating System CPU, memory, I/O usages through default OS utilities.


• NFS mount point setup. IP address configuration. Basic networking setup knowledge.

• OS user/group creation and management. Kernel and rpm version install/upgrade.

• Installation of required RPM’s

Team Management

• Managing the Resource alignment according to the scheduled and running project work.

• Managing the tasks of manpower planning, induction and training of technical teams.

• Creating an environment that sustains & encourages high performance and motivating team members in

optimizing contribution levels. Contributing towards team building and knowledge management.

• Mentor and coach junior DBA team members by assisting and sharing knowledge. Customer Relationship Management

• Interacting with clients to understand technical requirements for providing the best solutions.

• Ensuring customer satisfaction through periodic meeting, handling requests and issues to closures. Project Management

• Plan, and schedule the installation and testing of new products and improvements to current systems.

Maintaining the set SLA standards.

• Participating in periodic project review meetings for measuring project progress, identifying & understanding

problems and suggesting improvements. Estimate time and cost required for a successful accomplishment.

• Provide technical specifications for application enhancements. Participate in application

customizations and extensions.


Date of Birth




- 4 Oct 1983

- Indian

- Available

- English, Hindi, Marathi


Swapnil Pathare +919*********

Lead Oracle Apps & Fusion DBA

Contact this candidate