Abdul Muqeet Khan Mohammed

Supporting 300+ Oracle databases and 25+ EBS 12.2.14 applications in 24/7 envirounment

Support Exadata X10M, ZDLRA appliance, Linux VMs/PCA and Participates in Exadata and Linux Server patching, Running Exacheck and addressing all the issues reported, Manage and monitor Cellsrv, MS, RS services using celladmin

Administer and Managing Grid Infrastructure and Oracle RAC databases in a high-availability environment including Grid and RAC DB PSU/Bug fix patching and Troubleshooting

Apply process and architectural improvements to continually improve the availability, capacity, and performance of database systems

Cloning of all Oracle EBS and DB Instances, Provide EBS patch analysis and apply patches in patching cycle using ADOP, Applied Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environment.

Implement Parallel Concurrent Processing PCP, Add/Remove managed servers as needed.

Supporting of high availability RAC environment and Managing CDB, PDBs and non-PDBs databases,

Set up and monitor DR databases manually and using data guard broker, Exercise Perform planned switchover/failover to physical standby database.

Implemented robust backup and recovery solutions, ensuring business continuity through well-designed disaster recovery and data protection strategies in conjunction with GoldenGate replication

Applications Maintenance tasks using ad-utilities tools like ad-admin, adop, auto-config etc.

Day to Day General Database Administration task like Creating users, Privileges and Roles, Profiles, Segments, Tablespaces, Datafiles, UNDO and TEMP management.

Troubleshoot and resolve Oracle EBS related issues like Web services, Forms, WebLogic, Concurrent Manager etc.

Troubleshoot performance issues of slow databases and long running concurrent requests.

Database monitoring and tuning, application and queries using AWR, ASH, ADDM, OEM and custom scripts, Routine checks on databases. This includes checking whether all databases are running, listener is running, UNIX error messages, disk space availability, CPU & Memory usage, errors in alert logs and trace files, etc using OEM Alerts and cronjobs

Implemented and maintained GoldenGate replication setups, optimizing data integrity and availability across critical Oracle database systems, configuring and troubleshooting GoldenGate environments

Open and follow-up with Oracle on service requests for Apps and DB related issues, Work closely with multi-functional teams, including system administrators, network engineers, and application developers, to ensure seamless integration and optimal performance

Documenting Project Operations & Creating a CHECKLIST to manage a smooth and stable environment.

Provided 24X7 support for multiple Prod/Non-Prod Oracle database and EBS application in high pressure intensive multi node environments from 2 TB to 35 TB databases on Exadata and Linux VMs

Migrating and Supporting Oracle EBS databases on OCI ExaCs.

Supporting Oracle databases of PeopleSoft and SAP hosted on Azure Cloud and 200+ Oracle databases on AWS RDS

Supporting other Databases in AWS RDS (SQL Server, MongoDB, Postgres)

Support and managed uni-directional-directional Oracle GoldenGate replication across multiple Oracle environments, ensuring high availability, real-time data synchronization, Daily monitoring like Process Health Check, Lag, Error & Log Review, Trail File & Disk Usage, Data Consistency Check etc and troubleshooting GoldenGate environments

Day to Day General Database Administration tasks like Creating users, Privileges and Roles, Profiles, Segments, Tablespaces, Datafiles, UNDO and TEMP management

Streamlined backup and recovery processes, enhancing overall system stability and availability.

Ensured database security with implementation of role-based access control and regular vulnerability assessments.

Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.

Built databases and table structures for web applications.

Cloning of all Oracle EBS and DB Instances, Provide EBS patch analysis and apply patches in down time mode, hot patch mode and in patching cycle.

Applying Critical Patch Update (CPUs)/Patch Set Updates (PSU) every quarter using opatchauto/opatch/adop utilities on Database and EBS

Applying Patch Set Updates (PSU) every quarter to Grid Infrastructure

Managing Oracle Grid Infrastructure on On-Premises, Applying Critical Patch Update (CPUs)/Patch Set Updates (PSU) every quarter using Opatch/Opatchauto utilities on Grid and RAC, Adding ASM for data storage to disk groups as per need

DR Exercise Perform planned switchover/failover to physical standby database using data guard broker

Taking RMAN full and incremental backups using ZDLRA, RMAN Catalog and ensuring successful & periodical Backups are available.

Troubleshoot and resolve Oracle EBS related issues like Web services, Forms, WebLogic, Concurrent Manager etc.

Troubleshoot performance issues of slow databases and long running queries, Database monitoring and tuning, application and queries using AWR, ASH, ADDM, OEM and custom scripts.

Cloning database level, schema level and table level of AWS databases

Monitoring and Managing ITIL (Service-Now) tickets like Change Request, Incidents, RITM etc, Documenting Project Operations & Creating a CHECKLIST to ensure a smooth and stable environment.

