Dilip Singh

OCI Certified Oracle Apps DBA with more than 18+ years of Total experience in Cloud Applications and Migrations.

Experience on Installation/upgrade of OAM/OID 12.2.1.4 on EBS R12.2.10 and Database 19c.

Experience in migrating enterprise application(s) to the Cloud like oracle EBS, discoverer and BI publisher to OCI. Have built, designed and architected applications for the Cloud. Deep understanding of client SDKs for various cloud services like OCI, AWS and Azure.

Pre-upgrade analysis, planning upgrade strategies. Expert level understanding of services offered by the applicable cloud provider. Ability to manage resources through available command-line tools, console/portals.

Ability to program and debug issues. Ability to do performance analysis and tuning of oracle databases and applications. Deep understanding of data modelling/UML, Architecture and Design Patterns. Expert knowledge of open-source web frameworks and databases.

Hands on knowledge of Development and Test processes including agile methodologies. Good understanding of application-level security mechanisms and basic level understanding of network security. Proficient in AD utilities and cloning of EBS applications.

Designs, tests and implements a database backup strategy (Hot, Cold, RMAN). Implementing and enforcing security for all of the Oracle Databases. Providing excellent management of workload, strong troubleshooting and problem-solving skill.

Sr. Principal Consultant-Oracle APPS DBA-IV - RACKSPACE (former TRICORE Solutions) - Gurgaon

(2012-04)

Customers: Brooks Automation, Sherwin Williams, Uponor Europe, Lydall, Aavid, Sig Sauer, Gulf oil, Allegro, Uponor US, Raleigh Durham Airport Authority, LifeFitness, A123 Systems, Cumberland Farms, Andrew Peller, AMLI Residential, Sycamore Networks, Antigenics Inc, Bruegger's Enterprises Inc, Mason Companies Inc, AZENTA Inc, Edwards, Netscout System Inc, Kopin Corporation, National Dentex Corporation, Empirix Inc.

Industry: Defense & Aviation, Manufacturing, Banking.

Project Type: Production Support, Implementation and Upgradation.

Environment: Oracle Applications and Oracle Database, Fusion Middleware.

• Upgraded the database from 9.2.0.7 to 10.2.0.4 and then 10.2.0.4 to 11.1.0.7
• Upgraded EBS R12.1.3 on 12c Database to EBS R12.2.5 on 19c Database
• Upgraded EBS R12.1.3 on DB 12.1.0.2 to EBS R12.2.10 on DB 19c
• Upgraded EBS R12.2.5 to EBS R12.2.13
• Upgraded 11i on DB 10g to R12.1.3 on DB 12c
• Migrated on-premise instances to OCI cloud
• Installation/upgrade of OAM/OID 12.2.1.4 on EBS R12.2.10 and Database 19c
• Created DR instances on OCI cloud and using under hybrid cloud infrastructure
• Created Oracle BI publisher and discoverer instances on OCI cloud
• Migrated oracle databases from on-premise to AWS using snowball
• Upgrade 11.5.10.2 application instance to 12.1.3 and 12.2
• Migration of Database from Solaris to Linux from 10.2.0.4 to 11.2.0.4(12c)
• SSO Migration from 10.1.4.3 to 11gR2(Oracle Access Manager)
• Add multilingual languages to EBS
• Performance tuning of various requests and provide solution to apps team
• Implemented OATM
• Performed clone of applications/database from RAC to RAC and RAC to non RAC
• Apply latest PSU and CPU patches to DB, Grid and application components
• Perform DR testing
• Installation and Configuration of Oracle Discoverer 11g
• Discoverer Installation and Integration with 11g R2 OAM and EBS R12
• Providing post upgrade support from Offshore for 1 month
• On-going projects plan and implementation
• Involve in process with task/change/ticket management

Lead Engineer – Oracle Apps DBA - Emerson Information Technology Solutions - St. Louis, USA

