Oracle Apps DBA

Sandip Sourav Nayak

08886230002

OBJECTIVE:

To be a good software professional and associated with progressive organization that give me scope to update my knowledge and skills in accordance with latest trends, be a part of time, dynamically work towards growth of organization, and gain satisfaction thereof.

EDUCATION :

B.Tech (Electronics & Instrumentation) from Biju Pattnaik University

PROFESSIONAL SUMMARY:

  • Having 6+ Years of experience in the field of Oracle Apps DBA having actively involved in Installation,Cloning, Upgradation, Patching phases on LINUX ,SUN SOLARIS, HP-UX and

IBM-AIX environment.

  • Working in 24 X 7 Production support environment providing support to Oracle applications, Oracle

production,development and test databases comprising some of the more complex and challenging env

  • Currently working in Genpact India as a Consultant
  • Skilled in ORACLE APPS DBA, PL/SQL,FMW,SOA,RAC ORACLE, UNIX (Shell script, Linux Utilities and process).
  • Knowledge in UNIX File Management System and Memory Management.
  • A fast learner with a positive attitude and flair for innovative ideas and excellent team player.
  • Versatile Team player with Good Communication and problem solving skills.

SOFTWARE CREDENTIALS:

Platforms :, SUN SOLARIS 5.10, Oracle Linux 5

Programming Languages : PL/SQL, ORACLE, SQL,UNIX

Database : Oracle 9i,10g,11gR2

ERP Packages : Oracle Applications 11i, Release R12

Technical Knowledge : Database, Operating System

Tools : Oracle SQLPLUS, Telnet, Putty, SSH

RDBMS : Oracle 9i,10g,11g

WORKING EXPERIENCE:

Organization / Period / Designation
Path Infotech ltd / 23-May-2011to 14-May-2014 / Associate DBA
Wipro / May-2014 to Aug-2014 / Consultant
Genpact India / 26-Nov-2007 – Till date / Consultant

OVERALL RESPONSIBILITIES:

  • Installed Oracle database 9i 10g, 11g and Applications Release 11i and Release 12.
  • Analyzed and applied patches in Oracle Applications using adpatch, adop.
  • Applying and analyzing patch in RAC environment.
  • Applying and analyzing demantra patch, weblogic patch, obiee patch,soa patch.
  • Cloning Oracle Applications 11i,R12,12.2.3 and database.
  • Cloning of RAC environment.
  • Upgraded Oracle database from 9i to 10g and10g to 11g.
  • Upgraded Oracle application from 12.1.1 to 12.1.3
  • Upgrade database from 11.2.0.4 to 12c with jre and jdk upgrade
  • Upgrade oracle application from 12.2.5 to 12.2.6
  • Hands on exposure on DR and DG setup.
  • Knowledge about active datagurad and flashback datagurad.
  • Used various AD utilities in Oracle Applications.
  • Use of Data pump.
  • Use of utility like crsctl, srvctl.
  • Activation of Archive Log Mode.
  • Creation of Database users.User and Session tracing Managing tables, Tablespaces
  • Administrating software and tools in line with the clients requirements
  • Evaluating, monitoring and managing the clients database
  • Developing and maintaining an up to date knowledge of practice area specific Oracle products and services
  • Ensuring Successful &Periodical Backup, Restoration & Tuning
  • Act as liaison to interact with the database vendors.
  • Conceptually know Performance Tuning by use of (oradebug & tkprof)
  • Custom Top Creation
  • Troubleshoot problems with concurrent managers, Apache processes and database performance.
  • Managing backup and recovery procedures for all production and development databases.
  • Managing all errors and tuning on R12 application environment.
  • Documenting the build process and reviewed the same with team.
  • Database Maintenance Activities
  • Driving Performance Calls
  • Online Re-org
  • Communicating with the customer from time to time in keeping him update on the progress of various tasks and also recommending him various aspects which might help them work more efficiently.
  • FMW/SOA installation .
  • Configure a new domain , manage server logs, monitor server activates, configuration of server properties.
  • Installation & Configuring domains for Fusion Middleware like SOA and OSB.
  • Deployed Applications (WAR, JAR&EAR) in Domain and Clustered environment.
  • Configuring the JDBC & JMS resources in web logic.
  • Deploying SOA composite applications,
  • Configuring SOA composite application resources,
  • Monitoring SOA composite applications,
  • Managing and Monitoring service engines, and updating the state of SOA composite applications.
  • Demantra,obiee installation.
  • Maintaining third parties like Sabrix , Aventx , ,Markview .
  • Worked on different cloning procedures like manual and RMAN clone .
  • Project Details