Provided 24X7 support for multiple Prod/Non-Prod database instances and applications in high pressure intensive multi node environments from 1 TB to 100 TB databases on Linux servers and Exadata

Supporting 100+ Data warehouse databases on Exadata and 300+ on AWS cloud

Supporting 50+ EBS 12.2/12.1 with databases 11g to 19c on Exadata and Linux servers

Responsible for day-to-day activities like cloning, patching and troubleshooting Database and EBS issues

Supporting Grid Infrastructure 12c/18c/19c on-premises Linux servers

Upgrade RAC databases from 11g/12c to 19c on-premises Linux servers and Exadata

Adding ASM for data storage to disk groups as per need

Responsible for Managing/monitoring/upgrading Oracle Grid Infrastructure

Applying Critical Patch Update (CPUs)/Patch Set Updates (PSU) every quarter on Grid and RAC databases

Upgrading Oracle EBS version from 12.1 to 12.2 and periodically from 12.2.6 to 12.2.11

EBS patches, Application TechStack patches, bug fix patches, upgrade patches, interoperability patches etc for US and NLS languages using adpatch/ADOP

Applied Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environment

Implement Parallel Concurrent Processing PCP for concurrent requests, custom tops, DMZ (External nodes)

Built Physical Standby and configure for High Availability/Disaster Recovery purpose

Responsible DR Exercise: Perform planned switchover and failover to physical standby database.

Creating CDB databases and plug PDB's into CDBs, Converting Non-PDBs to PDBs

Database monitoring and tuning, application and queries using AWR, ASH, ADDM, OEM and custom scripts.

Taking backups using Oracle Zero Data Loss Recovery Appliance - ZDLRA, RMAN full and incremental backups and ensuring successful & periodical Backup

Day to Day General Database Administration task like Creating users, Privileges and Roles, Profiles, Segments, Tablespaces, Datafiles, UNDO and TEMP management.

Create table portioning and indexes

Administrating all Database segment growth on Tables, Indexes and rebuilding indexes if fragmented, also doing large tables reorg to get rid of fragmentation.

Making structural changes to the databases when database design changes are to be implemented.

Routine checks on databases. This includes checking whether all databases are running, listener is running, UNIX error messages, disk space availability, CPU & Memory usage, errors in alert logs and trace files, etc using OEM Alerts and cronjobs

Securing Oracle Applications by periodically changing Apps and schema password

Migrating Oracle database from On-Premises to AWS RDS/EC2 includes creating databases and perform DR drills, cloning adding storage etc.

Upgrade Oracle databases from 11g/12c/18c to 19c using AWS console

Installation, configuration, Integration of EBS supporting tools like Appworx (Automation task)

Responsible for regular interactions with the UNIX teams to troubleshoot OS/Hardware issues

Diagnosing Oracle bugs and issues and coordinating with Oracle support to resolve them in a timely manner.

Provides technical support to application development teams in the form of ITIL Service-Now requests.

Responsible to Support more than 500 Oracle databases in Production/Test/QA/Development that includes 24*7 coverage of RAC and Non-RAC databases and multi node EBS 11i/12.1 on Shared Application tier File system.

Responsible for day-to-day activities like cloning, patching and troubleshooting Database and EBS issues and initiating projects like upgrade and migration and documenting the steps

Responsible for Managing/monitoring/upgrading Oracle Grid Infrastructure

Applying Critical Patch Update (CPUs)/Patch Set Updates (PSU) every quarter on Grid and RAC databases, Adding storge to ASM/Disk groups

Upgrading Oracle databases RAC and Non-RAC from 9i/10g/11g/12c

Upgrading Oracle EBS release version 11.5.10.2/11.5.9/11.5.8 and major version from 11i to 12.1

EBS patches, Application TechStack patches, Database patches, upgrade patches, interoperability patches etc using adpatch for US and NLS languages

Responsible for implementing new features like Configure Load balancer, Configure DMZ (External nodes), Parallel Concurrent Processing (PCP)

Built Physical Standby and configure for High Availability/Disaster Recovery purpose

Responsible DR Exercise: Perform planned switchover and failover to physical standby database.

Ensuring successful & periodical Backup using Hot, Cold, RMAN backups.

Day to Day General Database Administration task like Creating users, Privileges and Roles, Profiles, Segments, Tablespaces, Datafiles, UNDO and TEMP management.

Administrating all Database segment growth on Tables, Indexes and rebuilding indexes if fragmented, also doing large tables reorg to get rid of fragmentation.

Making structural changes to the databases when database design changes are to be implemented.

Routine checks on databases. This includes checking whether all databases are running, listener is running, UNIX error messages, disk space availability, CPU & Memory usage, errors in alert logs and trace files, etc using OEM Alerts and cronjobs

Securing Oracle Applications by periodically changing Apps and schema password.

Provides technical support to application development teams in the form of ITIL Service-Now requests.