(2009-12 - 2011-11)

Customer: EMERSON - St. Louis, USA. Industry: Manufacturing. Project Type: Production Support, Implementation and Upgradation. Environment: Oracle Applications and Oracle Database.

• Upgraded the Oracle applications from 11.5.10.2 to 12.1.3
• Experience of Oracle 10g /11g RAC (10.2.0.4 /11.1.0.7 database) with Oracle Applications 11i,R12
• Installed Oracle Application Server and configured the Middle Tier
• Cloned the Oracle Application Server and configured on another server
• Configured the RMAN backup script on server to take online backup of database
• Performed installation, configuration and maintaining Oracle Applications and databases
• Patching 11i and R12 Applications including translations including Multilanguage patches
• Experience in Installation of Oracle Application Server 10g(Regarding OID installation for SSO implementation)
• Implementation performing of backup and recovery setups and procedures
• Ensure high availability of Oracle Applications & database by setting up DR and Standby
• Manage users including creation/alteration, grant of system / DB roles and permissions on various database objects
• Configuring Database Mail, Notification email, Unix OS level notifications
• Creating Maintenance plans for fixing index defragmentation, database backups
• Creating and Scheduled SQL & Unix jobs as per the customer's requirements
• Done jre upgrade
• To do the clone for weakly or daily basic as per User requirement
• Apply the patch as per user requirement
• Troubleshoot the user problem
• Troubleshoot the long concurrent request
• Trouble the Miscellaneous user problem
• User Printer issue

Sr Software engineer (Oracle Apps DBA) - Mahindra Satyam Computers Services

(2008-11 - 2009-12)

Customer: Cisco Systems. Industry: Manufacturing. Project Type: Production Support, Upgradation and Maintenance. Environment: Oracle Applications and Oracle Database.

• Installing and configuring the applications on multi node (11.5.8, 11.5.10.2, 12.1.3)
• Supported upgrade and migration of Oracle EBS 11.5.10.2 on a HP Unix to Oracle EBS 11.5.10.2 on a RH Linux platform
• Applications Upgrading, Cloning and Patching
• Cloning from RAC Production environment to Non RAC environment
• Implemented RAC and RMAN for test environment
• Configuring the apache webserver, Metric server, form servers and admin server
• Performance Tuning of Applications and database
• Install and configure 10g iAS with Infrastructure and Discoverer tier
• Monitoring Applications and Database Backups
• Manage 24x7 production and development support using offshore-onsite model
• Menu and functions creations, Profile Option Settings
• Creation of Concurrent Mangers, Programs, and Request sets
• Troubleshooting of Concurrent Requests and Request sets
• Knowledge of all business functional flow within the Origination
• Upgraded all Versions of Oracle Application Databases from 8.1.7.0, 9.0.1 to 9.2.0 Versions
• Monitored Hot and Cold backups
• Cloned All Versions of 11.0, 11i instances using Manual Clone, Adclone and Rapid Clone utility
• Developed Scripts for refreshing Development and QA databases
• Created new Concurrent managers and assigned programs to them based on the time they take to complete
• Oracle Application and Database support - Installation of Oracle Applications, Creating Clone instance, Patch Integration, Security in application and Database, Managing application and Database Usage, Backup and recovery
• Provide day to day and project support for Oracle 11i and R12 EBS Applications and 10g and 11g databases
• Patch analysis, patch application and deployment
• Instance cloning and post cloning activities
• Communicate to stakeholders via standard methods (e.g. orally, email, ticket system)
• Resolve incidents and problems, creating TARs as needed and working with Oracle and the customer to quickly resolve the problem
• Communication of same to stakeholders
• Development of technical procedures, scripts and associated documentation to improve existing processes and implement new ones

Sr Software engineer (Oracle Apps DBA) - Mahindra Satyam Computers Services - Bangalore, Hyderabad and Chennai

(2006-04 - 2009-12)