Oracle Applications Production Support
Resume:
Oracle Applications DBA
Seeking a challenging role where I can leverage my expertise in Oracle, Oracle ERP, PostgreSQL Cloud and On-Prem technologies to architect, implement, and maintain robust database solutions, contributing to organizational success and innovation.
Over 15+ years of IT experience and 10+ years of experience in Oracle Applications DBA (R12/11i) and Oracle DBA (19C,12C,11G).
Good experience in Production Support using Exadata On-Prem, ExaCC and Azure environment.
Expertise in Production Support and Project Work on Oracle Apps DBA and Oracle DBA.
Experience in Installation, Cloning, Maintaining Instances, Patching, Space Management Issues, User Management Issues and Performance related issue to Oracle Applications and Oracle RDBMS.
Strong experience in Production Support using 5 RAC DB,6 Oracle Application Node and 3 CCM Node for EBS 11i.
Strong experience in Production Support for E-Business suite R12.2 and R12.1.
Extensive experience in implementing Oracle RAC with Oracle Applications.
Good knowledge on Oracle Exadata DMA.
Good knowledge on PostgreSQL DBA.
Good experience in implementing Oracle Standby Database.
Good experience in RMAN Backup and DB Upgrade.
Extensive knowledge of AD utilities like adop, adpatch, adadmin, adclone, adident, adctrl, admrgpch.
Backup and Recovery using Export/Import, Hot and Cold Backup, Managing Archives.
Cloning Oracle Apps using rapid clone and Database cloning using RMAN.
Automation shell script for cloning and alert monitoring.
SVN code migration setup for dev-test-prod path.
Good experience on Oracle EBS SSO setup.
Worked on Oracle Application PCP and Shared Application File System.
Lead and managed team, collaborate with project managers and stakeholders to plan and execute Oracle-related projects.
Excellent Communication, Analytical, Interpersonal, Presentation skills. *************@*****.***
Oracle DBA - Oracle Apps DBA
Bikram Mohanty
Phone: +1-737-***-****
CAREER OBJECTIVE
PROFESSIONAL SUMMARY
2
Oracle Applications Oracle Applications 11i (11.5.10.2) / R12 (12.1.3, 12.2.5,12.2.10) RDBMS ORACLE 11g/12c/19c.
Cloud Oracle Cloud(ExaCC), Azure
Tools TOAD, Putty, SQL Developer, OEM Grid 11g/12c/13c Front End Tools
Oracle Forms Developer, Oracle Reports Developer, Oracle Workflow Builder.
Operating System
Red Hat Enterprise Linux Server release 5.1/6.9/7.6 Sun Solaris 8, Windows NT 4 & Windows 2000, 2003 Advanced Server
Scripting Shell
Languages SQL, PL/SQL
● Working in Ancile Inc., Leander, Texas, USA since Feb 2024 - till date
● Worked in Conduent Business Services India LLP, Bengaluru from Jun 2021 to Jan 2024.
● Worked in HCL Technologies, Chennai/Bengaluru/USA from Sep 2010 to Jun 2021.
● Worked in Yash Technologies Pvt. Ltd., Hyderabad from July 2007 to Sep 2010.
● Oracle Certified Associate (OCA)
#1. Project : US Toll Plaza
Organization : Ancile Inc. USA
Role : Oracle Application DBA / Oracle DBA
Duration : Feb 2024 – till date
Environment : Oracle Applications 12.2.10, Exadata, RHEL 6.9/7.6, Oracle 12.2.0/19.0.0 Roles and Responsibilities:
Production support 24/7 on ExaCC and Exadata On-Prem environment.
Installed RAC and Standalone Oracle DB 19c.
Monitoring Oracle Applications Instance and Oracle Databases using OAM and OEM.
Interacting with customers to understand their technical queries and provide assistance in resolving them.
Worked with PostgreSQL DBA Team.
SQL Query tuning for optimized results using various tools (awr report, explain plan, tkprof )
Rebuilding of Indexes for better performance, maintenance of Oracle Database.
Using Exp & Imp and Data pump to refresh the schemas.
Performing daily health checks for all production and non-prod databases.
RMAN backup and restore activities.
Performance tuning and troubleshooting on critical prod instances. TECHNICAL SKILLS
WORK EXPERIENCE
CERTIFICATION
PROJECT EXPERIENCE
3
DB refresh from production to non-prod environment.
Created non-prod database and same has been given handover to DEV and QA team for their development and QA activities.
#2. Project : Highway England Transportations
Organization : Conduent Business Services India LLP, Bengaluru Role : Oracle Application DBA / Oracle DBA
Duration : Jun 2021 – Jan 2024
Environment : Oracle Applications 12.2.5, Azure, RHEL 6.9/7.6, Oracle 12.1.0/19.0.0 Roles and Responsibilities:
Project Work with Production Support.
Installed RAC and Standalone Oracle DB 19c in Azure platform.
Installed EBS 12.2.5 in two nodes.
Configure OEM for newly build production DB.
Worked on Times Ten oracle DB.
Creating schemas according to user requirement and assigning roles.
Handling day-to-day problems with high level of interaction with users through phone/email.
Solving the user problems and migration of Changes to Test and Production using Incidents and Change Control’s.
Performing daily health checks for all production and non-prod databases.
DB refresh from production to non-prod environment.
SSO setup on Oracle EBS.
Performance tuning and troubleshooting on critical prod instances.
Rebuilding of Indexes for better performance, maintenance of Oracle Database.
Applied CPU/RU patches.
Standby database configuration and DR Test.
Maintenance and cloning activity for every weekend.
Using Exp & Imp and Data pump to refresh the schemas.
Applied application patch using ADOP method for various activities.
ETCC validations on both database and applications.
Automation on oracle alert and DBA monitoring work.
RMAN backup and restore activities.
Yearly Table Partition on big size tables.
Involved on Team management activities.
#3. Project : VMWare IT Operations
Organization : HCL Technologies, Chennai/Bengaluru/USA Role : Oracle Application DBA / Oracle DBA
Duration : Mar 2011 – Jun 2021 (Offshore), Feb 2016 – Aug 2017 (Onsite) Environment : Oracle Applications 11.5.10.2, RHEL 5.6/7.4, Oracle 11.2.0.3/12.1.0/19.0.0 Roles and Responsibilities:
Production support 24/7.
Worked as a team member with Control Team and DBA Dev Ops, Prod Ops Team.
Supporting and managing of production instances and Oracle Applications environments of varied complexity.
Database performance monitoring during Load Tests.
Supporting many virtual database servers along with physical db servers. 4
Monitoring Oracle Applications Instance and Oracle Databases using OAM and OEM.
Performed Oracle DBA activities during SAP Project Implementation.
Interacting with customers to understand their technical queries and provide assistance in resolving them.
Cloning of Oracle Applications 11i using Rapid clone from Multi Node to Multi Node.
Cloned the instances from production to Test, Development instance to test & simulated few technical challenges, coordinated with testing and development teams.
Troubleshooting concurrent manager, discoverer, forms, reports.
Applying patches for fixing bugs in the applications, performing patch analysis and making the document before applying patches.
Worked with Onsite / Offshore Release Engineering team during code migration in various project.
Applying application patches (adpatch and using hot patch option).
Follow-up with Oracle Product Support through Metalink for any issues that Functional Consultants raises.
Various sysadmin functions like administer concurrent managers, defining users, request sets and submitting requests.
Patch Oracle EBS using ADPATCH utility.
RMAN Tape backup and restore activities.
Shell script automations.
Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data and monitoring of the concurrent manager operations.
Interacting with Functional consultants to schedule the Concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times.
Performed overall health checks on the database/Applications at regular intervals to ensure smooth operation.
Planning for backup and recovery of database information and maintaining Backups using Expdp/Impdp.
ACL and Wallet configuration.
Apps, Sysadmin and product schema yearly password change activity.
Created Custom Concurrent Managers to assign critical concurrent programs in order to reduce CCM server load and fast run.
Applied CPU/PSU Patch using OPatch utility.
Adding space on ASM Diskgroup using oracleasm and asmtool.
Exp/Imp and Expdp/Impdp (Schema and table and one schema to another schema).
Creating schemas according to user requirement and assigning roles.
Handling day-to-day problems with high level of interaction with users through phone/email.
Solving the user problems and migration of Changes to Test and Production using Incidents and Change Control’s.
Registering Menus, Responsibilities, Forms, Concurrent Programs.
Created and managed user accounts and Oracle Applications security, including roles, responsibilities, menus, functions, profiles and privileges
Agent installation and Alerts configuration in OEM.
Configured the Workflow to Oracle Applications.
Configured the Printer to Oracle Applications.
Trouble shooting Workflow order and mailer related issues.
Monitoring tablespace and adding datafile to production database asm diskgroup path after creating emergency change request.
Vertex sales tax update on every month end.
5
#4. Project : Tom Lee Music and Meadville
Organization : Yash Technologies, Hyderabad
Role : D2K Developer and Reporting Team
Duration : July 2007 to Sep 2010
Environment : Oracle Applications 11.5.10.2, Red-Hat Entreprise Linux 4.7 Roles and Responsibilities:
Design, develop, and maintain Oracle Forms and Reports applications using Developer 2000 suite tools.
Registering custom report using XMLP and RDF.
Customize Oracle Forms and Reports applications to meet specific business needs and integrate them with Oracle Applications.
Database testing based on the report given by QA/Dev Team.
Worked with monitoring team to monitor tickets, oracle jobs, reports and various alerts.
Design user-friendly interfaces for Oracle Forms applications, ensuring ease of navigation and optimal user experience.
Master in Computer Application (MCA) from Sambalpur University (BPUT), India
CMMI V 1.2, Oracle Applications - Yash Technologies
Quality Management System Training - Yash Technologies
Hadoop, Greenplum Database and Hyperion - HCL Technologies Bikram Prasad Mohanty
Texas, USA
QUALIFICATION SUMMARY
PROFESSIONAL TRAININGS
Contact this candidate