Shahid Mohammed

Career Summary:

• Having 12 years of experience in Oracle Database Administration and in RAC.
• Experienced in MSSQL Database Administration.
• Working knowledge on MySQL and MongoDB databases.
• Experienced in Oracle E-Business Suite 12.2/12.1 application Administration.
• Expertise in Oracle Exadata Administration.
• Expertise in Performance Tuning.
• Good experience in shell scripting.
• Have done many automations which reduced considerable amount of manual work.
• Expertise in RAC Installations, Upgrades and PSU patching.
• Good experience in OEM 12c/13c.
• Skilled in managing Oracle GoldenGate.
• Worked on Oracle Cloud POC with oracle support.
• Good experience on Archive/Purge projects which reduce the storage and cost.

Summary:

• Having 10 years of experience in Oracle Database Administration and in RAC.
• Experienced in MSSQL Database Administration.
• Working knowledge on MySQL and MongoDB databases.
• Experienced in Oracle E-Business Suite 12.2/12.1 application Administration.
• Expertise in Oracle Exadata Administration.
• Expertise in Performance Tuning.
• Good experience in shell scripting.
• Have done many automations which reduced considerable amount of manual work.
• Expertise in RAC Installations, Upgrades and PSU patching.
• Good experience in OEM 12c/13c.
• Skilled in managing Oracle GoldenGate.
• Worked on Oracle Cloud POC with oracle support.
• Good experience on Archive/Purge projects which reduce the storage and cost.

Oracle DBA Summary:

• Installation of Oracle 10g, 11g and 12c GI/RDBMS software on Linux, AIX, Sun Solaris, Windows.
• Upgradation of databases from lower version to higher version. Recently upgraded databases from 12.1 to 12.2.
• Having good exposure on Oracle database Migration.
• Expert in Data Guard Configuring, Switchover/Failover and maintaining.
• Applied PSU/BP patches on 11g and 12c RAC.
• Forecasting Storage capacity on Weekly Basis.
• Installation OEM Agent and configuring the targets and metrics.

• Providing DBA support to multiple Databases in Production, Development and Test Servers in Linux, AIX, Solaris and Windows environment.
• Configured RMAN Backups and resolving the backup issues.
• Cloning the Database from Production Databases for Dev and testing server.
• As part of routine DBA tasks handling the tickets (Auto generated and customer created).
• Creation of users, Managing roles and profiles in the schemas.
• Creating and managing tablespace.
• Performed table level auditing to track DDL & DML changes.
• Logical backup of databases using Import/Export and Data Pump.


Oracle RAC DBA Summary:

• Installation, Configuration, Maintenance and troubleshooting Oracle cluster Software for Oracle 10g, 11g and 12c.
• Improved performance of the application queries and got lot of appreciations.
• Creating and managing Container and Pluggable databases in 12c.
• Plugging/Unplugging pluggable Database and plugging to another CDB.
• Converting a standalone database to RAC database.
• Adding a node in existing RAC environment.
• Administration of ASM Instances and ASM Disk groups.
• Creating and maintaining the Services Using SRVCTL, DBCA.
• Managing Cluster using CRSCTL.
• Having experience in RAT (Real Application Testing).


Oracle EXADATA DBA Summary:

• Upgraded 11g exadata database(X2-2) to 12c (X5-2) and (X3-2 to X7-2).
• Performed EXADATA HW changes with help of oracle HW support.
• Performed EXADATA storage server (ESS) patching.
• Applied BP & one off patches to EXADATA databases.
• Used EXADATA advances compression to free diskgroup space.

• Installation of Oracle 10g, 11g and 12c GI/RDBMS software on Linux, AIX, Sun Solaris, Windows.
• Upgradation of databases from lower version to higher version. Recently upgraded databases from 11gr2 to 12c.
• Expert in Data Guard Configuring, Switchover/Failover and maintenance.
• Applied PSU/BP/RU patches on 10g, 11g and 12c grid and databases.
• Forecasting Storage capacity on Weekly Basis.
• Installation OEM Agent and configuring the targets and metrics.
• Providing DBA support to multiple Databases in Production, Development and Test Servers in Linux, AIX, Solaris and Windows environment.
• Configured RMAN Backups and resolving the backup issues.
• Cloning the Database from Production Databases for Dev and testing server.
• As part of routine DBA tasks handling the tickets (Auto generated and customer created).
• Creation of users, Managing roles and profiles in the schemas.
• Creating and managing tablespace.
• Performed table level auditing to track DDL & DML changes.
• Logical backup of databases using Import/Export and Data Pump.