�ݺ�ߣ

Satyam Kapadnis
Kapadnis.Satyam.@gmail.com 9553541110
8686118757
Oracle Apps DBA Consultant
Summary
 Oracle ApplicationsDBA ConsultantforHitachi Consultingandamemberof AppsSupport,North-
East-Middle East and PPG Team since 3 years.
 With over 3 years of experience in Oracle Database Environment and 1.5 year of development
experience and worked on different clients with different environments in Support Team.
 Extensive experience in Oracle Application Releases (11.5.10.2 & R12), installing, applying
Patches, Cloningroutine DBA tasks, periodicRefreshes,oracle supportdealingwith Functional,
Developers and end Users.
 Hands on experience onDatabase 9i,10g and 11g Refreshand Cloningof Oracle Apps 11i & R12
to non-prod.
 Strong hold on RMAN utility for scheduled Backups, Recovery and Restoration of Database.
 Expertise inhandlingDailybackups,Patching,Cloning,Performancetunings,monitoringdatabase
growth, trouble shooting and database maintenance activities.
 Experience inMonitoringandAdministeringOracle RAC (Real Application Clusters) Databases.
 Expertise in DATAGUARDbycreatingSTANDBY databaseandmaintainingfilesystemonStandby,
performed Switchover to Standby in case of Production Failure.
 Monitoringalertlogsforerrors andfixingthem(Ex:ORA-600, ORA-7445 etc.).
 Creating SR with Oracle Support for critical issues
 Golden Gate monitoring and administration
Technical Skill Set :
 OS : Linux, IBM-AIX,HP-UX, Windows
 Oracle application and database : Oracle Applications (11i , R 12 ), OEM, Oracle releases
(9i,10G,11G), ApplicationServer10g,Oracle RAC,WebLogic,Mongodb., GoldenGate,people soft
and Siebel
 DB Technologies: RAC, Standby database
 Backup & Recovery : Hot Backups, Oracle RMAN
 Languages & GUI Tools : SQL, C, C++, JAVA,
 Monitoring Tools : OEM, SQL Developer , HEMS, ASD, Remedy

Responsibilities as Apps DBA
 Patchingand Patch Analysis
 Backup
 TroubleshootingOracle Appsrelatedissuesandtakingfeedback
 fromusersregardingsystemperformance
 Experience inApache,Forms,ReportsServeradministration
 Experience inStartingandStoppingof all ApplicationServices
 Trouble ShootingConcurrentManagersanddefiningthem
 Installationof Oracle ApplicationinSingle Node
 Cloningof Oracle ApplicationthroughRapidClone
 generate & Compile forms&reports
 AD utilities
 ConfigurationchangesinOracle Application
 AD ADMIN tasks
 Enablingaudittrail
 Creatingusersandresponsibilities
 AddingandconfiguringPrinters
 Enablingsignonaudit and audittrail
 Managing profiles
 Workflowadministration
Responsibilities as Core DBA
 Maintenance of installedOracle Database
 Applypatches(OPatch).
 Creatingand monitoringusers
 CreatingTable spaces,Space management
 Cloningof database & RDBMS software
 Backup and Recovery(ColdandHotbackup)
 Workedon 9i OEM, 10g OEMGrid
 coordinatingwithOracle Supportfortroubleshootingmajorissues
 PerformedswitchovertoStandbyDatabases
 Refreshingdevelopmentdatabase fromproductionusingexport/import

Responsibilities on Unix
 Installationsof Linux AS3.0/4.0,Oracle Enterprise Linux
 Creatingand managingusers,filesanddirectories
 Changingthe permissionsandownerships
 Managing the diskspace
 Checkingandinstallingpackages
 Settingupof remote connectivityusingtelnet,vnc.
Hitachi Consulting Experience
 Buildshell scriptsassolutionsforclientsthataddresscritical Oracle database monitoringacross
numerousplatformsandcorporate environments.
 Ensuredall monitoringandotherinitiativesandbestpracticesneededtotroubleshootthe
issuesrelatedtodatabase andApplications.
North-East Team(US-Clients)MAY 13-DEC14
 Client : 40+ Clients
 Project : NE
 Role : Consultant
