Debasis Meher

Experience

• 

  Innovative Solution Experts Pvt. Ltd

  May 2005 - Jul 2007

  Description : Support for Oracle Applications 11.5.10.2Client; OS : LINUX AS4Responsibilities as an APPS DBA: Responsible for applying the latest patch sets and one-off patches as required.Supporting Oracle applications 11i (24*7) whose size is more than 3 TBPrinter setup and troubleshooting various printing issues in Oracle Application.Applying archives to Standby Server.Cloning of Oracle Applications using Rapid clone utilities as per the business requirements of the client.Handling TARS.Purging Unwanted requests output and log filesRegularly checking Alert log file.Concurrent Manager administration,Compiling Invalid Objects.Monitoring Users, Concurrent Managers.Familiar with Utilities like ADADMIN, ADPATCH, ADCTRL etc.Generating Forms and Reports.Changing of passwords for APPS APPLSYS,USER and other schemas.Creating users and assigning responsibilities Environment : Oracle Applications 11.5.10.2 Contribution : Oracle Applications Maintenance using AD utilities Show less • Troubleshooting various Application user issues• Starting, shutdown and monitoring of Oracle Web Server, form servers, concurrent managers.• Database restoration and testing.• Configured RMAN for Backup and Recovery Purpose.• Index rebuilding and reorg of tables for defragmentation.• Database Administration like adding of datafiles, Monitoring tablespace, creation of indexes, tables, using TKPROF for trace files in Oracle Applications.• Scheduling jobs in DBMS SCHEDULER and DBA JOBS• Installed 10g CRS 10.2.0.3, upgraded to 10.2.0.4, Converted the single node database to a 4-node RAC database. Designed and configured a separate configurator instance, separate i-Store instance in DMZ for external access• Implemented supply chain and financial modules. Integrated SSO and Portal 10AS with ERP for SSO and OID based user base• Implemented shared APPL_TOP for reducing patching downtime significantly and ease of maintenance. Configured one application server for DMZ. Configured forms listener Servlet for access of forms through internet via DMZ. Configured multiple JVM’s and implementing JVM load balancing for scalability and high performance Show less

  • Oracle Application DBA

    Feb 2006 - Jul 2007

  • Oracle Application Database Administrator

    May 2005 - Jul 2007
• 

  INTEC INFOCOM Pvt. Ltd

  Aug 2007 - Dec 2008

  PROJECT #2

  Support for Oracle Application 11.5.9

• 

  INTEC INFOCOM Pvt. Ltd

  Aug 2007 - Dec 2008

  Oracle Application Database Administrator

  Oracle 11i Application DBA

• 

  IBM

  Aug 2007 - May 2011

  • Good knowledge of database concept, architecture, installation, patching, backup and recovery.• Installation and maintenance of Oracle Products on AIX, LINUX and SOLARIS platforms.• Good experience in Upgrading of Oracle Database.• Good experience in Patching of Oracle Database and Applications.• Patch analysis for database and application patches including patch-set and one-off patches.• Extensively worked on Oracle Applications AD Utilities.• Application and Database cloning (Manual and Rapid clone).• Management of Redo Log files, Control files and monitoring data files.• Creating users, allocating Table spaces to users, managing privileges with roles.• Performing health check of database and application services.• Complex ERP on 15 nodes High Availability (HA) Architecture with 4 node 10g RAC, integrated ERP with 10gAS, SSO and portlet• Extensive knowledge in Sun Solaris 2.6, 2.8. AIX 5.3 , and UNIX OS• Complex troubleshooting of hanging and looping issues, bugs and code performance fixes. Upgraded databases from 9i to 10g. • Worked in 24*7 worldwide database environments with 20 GB DML per day, few Terabytes ERP deployments Show less

  • Oracle Application Database Administrator

    Dec 2008 - May 2011

  • Oracle Apps DBA

    Aug 2007 - Apr 2011
• 

  IBM Project

  Dec 2008 - May 2011

  Oracle Application DBA

  • Supporting E-Business Suite 40 production and test instances (Total 192 node).• Oracle Financial application Having GL,AP,AR, SCM, Oracle Learning management, iSupplier, iExpense, iRecruitment, HRMS etc.• Maintaining Bharti Retail production database.• Maintaining 4 Old Oracle Financial Instance .• Supporting Six CRM Production instances: Mobility, Telemedia, AES, Jersey, DTH and Sri Lanka.• CRM application Having Service, Order Management, Sales and Marketing.• Database in multi node RAC having Oracle, Veritas and IBM HACMP Cluster.• Multi node (2,4,8 node) Oracle application with Load balancer and SHARED APPL TOP technology.• Discoverer and Oracle Email Server are integrated with oracle application.• Maintaining the standby, BCV, DR and stream database.• Working with the various development teams very closely to maintain the instances for project development and implementation. • Cloning of development and Test instances from production in RAC environment.• Applying patches requested for DEV and PROD instances.• Setting/writing of Monitoring/cronjob for automated alerts for monitoring instance• Worked on implementing RFC’s.• Supporting day-today maintenance activities like startup/shutdown,changing passwords of USERS, compilation of forms, adadmin and working on various Oracle application related issues.• Logging TAR and coordination with oracle support for bugs and patches.• Implementing SSO and SSL on dev instances.• Supporting Oracle applications 11i (24*7) whose size is more than 5 TB• Registering customize Reports, PL*SQL, SQL in Oracle Application.• Implemented DMZ with I-Supplier Module.• Application system administration - user accounts, user passwords, responsibilities, setting profiles.• Oracle Application patch installation.• RMAN Backup and testing.• Implemented Oracle Streams for production database.• Application and concurrent manager troubleshooting. Show less

• 

  Polaris Consulting & Services Ltd

  May 2011 - Feb 2013

  Team Lead Oracle Practice

  Project Title :- Oracle 11i DB Up-gradation and Migration Migration of Existing DHL Prod ( Australia and Pfizer India Instance ) from Single Node to Multinode with Upgradation of Database ,Capacity planning , Server Sizing , DST Implementation , DR implementation according to client requirements. RolesAnalyze client setup and develop project plan for apps upgrade. Develop project plan for fresh implementation Patch Analysis and Patch Application for application Oracle Database cloning which using advanced techniques. Automation of cloning. Upgrade /Migration Monitoring Database and Application Instances Performance Monitoring. Collection and Analysis of Staspack , AWR reports, Performance Tuning of Database Documenting the Solution and work with Project Lead . Shift Management Hardware Recommendations (Includes Server Sizing ) Install Vision Instance. Install Fresh DEV / CRP / UAT / PROD instances Single Node to Multi Node Production Migration of 11i Application Integration of Shared File System , Up gradation of JRE , JDK . Install and Configure Discoverer 10g GRID implementation (11.5.10.2) ASM configurations and CRS configurations Load Balancer Configuration. Configure PCP Client meetings to discuss the architecture and future growth decisions. Application and Database Tuning. Cloning using RMAN from RAC to non RAC Documentation of Issue faced during course of project and provide solution , document SOP for all DBA related Activities provided. Help Client during Go Live & provide Post Go Live Support. Show less

• 

  Oracle

  Feb 2013 - Apr 2016

  Oracle implementation lead

  Oracle Managed Cloud Services

• 

  Cognizant

  May 2016 - Jul 2024

  Manager Projects
• 

  JPMorganChase

  Jul 2024 - now

  Lead Infrastructure Engineer