Nagaraj Ramamoorthy

Provide Technical support to the Infrastructure consulting operations and Migration activities for Oracle Engineered Systems, Exadata and SuperCluster (M7)

Administrated and Maintained Exadata machines with ZFS storage Involved in DR exercise of Oracle RAC databases in Exadata platform Installation, upgradation and patching of databases from Oracle 10g to Oracle 11g / Oracle 12c Tuning of SQL queries and implemented Oracle profiles, using SPM, migrating plans, etc., Worked on Database / schema refreshes in both Exadata and non-Exadata databases Automated repetitive tasks using shell script

Worked as Global Support Engineer, as part of Exadata Platinum Patching team to patch the customer’s engineered system, across the globe Prepared the patch assessment and patch plan for the customer's Engineered System, Exadata and patched their machines

Production support including RAC, Non-RAC Databases with ASM configured in Unix platforms. Applying regular CPU, PSU, DST patch and Database upgrades; Installed OEM 12c and configured metrics for database related targets Automated various tasks like, OEM agent installations, DB refreshes, Consolidated Standby Report from various environments, etc., OnShore assignment in US for a critical project management and delivery in the cloud platform – SDDC.

Migrated Oracle databases from AIX (Single Node) to Oracle RAC (2 Node instances) Configured Oracle ASM using raw devices and multipathing for building Oracle RAC Have worked on 24X7 production support system to administer and maintain Oracle databases for Peoplesoft Applications Have worked extensively on fine tuning Oracle SQLs for Peoplesoft Application

Database refresh – Refresh of Test/Training/Development DBs from Production using Oracle 10g datapump. Implementing changes in Production/Test/Training environments through change control to fix the defects. Administering RAC DBs during maintenance Fine tuning of queries that makes up the stored procedure when the user observes delay in their application jobs in production environment. Administration and Maintenance of Oracle Dataguard – Physical Standby database.

Switching of roles (Role Transition) between Primary and standby databases and performed complete DR testing and rebuilding of Physical standby database Exposure to real Disaster Recovery site(BCP/DR) and worked from DR site during natural disaster Database performance monitoring through OEM or Statspack Report and by generating AWR report. Tuning of SQL and improving the query performance by creating Oracle Outlines Database cloning using hotbackup and complete rebuilding of Logical standby database.

Information Technology Database Management Systems Operating Systems Object Oriented Analysis and Design Data Structures and Algorithm