Description
 North-Eastisa sharedpool whichsupportsmore than 40 clientsroundthe clock.We are using
assure service desktool toaddressall clientrequest.
Tasks
Supportto 40+ clients24x7 on shiftbasis.ProvidingsupportingEBSalongwithstandalone databases,
troubleshootingthe issues,performingthe scheduledactivities,suggestingthe clientforprocessand
technologyimprovements.Technical supportprovidingtoclientsinclude the below mentionedtasks.
 Maintainingmultiple instancesof 11i,R12 applicationsanddatabases.
 Oracle ApplicationsE-BusinessSuiteHealthCheck
 MonitoringdatabasesapplicationusingOEM.
 Applyingthe applicationpatcheswheneveritisrequired
 HandlingRMAN Backups.
 ConcurrentManager Issues
 Purgingof historicdata forbetterperformance (concurrentrequests,workflow).

 MonitoringAlerts
 MaintainingStandbydatabase,Testdatabase andDevelopmentdatabase.
 User managedbackupof Productiondatabase & Applications
 Sysadminactivitieslikeusercreation,responsibility creationandassignment,managing
concurrentmanager,workflowmonitoring,oracle alertsmonitoring,creatingnew menus&
requestgroups,UsingOAM,additionof new reports,managingprofile values, printer
configuration.
Middle-East Team Jun-16-Till date
Client: Dunia Bank Dubai Jun-16-Till date
Tasks and Responsibilities
 MaintainingOracle Applications(11.5.10.2& R12), Oracle Databases(10g & 11g).
 Oracle Application SystemAdministrationactivitieslike Usercreation,addingnew Printers,
Responsibilities,Passwordresets,assigningnewRolesand otherrequestsasrequiredbythe
user
 Responsible forDatabase Administrationof Oracle RAC and non RAC databases.
 Configureddailybackupsusing RMANand traditional methods.
 Performeddatabase RestorationandRecoveryusingRMAN utility.
 Handledcritical syncingissuesinSSOwithEBS.
 Extensive experience isenabling DBAuditing at bothOS & DB Level
 Performed EARDeploymentsinapplicationServer10g
 Managed andsupportedmissioncritical ProductionOracle 10g/11g databasesrunning24x7.
 Database Cloningof Productionserversusing Hot/Cold and RMAN backups to TestDatabase.
 Appliedoracle recommended Database patchesand Applicationpatches on various modulesto
fix the issues.
 CreatedSTANDBY database forPROD andmaintainedfilesystemonStandby.Performed
necessaryactionswhenStandbyisnotinsync.
 Performedsuccessful SWITCHOVERfromPROD database toStandby.
 AdministeringConcurrentManagersandtroubleshootingthe issuesincase of any Long Running
Concurrent requests.
 Creatingandfollowingup Service Requests withOracle Supportforexpedite resolution.
 Monitorusage of the databases,critical tablespaces,mountpointissuesandperform Database
Tuning to increase the performance.PlanforSystemgrowth and monitorcapacity Usage for

newhardware or software requirementsandcommunicate thesecapacityrequirementsto
storage management.
 Administeringall Database objects,includestables,views,packages,procedures,sequencesand
indexes.
 Monitorand troubleshootGoldengate issues
Prior Work History
AVSS
Developer, Nov 2011 –March 2013
 Website to fulfill academic needs of IT students, for projects, utilities and placements. Role wise
access for students,TPOs and Company HRs. Enables students to maintain their profiles, and
TPO’s and HR’s to create placements,walk-ins and get eligible candidates. It has mini mailing
system for communication. Integration with PayPalfor payments, and E-mail and SMS
integration for notifications to students
 Technologies: HTML,JSP, JavaScript,Java Servlet, JQuery, My-SQL, Apache Tomcat server
5.5, 7
Personal Profile:
 Date of Birth : 22th Aug1987
 Sex : Male
 LanguagesKnown: English, Hindi,Marathi
 Nationality: Indian

�ݺ�ߣ

Satyam Kapadnis

Recommended

More Related Content

What's hot (18)

Viewers also liked (16)

Similar to Satyam Kapadnis (20)

Satyam Kapadnis