#1 providing database support as Oracle APPS DBA to GE

Project Description / General Electric(GE) is an Americanmultinationalconglomeratecorporation incorporated inNew York,[4]and headquartered inBoston, Massachusetts.[2]As of 2016, the company operates through the following segments:Power & Water,Oil and Gas,Aviation, Healthcare,TransportationandCapitalwhich cater to the needs ofFinancial services,Medical devices,Life Sciences,Pharmaceutical,Automotive,Software DevelopmentandEngineeringindustries.
Client / GE
Start and End Date / Aug 2014 to till date
Role / Apps DBA
Contribution /
  • worked on different unix flavour like Red hat Linux,IBM-AIX, and HP-UX
  • Applying and analyzing patch in oracle application 11iR12 and12.2.3 using adpatch,adop .
  • Applying and analyzing cpu,cluster patch and patching in rac environment.
  • applying and analyzing time zone patch
  • Clone of oracle application 12.2.3
  • Cloned oracle core databases (9i/10g)
  • Clone oracle applications 11i,R12 using rapid clone method (single node to multi node cloning , multi node to multi node).
  • database upgrade from 11.2.0.3 to 11.2.0.4
  • upgrade rac and non rac database from 11.2.04 to 12.1.0.2
  • Cluster upgrade from 11.2.0.3 to 11.2.0.4
  • upgrade oracle application 12.1.1 to 12.1.3
  • upgrade oracle application from 12.2.4 to 12.2.5
  • upgrade oracle application 12.2.5 to 12.2.6.
  • Installation of Weblogic and SOA.
  • Build oracle ebs environment 12.2.5 with configuration of demantra,weblogic,obiee,ssl,sso
  • use and manage different third party tool like Aventx,mobile service.dollar u,extranet,sso,hvr
  • managing demantra service,bi service.
  • deployment of war files in demantra service,rpd files in obiee
  • applying and analysing patch in demantra,obiee,weblogic.
  • apllying and analyzing cpu patch,jre jdk pgrade
  • Knowledge of oem
  • Fundamental knowedge about RAC
  • use of shell scripting for monitoring and managing database
  • Responsible for recovery in DR & DG databases for production databases
  • Configure physical data guard for production database
  • Resolved the recovery issues such as recovery stuck, recovery delay.
  • Resolved cloning issues which occurred during cloning oracle 11i ,R12applications using rapid clone
  • Patching oracle 11i,R12 applications using adpatch, adop oracle core database using
opatch utility.
  • Resolving patching issues during adpatch , opatch
  • Resolved oracle applications services issues like apache, concurrent manager, forms, report server issues.
  • Resolved issues like login issues , long running concurrent requests , issues faced by the application developers
  • Application user creation / responsibilities assignment.
  • Gathering apps tables, schema statistics
  • Resolved database related issues faced by the development team
  • Providing efficient resolution to production alerts (mainly p1 & p2 issues)
  • Responsible for maintaining good backup plan by taking regular hot and cold backups.
  • Export/import of schemas and other db objects such as table space, tables etc from production to test/dev.
  • Providing security related privileges or roles to user as per client requirement.
  • Monitoring Performance of database, finding high temp table space, high CPU consuming queries, high undo space using sessions and providing trace and tkprof o/p to tuning team.
  • Monitoring of production Instances and sending health check reports.
  • Monitoring table space utilization , and performing user management activities
  • Worked as on Call DBA for all the production environment
  • Providing weekend support such as maintenance work of production databases.

Environment/Database / Oracle11.510.2/R12.1.3,12.2.3, Oracle 9i/10g,11g
Operating System / Redhat Linux, Sun-solaris 11
Team Size / 50

#2 providing database support as Oracle APPS DBA to FORTIS

Project Description / Fortis Healthcare Limited is a leading, pan Asia-Pacific, integrated healthcare delivery provider.The healthcare verticals of the company span diagnostics, primary care, day care specialty and hospitals, with an asset base in 5 countries, many of which represent the fastest-growing healthcare delivery markets in the world.
Client / Fortis
Start and End Date / May 2013 to May 2014
Role / Apps DBA
Contribution /
  • Adding and merging nodes to existing erp.
  • Resolve user related issue.
  • Implement webcache as load balancer for forms node.
  • worked on different unix flavor like Red hat Linux, IBM-AIX, and HP-UX
