Sritam Mohanty

In IBM, I have been associated with various industries where I have primarily worked as an Oracle Cloud DBA to perform complex EBS application Upgrade (Primary Work) + Oracle Database upgrade to 19c and Hypercare support (Secondary).

• Experience in end-to-end Upgrade of Oracle EBS Application from R12.1.3 version to EBS R12.2.x for four separate customers belonging to different industries
• Performed end-to-end Upgrade of Oracle Database from 11.2.0.4 to 19.16.0.0 version
• Resolved critical application & Database post upgrade issues raised during Hypercare period
• Coordinated with Oracle support team from APAC, EMEA and USA time zones to resolve issues related with EBS R12.2, Oracle Database WebLogic products
• SSL with TLS 1.2 Implementation Using CA signed, Internal CA signed and Self Signed Certificates
• Robust experience in ADOP patching cycle and its related issues
• Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR2 (11.1.2) using Oracle E-Business Suite AccessGate
• Performed EBS Schema Migration Steps (EBS_SYSTEM)
• Setup EBS Workflow, Inbound and outbound connectivity with OAUTH 2.0 protocol
• Cloning of EBS R12.2 file system from Multi node to Multi node and Multi node to Single node
• Applied Translation Synchronization Patches (TSPs) in EBS environments
• Configure Third-party services such as Kofax/Markview and More4apps
• Implementation of TDE and Flashback in Oracle Databases
• Involved in Cloud migration of On-prem environments to OCI Cloud
• Configure OEM Monitoring for Enterprise applications
• Performed Platform Migration from Solaris to Linux 8.6 and its related issues for Oracle products
• Setup/Rebuild Oracle Active Dataguard
• Working experience with ad utilities such as adadmin, adrelink, adctrl, adsplice, admrgpch etc.
• Along with Upgrade work, I have contributed to resolution of P1 Performance related issues during month end closure times along with critical BAU issues - Opatch and adop patching, environment configuration, Concurrent Manager Issues, Data corruption etc.) and actively involved in Critical PSU patching for Oracle Database and WebLogic, Data Guard drills and Certificate Update works.

Skills :-

I have been utilizing my rich past upgrade experience in my current and future project. This helps me avoid known issues and deliver work in due time with utmost success rate. I am also keeping track of new challenges faced so that it will benefit my current project in the long run.

I am certified with the latest cloud technology certifications by Oracle and have robust experience of working with Oracle Database, EBS application, Database and Application Architecture and Design, WebLogic, Oracle Cloud infrastructure and its components and monitoring tools.

In Oracle India Pvt. Ltd, I was a key member of the OMCS EEC team which handles 37+ production environments on OCI cloud. Different flavors of environments include EBS, Demantra, Vertex, Markview and Oracle Database.

• Administration of multiple ASM & RAC instances running on Exadata and non-Exadata machines.
• Administration experience of multinode EBS instances
• Involved in Command Center support (Second Lead) for critical outage, Performance and Patching related issues.
• Experience in applying regular of Oracle EBS and WebLogic patches, Database Patches and troubleshooting issues related to patching
• Experience in applying latest GRID and PSU patches and vulnerability fixes in Oracle EBS, Database, WebLogic and Reverse proxy hosts
• Configuring and Perform Oracle Database Backup and Recovery using RMAN
• Handson Experience in setting up Physical Standby Database (Data Guard) and performing DR switchover and switchback simulations
• Exposure in implementing advanced configurations such as RAC, PCP, DMZ, OAM/OID.
• Have dealt with in Oracle performance related issues and resolution
• Rebuild indexes, Reorg Tablespaces, PL/SQL package compilation
• Configured shared APPL_TOP, Parallel Concurrent Processing
• Handson experience with Demantra and Goldengate instances management
• Setup TDE for all tablespaces in EBS R12.2 environments
• Performing database backups using both RMAN, from OCI Console and Local backup (using Export/Import)
• Implementation and Upgrade experience of Oracle database to Release 12c and 19c
• WebLogic Performance monitoring and Tuning of GC overhead limits.

In Tata Consultancy services, I joined as a fresher where I got an opportunity to work with seasoned Database administrators. In hindsight, the kind of work I did in my first organization has laid the foundation of my current knowledge and skill set.

• Worked in 24/7 Production Support, Performed Daily BAU activities and scheduled RFC changes in due SLA
• Proactively Troubleshooting issues related to Oracle EBS and database and implementing the solution.
• Monitoring of mission-critical Oracle databases which includes monitoring of existing system, Overall Health, Data Integrity, Archival Process, Night RMAN backup job status
• SLA compliance, Ticket flow control, and RFC execution using Change management tools (bmc ticketing tool)
• Configuring Space Management alerts and Proactively mitigating issues in advance by monitoring the % usage alerts and disk space alerts
• Implementation of Backup and Recovery strategies to ensure data recovery in case of data loss (RMAN, IMPDP/EXPDP)
• Configuring Backup and Recovery using RMAN and creating duplicate databases
• User and Permissions Management :- Creation, update, Grant Privileges and Role assignment (Security)
• Debugging User issues because of database roles, profile settings, and privileges
• Involved in code migrations and deployments
• Apply One-off EBS and Database patches.
• Involved in database migration from on-prem storage to Azure Cloud
• Configuring and implementing Physical Standby Database.
• Cloning Oracle database and Application from Production server (Quarterly)
• Critical user Password Change (APPS, SYSTEM,Schema passwords and SYSADMIN) (Quarterly)
• Keeping track of all L2 daily activities like export/import schema/table, Gather stats, checking long-running concurrent requests in EBS.
• Database monitoring, event notification management and running SQL tuning advisor through OEM.
• Created new user accounts, profiles, and roles and assigned them to different end users
• Doing daily health check of the database for better performance (alert logs, OPP logs, trace files, AWR reports and long running concurrent programs)
• Performing regular Sysadmin activities (User creation, Responsibility assignment, role assignment through user management)