for dba activity
  • Use of shell scripting for monitoring and managing database
  • Responsible for recovery in DR & DG databases for production databases
  • Configure physical data guard for production database
  • Resolved the recovery issues such as recovery stuck, recovery delay.
  • Cloned oracle core databases (9i/10g)
  • Clone oracle applications 11i,R12 using rapid clone method (single node to multi node cloning , multi node to multi node).
  • Upgrade erp from 12.1.1 to 12.1.3
  • Resolved cloning issues which occurred during cloning oracle 11i ,R12applications using rapid clone
  • Patching oracle 11i,R12 applications using adpatch, oracle core database using
opatch utility.
  • Resolving patching issues during adpatch , opatch
  • Resolved oracle applications services issues like apache, concurrent manager, forms, report server issues.
  • Resolved issues like login issues , long running concurrent requests , issues faced by the application developers
  • Application user creation / responsibilities assignment.
  • Gathering apps tables, schema statistics
  • Resolved database related issues faced by the development team
  • Providing efficient resolution to production alerts (mainly p1 & p2 issues)
  • Responsible for maintaining good backup plan by taking regular hot and cold backups.
  • Export/import of schemas and other db objects such as table space, tables etc from production to test/dev.
  • Providing security related privileges or roles to user as per client requirement.
  • Monitoring Performance of database, finding high temp table space, high CPU consuming queries, high undo space using sessions and providing trace and tkprof o/p to tuning team.
  • Monitoring of production Instances and sending health check reports.
  • Monitoring table space utilization , and performing user management activities
  • Worked as on Call DBA for all the production environment
  • Providing weekend support such as maintenance work of production databases.

Environment/Database / Oracle11.510.2/R12, Oracle 9i/10g,11g
Operating System / Redhat Linux, Sun-solaris 11
Team Size / 4

#3providing database support as Oracle APPS DBA to Maruti Suzuki

Project Description / Maruti Suzuki India Limited (MSIL), a subsidiary of Suzuki Motor Corporation (SMC), Japan, is the leader in passenger cars (PCs) and multipurpose vehicles (MPVs) in India, accounting for nearly 50 per cent of the total industry sales.In 2009-10, the Company sold 1,018,365 vehicles. This comprised 870,790 vehicles in the domestic market and 147,575 vehicles in export markets. Cumulatively, it has produced and sold over 8 million cars.SMC is the majority shareholder with 54.21% equity stake in the CompanyMSIL has two manufacturing facilities in Gurgaon and Manesar, Haryana, India, with a combined manufacturing capacity of over 1 million cars per annum. In terms of number of cars produced and sold worldwide, the Company is the largest subsidiary of SMC, Japan.
Client / Maruti Suzuki
Start and End Date / May 2011 to till March 2013
Role / Apps DBA
Contribution /
  • Creating oracle databases (9i/10g)
  • Installing oracle applications 11i with multi node configuration
  • Database upgradation from 9i to 10g
  • Responsible for recovery in DR & DG databases for production databases
  • Resolved the recovery issues such as recovery stuck, recovery delay.
  • Cloned oracle core databases (9i/10g)
  • Clone oracle applications 11i using rapid clone method (single node to multi node cloning , multi node to multi node)
  • Resolved cloning issues which occurred during cloning oracle 11i applications using rapid clone
  • Patching oracle 11i applications using adpatch, oracle core database using
opatch utility.
  • Resolving patching issues during adpatch , opatch
  • Resolved oracle applications services issues like apache, concurrent manager, forms, report server issues.
  • Resolved issues like login issues , long running concurrent requests , issues faced by the application developers
  • Application user creation / responsibilities assignment.
  • Gathering apps tables, schema statistics
  • Resolved database related issues faced by the development team
  • Providing efficient resolution to production alerts (mainly p1 & p2 issues)
  • Responsible for maintaining good backup plan by taking regular hot and cold backups.
  • Export/import of schemas and other db objects such as table space, tables etc from production to test/dev.
  • Providing security related privileges or roles to user as per client requirement.
  • Monitoring Performance of database, finding high temp table space, high CPU consuming queries, high undo space using sessions and providing trace and tkprof o/p to tuning team.
  • Monitoring of production Instances and sending health check reports.
  • Monitoring table space utilization , and performing user management activities
  • Worked as on Call DBA for all the production environment
  • Providing weekend support such as maintenance work of production databases.
  • Co-ordinate with oracle in case of any technical issue resolution through TAR
  • Installation of oracle application server 10g.
  • Managing and monitoring application server 10g

Environment/Database / Oracle11.510.2/R12, Oracle 9i/10g
Operating System / Redhat Linux, IBM-AIX, HP-UNIX
Team Size / 7

Education: B.Tech in Applied Electronics and Instrumentation Engineering from D.R.I.E.M.S., Orissa.

Reference:Will be furnished on request.